Data tables you will receive
When exploring Nexalis data, you will have access to two core standardized tables:gold_<user_name>_avg_std— Contains raw and standardized data, aggregated in X-minute intervals (X-minute interval is a parameter of the Nexalis Agent). Includes minimum, maximum, count and average values. Does not include discrete tags.gold_<user_name>_hf_std— Contains raw and standardized high‑frequency data (per‑second). Includes discrete tags (e.g., booleans and enumerations for alarms and codes)
Transformation adds standardized columns for cross-vendor comparison and values are scaled to the data model units.
Tip: To filter only standardized tags, use a condition like dataObject != null in your queries.
Comparison of Tables
| Table Name | Data Frequency | Aggregation | Discrete Tags | Best For |
|---|---|---|---|---|
gold_<user_name>_avg_std | X‑minute intervals (per‑Nexalis agent configurable) | Aggregated (min, max, avg, count) | No | Trend analysis, reporting, standardized analog data |
gold_<user_name>_hf_std | High frequency (per‑second raw data) | None (raw values) | Yes | AI/ML, alarms, troubleshooting |