Data collection and summary

The collection of some types of data (such as event messages and communication statistics) and their transfer into Historical is performed automatically. However, the collection of data from Analog, Rate, Remote, and Status tables can be configured.

Data Collection

For more information about data collection, the Collect table and collect records, refer to volume 1 of the AVEVA Enterprise SCADA RealTime Administrator documentation.

Data Summary

Summarization of data is performed in both the Timeline and Accum databases. Data summary can be done for each point on collect. For more information, refer to volume 1 of the AVEVA Enterprise SCADA RealTime Administrator documentation.

At the start of each hour, data collected in the RealTime database (RTDB) collect table is examined and the following are determined:

• The current value.

• The maximum value that is reached during the hour.

• The minimum value that is reached during the hour.

• The average rate for the hour, if the Enable Averages checkbox is selected on the Rate Averages and Integration dialog box (refer to volume 1 of the AVEVA Enterprise SCADA RealTime Administrator documentation).

Timestamps and the data quality status of collected values are also recorded. These are stored in the Hour table of the Timeline database. For the average, the data quality status is the highest-precedence status over the hour. For example, an alarm (A) status is considered a higher-precedence status than manual (M).

Similarly, at the start of each hour, data in the Hour table of the Timeline database is examined and the following are determined:

• The current value.

• The maximum value that is reached during the hour.

• The minimum value that is reached during the hour.

• The average rate for the hour, if the Enable Averages checkbox is selected on the Rate Averages and Integration dialog box (refer to volume 1 of the AVEVA Enterprise SCADA RealTime Administrator documentation).

Maximum, Minimum and Average values are initialized at the start of each hour and updated throughout the hour.

Timestamps and the data quality status of these values are also recorded. These are then stored in the Day table of the Timeline database. A new day record is created as soon as the day starts. The day record is also updated each hour.

Similarly, at the start of each day, the hour data is examined and the summaries in the Month table of the Timeline database are updated. Also, the month data is examined and the summaries in the Year table of the Timeline database are updated. (As with day records, a new month and year record are created as soon as the month or year starts. These are also updated daily).