AirWare On-line Manuals: time-series data import

Shared Tools: Reference Manual

Release Level	5.4
Release Date	2008 10
Revision Level	1.0

Last modified on: Friday, 5-Sep-08 12:06 CEST

Automatic Time Series Data Imports

Time Series in AirWare are by default of hourly resolution.

Import Dialog

Time series data can be imported

manually, bulk, for larger data sets or to create a new time series;
manually, for small additions/corrections to add or replave selected data;
automatically, from any local or remote data base, in real-time.

Real-time data import:

For a given monitoring station, a real-time connection to a (remote or local) data base that holds real-time monitoring data can be defined.

For the real-time data acquisition, paramerts include:

User name and pasword for data base access;
IP address of the data base server;
Data base type (ORACLE, MySQL, PostgreSQL);
Data base and Table names; these will be used for all parameters that do not have specifc, individual data base and table names defined;
Date and time column names;
Time shift: delay in minutes after the full hour, when the data acquisition will be attempted;
Status to switch the import on or off.

followed with a list of parameters (time series) defined for this monitoring stations, where for each parameter the data base, table, column name as well as a condition (SQL WHERE clause) can be defined