docs / data

Data

Source definitions, layer schemas and OLAP model.

Data sources

3

Sensor types

6

Silver tables

4

Gold tables

5

reference

Data Structure

All sources, field definitions, Bronze / Silver / Gold schemas.

—MySQL DB (pidb) — static metadata
—JSON sensors — real-time, every minute
—Weather CSV — daily sFTP download

olap model

Star Schema

Fact and dimension tables for the Gold layer.

—fact_energy
—fact_occupation
—fact_environment
—fact_sensor_reliability
—fact_ml_predictions

layer status

BronzeFile system — timestamped JSON/CSV
designed
SilverPostgreSQL — 4 tables
designed
GoldPostgreSQL OLAP — 5 fact tables
designed
MLscikit-learn + statsmodels + KNIME
planned
BIPower BI (energy, env) · SAP SAC (presence)
planned