website: www.camalot.ca
CAMAlot
An application that uses Firebird extensively. The application actually utilizes 2 separate databases. One to hold data and the other to hold images. The "data" database is typically around 100 to 200 megabytes while the "image" database is anywhere from 500 megabytes to 4 gigabytes, depending on the size of client. The "data" database consists of over 120 tables and 440 stored procedures. All of the business rules and calculation are stored in the database in the form of Check Constraints, Triggers, and Stored Procedures.
This application is Windows Based and is written with C++ Builder. We have approximately 40 installations of our software and will have 70 by the end of the year as we are upgrading clients from DOS and AS/400 Versions of the software.
Our software is used by Property Assessors to calculate property values. In the assessment industry, the term for this type of application is a CAMA System (Computer Assisted Mass Appraisal), thus the name, "CAMAlot". This application is quite large and is quite complicated. The assessor records all the pertinent information about properties in the database. For residential properties, the assessor would record data from the size and style of home, to the number of fireplaces. For commercial properties, the assessor would record data from the size and style of building, to the tenants and rental rates that they pay. For farmland properties, the assessor records the different fields including the type of soil, topography, stones, etc. that may influence value.
If you are a company that resells application software with Firebird as part of the package, and you would like us to provide support to you and your customers, please contact us for further details.