Reference Data vs Master Data
People think reference data and master data are the same thing. Reference data is a short list of allowed codes, like country codes. It changes a few times a year. Master data is the records of the things a business deals with, like customers and products. It changes every day, and it uses the codes from the reference list.
Reference Data
A short shared list of allowed codes, like country codes. It rarely changes.
Reference data is a short, fixed list of allowed values that other data points to. Country codes, currency codes and order status values are all reference data. It changes rarely, a few times a year at most. Many tables share one list, so they all use the same codes. Master data, like customers and products, uses these codes in its own records.
Master Data Management (MDM)
One true copy of each key thing, like a customer.
Master data management keeps one trusted record for each key thing a company deals with. Key things are customers, products, suppliers and places. The same customer often sits in the sales tool, the billing system and the shop, spelled three ways. MDM matches those copies and merges them into one golden record. Other systems then use that record or link to it.
In one line
- Reference Data
- A short shared list of allowed codes, like country codes. It rarely changes.
- Master Data Management (MDM)
- One true copy of each key thing, like a customer.