Data layer and entity resolution
When are three entries in three systems the same thing?
Why it is hard
The same part has one name in the ERP, another in the PLM and a third in the data sheet. Spellings, revisions and units differ. Merge the wrong records and every later number is wrong.
Our approach
- Every value is a statement with its source, time and confidence.
- A merge is a reversible link, never an overwrite.
- Conflicts between sources stay visible.
Open questions
- How confident must an automatic merge be before a person has to confirm it?
- How does a store of documents become a graph with typed relations?
Diagram
Three systems
- ERPItem 200-17 · Pump P200
- PLMDrawing P-200, rev. C
- Data sheet (PDF)P 200 · 7.5 kW
One record
- Item number
- 200-17ERP
- Revision
- CPLM
- Power
- 7.5 kWData sheet, p. 2




