Xylem WQL-Cond CONDUCTIVITY DATALOGGERS - Manual (Page 63)

WQL-Cond Working with the database and measurement data
159 ba75822e01 03/2011
9 Working with the database and
measurement data
9.1 General information on the database
The WQL-Cond logger can generate large amounts of measurement data,
which can subsequently be stored, managed and used for evaluation with the
WQL-Log program. The WQL-Log program uses the Microsoft SQL Server
2005 Express database for this. All generated measurement data are
provided with additional information (such as measurement ID, sensor) and
stored in the currently connected database.
Database storage considerably differs from the file-based storage known
from one's daily PC work with word processing or spreadsheet programs. A
database is created and managed by a program, in our case WQL-Log. The
WQL-Log program creates several files and works with them.
With a database you can use queries to select/filter certain events from the
stored measured values. You can e.g., search for measured values from
certain periods or individual locations. This enables the secure and user-
friendly handling of large amounts of data.
Warning
z Always use the WQL-Log program to make any changes on the
database (such as creating, erasing, saving, restoring a database).
z Never erase any files created by the WQL-Log program with another
program (e.g. with MS Windows Explorer). In this case, WQL-Log might
not be able to access the database and the stored data are lost.