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:
- ClearSCADAMetadata.xml—Contains any custom fields created by users (metadata)
- ClearSCADAConfigStr—Contains the structure of the database
- ClearSCADAConfig<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
ClearSCADAConfig0001contains the data for the first 16384 database items created (database item number 0 to database item number 16383), the fileClearSCADAConfig0002contains 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 ClearSCADAConfig<nnnn> files. For example, the file
ClearSCADAData0001contains the values for the database items that have their configuration stored in theClearSCADAConfig0001file. - 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.
NOTE: 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 ClearSCADA Database Schema to access information about the data that each class stores in the configuration and data sections (see Class Information).