SqeezeDat – SQL-based graphic display and data logging software

SqeezeDat is a data base software based on the widely used SQL standard. It was designed to record the data of up to 8 individual Aero-Laser instruments via the RS232 interface. The data can be exported from the SQL data base to ASCII or XML format for further calculations or analysis. SqeezeDat works with all Aero-Laser trace gas monitors. Furthermore it can record data from other non Aero-Laser devices, if they are equipped with a RS232 interface and use a compatible command structure.
While recording, SqeezeDat can display graphically up to 8 parameters in separate windows (Fig. 1). For an enhanced clarity, more than one parameter can be displayed in a single window (Fig. 2).

Fig. 1: Measurement of concentration steps with an AL4021 formaldehyde monitor. Six parameters are displayed in separate windows.
Fig. 2: Calibration of an AL2021 H2O2 monitor. The signals of channel A and channel B are shown together in one window.

SqeezeDat specifications

  • Reads data from up to eight individual Aero-Laser instruments via the RS232 interface
  • Displays data online while recording in a multi-window environment
  • Can display multiple parameters simultaneously within a single window for better comparison
  • Stores all or selected data in a SQL data base
  • Can be extended to non-Aero-Laser instruments, if the instruments are equipped with a RS232 interface and have a compatible serial command structure
  • Can be easily configured – configurations can be saved and restored on hard disk
  • Is extendable by plug-ins

System requirements

  • PC/laptop with MS Windows 98, 2000, NT, XP (recommended) or Win7 operation system in English or German language
  • At least 2GB of free disk space for the SQL data base
  • RS-232 serial port (or USB-to-RS232 adapter), one for each instrument
  • MS dot.net 1.1 and the current dot.net version in the same language as the operating system(3.5)
  • MS SQL server lite or higher

SqeezeDat/Valve software extension – valve sequencer

SqeezeDat /Valve is an extension to the SqeezeDat data base software for the use with an ALV08/12 valve cluster, having 8 or 12 valve ports. Additionally to the parameters of the instrument, SqeezeDat/Valve records a unique identifier for the valve port currently open. The opening intervals and the opening sequence is programmed by a valve sequencer (Fig. 3), which is part of the software package. All valves can be addressed individually and the opening times can be programmed separately for each valve. The valves can be placed in the sequence in an arbitrary order.

Fig. 3: Screenshot of the valve sequencer included in SqeezeDat/Valve. A typical sequence for a setup of 8 test chambers with 1 hour sampling time per chamber is shown. The valve order and the sampling times are free programmable.