Trend Management


Trend Management

Ultimately, the objective of a building automation system is to obtain the highest level of efficiency from each system being controlled.  But how do we know whether we have accomplished this goal?  How can we be sure that the equipment is operating at peak efficiency?  We need data.

OPIX Now! allows for sophisticated data gathering through its trending engine.  Data is collected and stored in a series of Microsoft SQL database tables.  The trend engine will scan the entire database of data points that have been designated as trendable on an interval that is set by the customer (for example: 15 minutes).  This raw data is saved as long as necessary in the databadase table as long as hard drive space allows. 

To account for hard drive space limitations, the trend engine executes a procedure called aggregation.  After a period of time, referred to as the archive duration, which is set by the user (for example: 2 weeks), the trend data is aggregated into three values; maximum, minimum, and standard deviation (click here to learn more about standard deviation).  This is the second trend interval, but instead of capturing the raw data 15 minutes, the aggregated data is captured on a wider time range (for example: every hour).  This procedure is repeated across 5 separate database tables to give the end-user the widest margin of customization.  Data can easily be aggregated and held for 10+ years.

It is also important to understand that the OPIX Analytics engine draws from this trended data to create reports that can display conditional data on multiple levels with multiple filters to paint a true and accurate picture of system performance.