Trends

SCADA

Data Base

Data Acquisition

SQL

This trends management program handles field data from one or more acquisition systems, or internal performance data from servers. It manages any kind of periodically updated value in a database, which can be reached by SQL query from the computer on which the program is being run.

Data can be displayed, stored, printed and exported either in graphical or numerical format. The program integrates spreadsheet functions and allows visualization on one or multiple pages. Each graphic can display a maximum of six curves. Trends can be visualized on an hourly, daily, weekly, monthly or yearly basis.

Graphics display point values as they arrive from fields.

It can be useful to follow the trends of data mainly over a long period of time and to store important data for successive review. It can be useful also to follow the relevant parameters of a server to control and optimize the performances in peak activities periods, as can be a sustained alarms period in a supervision system.

The maximum number of points data the program can manage is 10,000. The daily, weekly, monthly and yearly graphics report, on selection, the arithmetic average or the weighted average (hourly average for daily and weekly trends and daily average for monthly and yearly trends). The weighted average is based on the time interval between an upgrade and the next.

The data can be only visualized or also memorized in a historical archive.

Useful to display trends of data coming from different sources with a single program.