The configuration database is a structured description of the entire automated system. The application 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 instance of the configuration database is in SDF file format of Microsoft SQL Server Compact Edition. After completing the necessary changes an administrator clicks button to convert the database in a specially designed DAT format which is used by the other applications. Such approach allows modifying the configuration database while the software is running.
The configuration database consists of tables, which in turn are composed of columns and rows. Each table belongs to one of the following groups:
The following table describes the configuration database tables.
Table Name | Description |
---|---|
System Group | |
Objects | Contains logical objects which input data and commands are related to |
Communication lines | Describes communication lines which are used to exchange data with devices |
Devices | Contains real or virtual devices |
Input channels | Defines data received from the devices and data calculated on their base |
Output channels | Specifies commands executed by the system |
Roles | Contains roles. Each role defines a set of functions available to users |
Users | Contains a list of users of the system and their roles |
Interface | Contains descriptions of interface objects (views, reports and data windows) which require different access rights |
Rights | Defines relationships between the roles and the interface objects |
Dictionaries Group | |
Channel types | Dictionary of input channel types |
Command types | Dictionary of command types used by output channels |
Event types | Dictionary of system event types which correspond to the input channel statuses |
Device types | Dictionary of device types that can be connected to the system |
Quantities | Dictionary of measured quantities |
Units | Dictionary of units of input channel values and enumerable values of input channels |
Command values | Dictionary of enumerable command values which are transmitted by output channels |
Number formats | Dictionary of formats which are used to display input channel values |
Formulas | Dictionary of formulas used in calculation of input channel data and command values of output channels |
The following list is a sequence of working with the configuration database in the Administrator application:
It is possible to significantly speed up a process of system configuration by using the past works. The Export and Import features allow exchanging data between different databases. These features are accessible in Database menu. Data tables are exported to DAT format files, then the information can be imported from these files into the same or another configuration database. A range of exported and imported data can be restricted by specifying the start and the final identifiers (see Figure 1). In addition, if a new start identifier is specified, identifiers of the imported data are shifted.
Figure 1. Import into the configuration database
The Create channels feature (see Figure 2), which is accessible in Service menu, allows automatic filling the Input channels and Output channels tables using information about existing objects and devices. Rules for creating channels are defined in device libraries (drivers) of Communicator. The device libraries are located in C:\SCADA\ScadaComm\KP\ by default. If a DLL file, specified in the Device types table, does not exist, the creation of channels corresponding to that device type is impossible. Channels are created according to the settings of Communicator.
To create input and output channels, tick the appropriate devices, choose or keep undefined the object for the each device, click the Calculate channel numbers button, check the calculated numbers, then click the Create button.
Figure 2. Create channels feature
The Clone channels feature (see Figure 3) is also designed to make the process of creating input and output channels faster. The objects and the devices of the cloned channels can be replaced by the specified values during cloning.
Figure 3. Clone channels feature
Editing of input channels may be done either directly in a table or by using the form that is shown in Figure 4. Right click an input channel row to show popup menu and click the menu item to open this form.
Figure 4. Editing input channel properties
The Compact database feature decreases the size of the configuration database file. Use this feature when the database editing has been completed. To execute the feature click the Database > Compact main menu item.