A Microsoft SQL database stores the BAS and other control system parameters that are mapped to the system. The data is stored for a period of three years from the date of implementation. OBEM has adequate provision for back-up and restoration of the system database.
The database is of industry standard, supporting the SQL, and provides for the storage of equipment parameters data, run hours, point data, events, and performance data. It is stored in a system database.
The database is scalable continues to operate efficiently with up to 2500 controllers and 6000 meters connected to the system.
The database stores data in an efficient manner to minimize total space consumed. Repetition of data in or across the tables is avoided.
The database stores all data retrieved from devices and meters and generated by the system including:
- Trend logs with time stamps
- After Hours usage including:
- Time started
- Duration
- System faults
- Trend logs
The database can store calculated data for the following types of source data:
- Instantaneous data points
- Incremental data points
- Status data points
- Trigger points
- Totalization points
The historical database provides tables for definition of parameters that are entered manually or imported. These parameters include, but are not limited to, the following:
- Building and tenancy area
- Energy cost parameters
- Weather data using web services from weather information feeds
- Energy and power specifications for connected equipment
- Coefficient for greenhouse gas equivalents
- These parameters are used in the reporting system to drive values for energy reports
- The user is able to manually select the storage location for the archive files, such as network drives, CD, DVD or removable disk drives.
Raw data visualization is available for online meter points and equipment points mapped in the application, so the user can troubleshoot the meters and equipment while commissioning.