Skip to content

iot

sqllocks_spindle.domains.iot

IoT domain — devices, sensors, telemetry, alerts, and maintenance.

Classes

IoTDomain

Bases: Domain

Internet of Things domain — devices, sensors, readings, alerts, and maintenance.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - device_type: IoT device type catalog (fixed: 20) - location: Deployment locations (fixed: 100) - device: Deployed IoT devices (anchor: 500 small) - sensor: Device sensors (per_parent: device, ratio: 2.5) - reading: Sensor readings (per_parent: sensor, ratio: 20.0) - alert: Device alerts (per_parent: device, ratio: 0.5) - maintenance_log: Maintenance records (per_parent: device, ratio: 1.5) - command: Device commands (per_parent: device, ratio: 3.0)

Methods:
star_schema_map()

Return the star schema mapping for the IoT domain.

Produces
  • dim_device (from device, enriched with device_type)
  • dim_location (from location)
  • dim_sensor (from sensor)
  • fact_reading (from reading)
  • fact_alert (from alert)
cdm_map()

Return the CDM entity map for the IoT domain.

Maps source table names to Microsoft Common Data Model entity names.