Equipment data warehouse
PsODSDifferent properties. Clearly organized records.
Use common equipment-data storage standards to persist different device properties in a unified architecture, with transfer and distribution for subsequent business use.
Keep the information and the context to read it
Unified information architecture
Retain device identity, property meanings, data types and units to organize different equipment data consistently.
Persistence, transfer and distribution
Persist equipment information and provide the fields and periods needed for subsequent business use.
Product demonstration · Device properties and timestamps
Change the device and the reading purpose
Environmental sensors and door contacts have different properties. Latest-record and history views answer different questions.
ENV-01Environmental sensor · Most recent record
Inspect the values saved at 08:10 together with their record time.
- Temperature / °C
temperaturenumber- Relative humidity / %
humiditynumber
2026-01-01 · +08:00
| Time | Temperature°C | Relative humidity% |
|---|---|---|
| 22.4 | 51 |
Latest records provide device identifiers, property values and timestamps for daily review.
Confirm how the latest record is selected, event versus receipt time, update and backfill rules, and access permissions.
ENV-01Environmental sensor · Historical records
Inspect property changes at 08:00, 08:05 and 08:10.
- Temperature / °C
temperaturenumber- Relative humidity / %
humiditynumber
2026-01-01 · +08:00
| Time | Temperature°C | Relative humidity% |
|---|---|---|
| 21.6 | 52 | |
| 22.1 | 51 | |
| 22.4 | 51 |
Historical detail retains equipment, periods and property definitions for analysis and later use.
Confirm period boundaries, retention, query scope, duplicates and missing reports; analytical model transformation is separate downstream work.
DOOR-01Door-contact device · Most recent record
Inspect the values saved at 08:10 together with their record time.
- Door-open record
door_openboolean- Battery level / %
battery_pctnumber
2026-01-01 · +08:00
| Time | Door-open record | Battery level% |
|---|---|---|
| falseClosed | 83 |
Latest records provide device identifiers, property values and timestamps for daily review.
Confirm how the latest record is selected, event versus receipt time, update and backfill rules, and access permissions.
DOOR-01Door-contact device · Historical records
Inspect property changes at 08:00, 08:05 and 08:10.
- Door-open record
door_openboolean- Battery level / %
battery_pctnumber
2026-01-01 · +08:00
| Time | Door-open record | Battery level% |
|---|---|---|
| falseClosed | 84 | |
| trueOpen | 84 | |
| falseClosed | 83 |
Historical detail retains equipment, periods and property definitions for analysis and later use.
Confirm period boundaries, retention, query scope, duplicates and missing reports; analytical model transformation is separate downstream work.
Two devices, two properties each and three times produce 12 property records. Boolean values describe the door-open record.
Download property records CSVApplication scenarios
Provide records for the consuming workflow
Daily operational review
Read the latest saved values with their record time, distinguishing event time from receipt time.
Period detail for analysis
Retain equipment, properties and periods for later analysis. Transformation into a target analytical model is separate downstream work.
PsODS
Define storage and access from the properties
Share device types, record times, retention needs and readers to agree information rules and delivery scope.