Configuration Database
Database Model
The configuration database is a part of the project, consisting of tables and common to all project instances. The applications included in Rapid SCADA use the information from the configuration database in conjunction with their settings.
The configuration database is edited using the Administrator application. The edited copy of the configuration database is in XML file format. When a project is uploaded to a server for execution, the configuration database is converted into a special DAT format.
The configuration database consists of tables, which in turn are composed of columns and rows. Each table belongs to one of the following groups:
- Primary tables. This group contains the tables that define the operating of a particular project.
- Secondary tables. During the development of the project, minor additions are made to the tables in this group.
The following is a list of configuration database tables with a brief description.
Primary Tables | |
Objects | Contains logical objects that are used to structure information in the system and manage access rights. Objects can be hierarchical |
Communication lines | Describes communication lines that group devices and determine the polling order |
Devices | Contains a list of physical or virtual devices |
Channels | Channels are necessary for storing measured data, mathematical calculations and sending commands |
Limits | Contains a list of limits for channel values |
Views | Contains view attributes and specifies the structure of the view tree |
Roles | Contains a list of user roles. A role is a set of access rights. Do not change or delete the built-in roles |
Role inheritance | Allows to configure a parent role based on the rights of child roles |
Object rights | Defines rights of custom roles on objects |
Users | Contains a list of users with their roles. The Password column stores password hashes |
Secondary Tables | |
Archive kinds | Dictionary of archive kinds |
Archives | Dictionary of archives. The archives in the table correspond to the archives in the Server settings |
Channel statuses | Dictionary of channel statuses. Among other things, it sets the match between a channel status and some event parameters |
Channel types | Dictionary of channel types |
Data types | Dictionary of data types |
Device types | Dictionary of device types (drivers) |
Formats | Dictionary of formats used when displaying channel and command values |
Quantities | Dictionary of quantities |
Scripts | Dictionary of scripts and formulas used in calculating channel and command values |
Units | Dictionary of units |
View types | Dictionary of view types |
Editing Database
The configuration database tables are related to each other, that is, a cell of one table can refer to a record of another table. For example, a device refers to a communication line to which it is connected. Therefore, it is efficient to edit tables in a certain sequence. For tables from the Primary tables group, enter data in order starting with the Objects table and ending by the Users table.
The Administrator application provides tools that make editing the configuration database faster and handy:
- The search and replace dialog is called by the
button, which is located on the application toolbar, or by the keyboard shortcut Ctrl + F.
- Filtering a table hides unnecessary rows. If the table is filtered, search and replace is performed only on the table rows that are displayed. The filter window is called by the
button.
- When editing table cells, use the functions cut Ctrl + X, copy Ctrl + C and paste Ctrl + V. That functions can also be applied for cells whose values are selected from a drop-down list.
- Clicking a column header sorts the rows in the table by the values in that column.
- If the properties button is displayed on the table toolbar, then the rows for that table can be edited using a dialog form.
- The wizards, which are called up with the
,
and
buttons located on the main toolbar, help to quickly fill out the Communication lines, Devices and Channels tables.
- The channel cloning tool is useful for populating the Channels table if the system contains many similar devices. The tool is available through the main menu Tools > Project Tools > Clone Channels.
- Using the table import and export functions, you can transfer previously completed work between projects. XML, CSV and DAT data formats are supported. The functions are available in the main menu section Tools > Project Tools.
- The integrity check tool helps ensure that the relations between the tables are valid and that table foreign keys point to existing records.