Enterprise Data Warehouse

Time-series, star-schema and feature store powering analytics & AI

Ingest Rate
42kmsg/s
Storage
18.2TB
Retention
7years
BI Models
612

Data Pipeline

Raw IngestOPC-UA, MQTT, SAP RFC → Kafka topics412M< 200 ms
Time-Series StoreCompressed PLC/tag history (TimescaleDB)3.8B rowssub-second
Curated WarehouseStar-schema for OEE, Downtime, Quality, Energy84M facts< 3s
Semantic LayerCertified KPIs, SAP HANA calc views, BI models612 KPIs< 5s
AI / ML Feature StoreRolling features for prediction & anomaly models1,240 featuresstreaming