Data Table Timestamps and Quality

Each data table can include metadata in addition to the actual data contained in each row and column, namely a quality code and a timestamp. These metadata are transferred and stored with the data table, and are useful when analyzing and visualizing the values of the table.

A quality code is an integer value associated with each data table that indicates the level of reliability and validity of the table data. These codes categorize data into three primary groups: "Good", "Uncertain", and "Bad". This classification allows users to distinguish between high-quality data, questionable values, and unreliable information.

Quality codes are typically assigned to device variables by either the physical device, the device driver, or by Iotellect core in some situations. However, data table quality may be manipulated by the user application logic, and namely getQuality() and setQuality() expression language functions. See variable value timestamps and quality codes for more information.

For a list of the specific quality codes employed by Iotellect and their corresponding interpretations, please refer to the dedicated Appendix on Quality Values.

Alongside the quality code, each data table also carries a timestamp. The timestamp indicates when the data point was generated (if possible) or the time the data table was saved to the database. Timestamps provide context for interpreting data, for example when analyzing variable history. They can be addressed and manipulated by getTimestamp() and setTimestamp() expression language functions.

Was this page helpful?

Tell us more

Send

Thank you!