Skip to content

Dimension — source

Three sources, a pump in each. How many pumps?

Anyone who has reconciled stock has been burned by this one. The maintenance system, the ERP and the planner’s sheet each hold a pump. Add them up and you have three. There is one — and none of the three can tell you so on its own.

MRO SYSTEMS/N 3196 · unserviceableKEY · ACCEPTsame P/N + S/NERP · STORESbin A-22 · 1 unit · available0.62 → ACCEPTconfirmed · planner, 3 OctPLANNER’S SHEETrow 14 · S/N 3196 · planner, 3 OctKEY · ACCEPTsame S/NONE PUMPS/N 3196 · three recordsbound · the records disagreeACCEPT ≥ 0.90 · REVIEW ≥ 0.60 · A PERSON’S CONFIRMATION OUTRANKS A SCORE
[ plate III · three records, one pump · illustrative values ]

The usual answer is a master data project: pick a winner per field and declare a golden record. Done well, it keeps the lineage. In practice the losing versions stop being consulted, and when the mapping is wrong, finding out that it is wrong is a forensic job rather than a query.

Selira does it the other way round. Each system’s record is kept as its own record, with its origin attached. Where several records describe the same real thing, they are bound together — and the binding says why, and how strongly: a shared serial, say, or a person’s confirmation.

So the count resolves honestly. Three records bound to one pump answer one pump, held in three places — and where they disagree about it, you see that too. Three records bound to three separate pumps answer three pumps. Same shape of question, different answer, and you can see which it was.

What you get instead of a golden record

Disagreement stays readable: both versions, and who said each

Bound · agree

One thing, one story

The records are bound to the same thing, above the floor you asked for, and what they say agrees. Nothing to look at.

Bound · disagree

One thing, two stories

The same pump, unserviceable in one record and available in another. Both versions kept, with who said each and since when — never silently resolved.

Review

The match is uncertain

A match nobody is sure of yet. Offered to a person to confirm, never merged on your behalf.

Each question sets the floor it accepts. Raise the floor and fewer matches qualify: only the certain ones collapse into one pump, and the rest stay beside the answer as unconfirmed candidates — never silently merged, never silently counted. That is the difference between a stock figure you would sign and one you would not.

Nothing is overwritten, so nothing is lost

Because each source keeps its own record, Selira never needs to overwrite one system’s version with another’s. Where a system of record exists, it stays the system of record; where three compete, all three are kept. And a source need not be a system: the planner’s spreadsheet is kept whole, with who brought it in and when, and its rows standing beside the systems’ records is in build. Certificates and supplier email come after.

That also makes the model honest about its own limits. Every statement keeps when it was made, so a figure nobody has confirmed since March reads as March’s, rather than aging into a confident one.

And when somebody challenges a figure — an auditor, a customer, a colleague — the chain back to whichever source said it is there to walk, as complete as the origins that came in with it.

Bring the number nobody trusts.

We will show you which systems said it, how strongly they are bound, and what happens when you move the floor.