Data Identification
Every variable stored in Mervis DB is identified by set of keys and values. Combination of of keys and values marked with attribute “IsKey=true” defines unique identification of variable (equivalent to primary key known from SQL world).
Keys
Any string that consists of characters: a-z, A-Z, 0-9, ., _, - can be used as a key. The key must not start with underscore (“_”) character and must not be empty.
Values
Any string that consists of characters: a-z, A-Z, 0-9, ., _, - can be used as a value.
Recommended Keys
It's recommended to use the following structure of keys and values for new projects and Mervis DB clients.
| Key | Value | IsKey | Description |
|---|---|---|---|
| DataSource | “MyDS” | False | Unique identification of the particular data source type. |
| Root | “MyDsServer1” | True | Unique identification of the particular Mervis DB client. |
| Guid | “var546” | True | Unique identification of variable generated by Mervis DB client. |
| Level1 | “MyLevel1Id” | False | |
| Level2 | “MyLevel2Id” | False | |
| Level3 | “MyLevel3Id” | False | |
| Level4 | “MyLevel4Id” | False | |
| Level5 | “MyLevel5Id” | False | |
| Name | “My Variable” | False | |
| Unit | “m3” | False |
Example
| Key | Value | IsKey | Description |
|---|---|---|---|
| DataSource | “SCADASystemXY” | False | Unique identification of the particular data source type. |
| Root | “Server18” | True | Unique identification of the particular Mervis DB client. |
| Guid | “aaaaa-bbbbb-ccccc-ddddd-eeeee” | True | Unique identification of variable generated by Mervis DB client. |
| Level1 | “SiteNr500” | False | |
| Level2 | “Building A” | False | |
| Level3 | “Floor 7” | False | |
| Level4 | “Room 17” | False | |
| Level5 | “SouthEast” | False | |
| Name | “Indoor Temperature” | False | |
| Unit | “C” | False |