Warehouse · 02 of 04

The warehouse that never forgets.

Store, organise, back up, and serve every sensor reading across your estate. Cloud or on-prem. Hot, warm and cold tiers. REST and GraphQL APIs. The single source of truth between your sensors and every platform that queries them.

MUSA Data Management is the data warehouse that sits at the center of the MUSA pipeline. The Integrator pushes data here; View, Assistant, and analytics workloads pull from it. It is the single source of truth, every sensor reading, every calibration event, every submission receipt, stored, indexed, and available through APIs.

Deploy it as a managed cloud instance on GCP or Tencent Cloud, or run it on-premise for estates with air-gapped or low-latency requirements. The warehouse is regulation-aware out of the box: KLHK retention periods, audit logging, and data-lineage tracking are built in, not bolted on.

Every solution in the MUSA catalogue SISPEK stack emissions, SPARING wastewater, ISPU ambient air, carbon ledgers lands in Data Management first. From there, it is queried by View dashboards, Assistant agents, and third-party BI tools through the same REST and GraphQL endpoints.

Features

Built for environmental telemetry at scale.

Time-series optimised storage

  • Columnar compression reduces storage footprint by up to 90%
  • Automatic partitioning by site, sensor type and time range
  • Sub-second queries over billions of records
Query performance
0.31 sec
over 2.4B records, auto-partitioned

Hot / warm / cold tiering

  • Hot: 18 months full resolution (1-second to 1-minute)
  • Warm: 5 years at 5-minute roll-ups
  • Cold: 10+ year compliance archive at hourly
HOT18mo
WARM5yr
COLD10yr+

REST & GraphQL APIs

  • REST v2 for straightforward time-series reads
  • GraphQL for multi-sensor, cross-site nested queries
  • Rate limiting, API key management, full audit trail
query StackReadings {
stack(id: "A1") {
so2, nox, flow
}
}

Backup, restore & disaster recovery

  • Cross-region asynchronous replication
  • Point-in-time recovery for any timestamp window
  • Automated daily integrity checks with alerting
JAKARTA
RPO < 5 MIN
SINGAPORE
✓ INTEGRITY CHECK PASSED · 03:00
Technical specs

Under the hood.

Deployment Managed cloud (GCP / Tencent) · Private cloud · On-prem (VM or bare-metal)
Storage engine Columnar time-series (custom) · Relational metadata (PostgreSQL)
Ingestion MQTT · HTTPS/REST · OPC-UA · Batch CSV/IMPORT
Query APIs REST v2 · GraphQL · SQL (analytics workspace)
Retention (hot) 18 months full resolution
Retention (warm) 5 years at 5-min roll-ups
Retention (cold) 10+ years compliance archive
Replication Cross-region async · RPO < 5 min
Security TLS 1.3 · AES-256 at rest · RBAC · SSO (SAML/OIDC) · Audit log
Compliance GDPR-ready · Indonesian PDP Law compliant
Uptime SLA 99.95% (managed cloud)
Works with

Solutions whose data lands in MUSA Data Management.

How it works

From provisioning to production in four steps.

1. Provision & configure

Cloud project setup, tenant creation, security policies, network peering (if on-prem). Storage tiers sized to your sensor count and ingestion rate. Done in days, not months.

2. Connect edge sources

MUSA Integrator pairing, sensor registry population, data model mapping. Each stack, outfall, AQMS node and meter is registered with its metadata, location, and regulatory context.

3. Validate & reconcile

Data quality checks, gap detection, calibration metadata import. We reconcile the first 30 days of data against source records to confirm completeness and accuracy.

4. Operate & scale

Continuous monitoring, retention lifecycle management, quarterly compliance reconciliation. Add new sensors and sites without re-architecture. The warehouse grows with your estate.

Start with your sensor inventory

A 30-minute architecture review, tailored to your estate.

Send us your stack, outfall and AQMS inventory. We'll draft a Data Management deployment architecture, cloud, on-prem or hybrid, and walk through it with your team.