Database
The purpose of the database is to store all site/machine dependend information. This information includes addressing, conversions, hardware descriptions, software setup, console pages etc. The database is not intended for storage of current data values. Therefore, a relative slow commercial relation database can be used. Access to the database from the laboratory system is based on ODBC. Although this is slower than direct access to a database, this choice is preferable because of the freedom to choose any ODBC database. In a multi-user, multi-machine environment, like ASTRID, the SQL-Server from Microsoft is a perfect choice. For a minor/standalone system Microsoft's Access can be used.
Data definition and access to the laboratory system tables is implemented in a library, database.dll. This library includes major classes used for addressing and data encapsulation. All access to the system tables must go through the ConSys system class, CCsDatabase.
Reference:
CcsDatabase, the class encapsulating the database accesses.
Last Modified 11 January 2019