Partially embedded database and an embedded database manager for a control system

摘要

A data storage system includes a database that is configured as a static data file containing static data and a dynamic data file containing dynamic data. The static data file is stored in a static memory device and the dynamic data file is stored in a dynamic memory device. A catalog included in the database defines whether the data is static or dynamic and further defines an arrangement of a set of data fields and data records included in the database. A database manager uses a file system to access the files in a rapid manner using an address pointer and, because the data is stored in files, the data may be accessed remotely without need for additional communication strategies/protocol. To enable editing of the static data, the database manager creates a mirror image of the static data in the dynamic memory where editing may occur. The mirror image of data having the edited data is later returned to the flash memory. A database generation tool ensures that Boolean data elements are efficiently stored in the database by causing all of the Boolean elements to be collectively stored in one or more data fields.