United Manufacturing Hub with TimescaleDB

Overview

United Manufacturing Hub Classic includes TimescaleDB as its built-in time-series database, providing SQL-compatible storage for industrial historical data.

Integration Architecture

TimescaleDB in UMH serves as:

• The primary historian for time-series manufacturing data
• SQL-compatible query interface accessible from Grafana
• Hypertable-based storage optimized for high ingestion rates
• Long-term data retention with compression policies

Use Cases

• Storing years of sensor readings with efficient compression
• Running SQL queries directly on production data from Grafana
• Building reports combining real-time and historical metrics
• Supporting regulatory compliance with audit trails

Configuration

UMH Classic automatically configures TimescaleDB with:

• Pre-configured hypertables for common industrial data types
• Retention policies matching manufacturing requirements
• Integration with the UNS topic structure
• Backup/restore procedures for production deployments

Tradeoffs & Considerations

• PostgreSQL foundation: Requires PostgreSQL expertise for administration
• Query performance: Complex queries on large datasets may need optimization
• Alternative: UMH also supports output to other databases via connectors