In order to successfully use Info360 Insight, it is important to understand the data sampling process that is used.
Raw SCADA data typically comes in varying time steps, which can be inefficient for analysis and display at varying time scales. Info360 Insight samples the raw data at specific intervals and stores it as explained below.
For each interval, the following five summary values are stored in the Info360 Insight database.
Type | Description |
---|---|
Open |
The first value in each interval. |
High |
The highest value in each interval. |
Low |
The lowest value in each interval. |
Close |
The final value in each interval. |
Average |
The average value for each interval. |
Generally, Close is used for viewing real-time data (to see the latest values), High and Low are used in alerts and summary analysis, and Average is used with flow and volume analysis.
Info360 Insight builds sampled data tables for each sensor down to the minimum interval set for the sensor. The Open, High, Low, Close, and Average values are stored at the end of each sample interval (hourly, daily, etc.). For example, the data between 0:00 and 0:05 are sampled and summarized at 0:05.
The following tables illustrate how an hour's worth of raw SCADA data is built into data tables for 5-minute and 15-minute intervals.
For larger intervals, note how the sample tables are built. For a daily interval for example, the Low daily value reported at 0:00 on 1 April comes from the data sampled between 0:01 on 31 March and 0:00 on 1 April. So, each value summarizes the previous day.
Often, SCADA data can be prone to noise and gaps in data. To address this, Info360 Insight allows you to configure value mapping.