resolution
Store what the sensor said
Full source rate rather than an average of it, with retention set per signal — keep years of the coarse channels and weeks of the fast ones, without averaging either.
cardinality
Every tag, every asset
Hundreds of signals times thousands of assets is millions of series. That is a normal table here, not a capacity planning exercise.
comparison
The whole fleet in one pass
Scoring every asset against its cohort is one read rather than one query per machine — which is what turns a nightly report into something you can ask on the way to a decision.
signatures
Find it everywhere it happened
Take the shape that preceded one failure and search every asset and every month for it — the query that only exists if the raw readings were never thrown away.
deployment
At the site, not just the centre
One small binary runs at a substation or a depot with intermittent backhaul, and the same engine runs centrally. Same queries either end.
agents
An engineer that reads everything
Point an agent at the asset record and let it work through a fault across telemetry, work orders and parts history, under a key scoped to what it may see.