Skip to main content
DB
Back homeIndustry

Manufacturing

Line and OEE telemetry, quality-gate state and downtime analytics on one engine, with one keyed row per cell that each plant system extends with its own slice.

The problem

Where the usual stack breaks

  1. 01

    A production line emits a continuous stream of machine, sensor and quality-gate events, and the questions that matter are immediate: which cells are down, which lines are below OEE target, which gate just started failing.

  2. 02

    The common stack routes telemetry into a historian, current state into a cache and analytics into a warehouse: three systems whose disagreement shows up as a plant dashboard that trails the line it monitors.

  3. 03

    You want one engine that stores line telemetry durably, keeps one row per cell that the MES, the quality station and the maintenance system each own a part of, and computes rollups in the same SQL.

Where NYXDB fits

Use-case journeys

Architecture

How NYXDB fits the plant floor

Machine and quality events land in one durable table; a transformation folds them into one slice of the cell table; other plant systems write their own slices of the same row; new slices are added live with ADD ATTRIBUTE GROUP.

  1. 01

    Ingest

    Every machine and quality event is durable before it is acknowledged.

  2. 02

    Cell state

    One keyed row per cell; a fold owns the activity group.

  3. 03

    More producers

    A new plant system gets its own slice of the row while the fold keeps running, with ALTER TABLE … ADD ATTRIBUTE GROUP.

  4. 04

    Live streams

    Cell-state changes reach plant dashboards as they commit, with STREAM SELECT.

In practice

Representative statements

The examples use the same two tables on every page. See the SQL reference for full syntax.

Current balances of one address
SELECT address, token, amount, updated_at
FROM balances
WHERE chain_id = 1 AND address = '0x9c2e4f1a';

Capabilities

What you get out of the box

Durable ingest

Writes persisted before acknowledgement.

Attribute groups

Each plant system owns a slice of the cell row.

Live schema growth

Add a slice to the row while transformations keep running, with ADD ATTRIBUTE GROUP.

Simple deployment

A container image or a Kubernetes manifest.

Learn more

Telemetry your plant can query

Explore IoT & telemetry or run a node.