The information in the database is organized into three sections:
- Configuration—This section contains the configuration for the database items. There are usually infrequent changes to the data in this section after the initial configuration has been setup. The configuration data is stored in three different types of file:
- Geo SCADA ExpertMetadata.xml—Contains any custom fields created by users (metadata)
- Geo SCADA ExpertConfigStr—Contains the structure of the database
- Geo SCADA ExpertConfig<nnnn>—These numbered files contain the configuration data for a set of database items. Each file can contain the configuration data for up to 16384 items. The file
Geo SCADA ExpertConfig0001contains the data for the first 16384 database items created (database item number 0 to database item number 16383), the fileGeo SCADA ExpertConfig0002contains the data for items 16384 to 32767 and so on.
- Data—This section contains the values for the items in the database. There are frequent changes to this section as the values are updated regularly. The values are stored to disk in files that are numbered in the same way as the Geo SCADA ExpertConfig<nnnn> files. For example, the file
Geo SCADA ExpertData0001contains the values for the database items that have their configuration stored in theGeo SCADA ExpertConfig0001file. - Dynamic Data—This section contains the values for the items in the database that are not stored to disk, for example, the 'state' of a channel. Dynamic data does not persist after the system is shutdown. Dynamic data is not stored to disk.
The file names for the configuration and data sections are variable and so, on your system, may have been changed from the default names shown above.
You can use the Geo SCADA Expert Database Schema to access information about the data that each class stores in the configuration and data sections (see Class Information).