Lesson 3 — Master Data: Authority, Trusted Sources, and Golden Records
Master Data represents persistent core business entities reused across processes and systems. The hard exam questions are rarely “is Customer Master Data?” They ask where authority sits or how to describe a reconciled result without overstating certainty.
Master Data is not “all important data”
Master Data identifies and describes core entities. A payment can be extremely important and still be Transaction Data. A regulatory classification can be extremely important and still be Reference Data.
Common Master domains include: - Party: customers, suppliers, employees, organizations; - Product/service; - Location; - Financial structures/accounts; - Legal entities and relationships; - enterprise-specific core entities and directories.
A useful nuance: Product can be Master Data while Product Category is Reference Data.
System of Record (SOR)
The System of Record is authoritative for creation/capture and/or maintenance under defined rules.
Ask:
Where does the official write originate or where is the data officially maintained?
If CRM creates and maintains customer records, CRM may be the customer SOR.
System of Reference
A System of Reference is authoritative for consumer access to shared data.
Ask:
Where should enterprise consumers obtain the governed shared view?
An MDM hub can be the enterprise customer System of Reference even when CRM remains the SOR.
Why the words are confusing
Both systems can be called “authoritative,” but for different activities: - SOR = write/maintenance authority; - System of Reference = read/consumption authority.
One system can play both roles, but the terms are not synonyms.
Trusted Source
A Trusted Source is the governed best-available source or view for a purpose. It is a safer phrase when the data is reconciled and controlled but cannot reasonably be claimed to be perfect.
Trust comes from evidence: source authority, Data Quality assessment, preparation, matching, survivorship, stewardship, and governance—not because a repository has been labeled “golden.”
Golden Record
A Golden Record is the reconciled record for one entity instance—for example, the best current enterprise representation of Customer 123.
It can still contain an unknown phone number, an outdated but not-yet-corrected address, or other limitations. “Golden” means reconciled best available, not omniscience.
Trusted Source vs Golden Record
- Trusted Source = the governed source/view/environment consumers rely on.
- Golden Record = one reconciled entity record within that environment.
Multiple governed perspectives
Finance and Marketing may need different views of a Customer while drawing from one trusted environment. Forcing one universal perspective solely to say “we have one golden truth” can be less useful than governed, clearly defined perspectives.
Example
CRM creates customers. Billing and Service also maintain local attributes. An MDM process standardizes, matches, and reconciles the records. Enterprise analytics obtains Customer from the MDM hub.
Possible roles: - CRM = System of Record for certain customer creation/maintenance facts. - MDM hub = System of Reference for shared enterprise consumption. - MDM environment = Trusted Source. - reconciled Customer G-100 = Golden Record.
If the organization later requires every customer update to occur through the hub, the hub may become both SOR and System of Reference.
Stop and check
Stem: “The warehouse has the most complete customer view.” Does that automatically make it the SOR? No. First ask who owns creation/maintenance. Completeness for consumption may instead support System-of-Reference or Trusted-Source status.
Source anchor: pp. 338–341, 345–351.