Master data management

On this page 7

Master data management (MDM) is the discipline, process and technology that creates and maintains a single trusted version of core business entities, such as customers, products, suppliers, employees and locations, and distributes it to every system that uses them. Within data governance, master data management is where policies about ownership, quality and definitions become an operational record that applications actually consume.

Master data differs from transactional data. An order, a payment or a sensor reading is an event; the customer, the product and the warehouse referenced by that event are master data. These entities change slowly, are shared across many applications and carry high business impact when they are wrong, which is why they receive dedicated stewardship and matching logic rather than ad hoc cleanup.

How master data management builds a golden record

Master data management works by collecting records about the same entity from several sources, deciding which records describe the same real-world thing, and merging them into a golden record that downstream systems trust. The process runs continuously, because source systems keep creating and editing records.

The core pipeline has recognizable stages. Each stage has its own rules, and the quality of the final record depends mostly on the matching and survivorship rules, not on the software brand.

StageWhat happensTypical technique
IngestionRecords arrive from CRM, ERP, e-commerce and other sourcesBatch loads, change data capture, APIs
StandardizationNames, addresses and codes are normalizedParsing, reference lists, address validation
MatchingCandidate duplicates are identifiedDeterministic keys, fuzzy and probabilistic scoring
Merging and survivorshipOne value per attribute is chosenSource priority, recency, completeness rules
StewardshipUncertain matches go to people for reviewTask queues with match scores and evidence
DistributionThe golden record is published to consumersEvents, APIs, cross-reference keys
Stages of the master data management pipeline

Matching usually combines blocking, which limits comparisons to plausible pairs such as the same postal code, with similarity scoring on names, identifiers and addresses. Scores above an auto-merge threshold are merged automatically, scores in a middle band go to a data steward, and low scores stay separate. Where the bands sit is a business decision, because a false merge of two different customers is usually more harmful than a missed duplicate.

Architecture styles for master data management

Organizations implement master data management in one of four recognized architecture styles, which differ in where the golden record lives and which system is allowed to author changes. The choice shapes cost, latency and the amount of change required in existing applications.

StyleWhere the golden record livesAuthoringBest fit
RegistryOnly an index of cross-referencesSource systemsFast start, read-only analytics
ConsolidationHub copy used mainly for reportingSource systemsAnalytics and data warehouse feeds
CoexistenceHub and sources both hold full recordsHub and sources, synchronizedGradual migration with shared edits
CentralizedThe hub is the system of entryHub onlyStrict control, regulated product data
Master data management implementation styles

Many programs start with registry or consolidation to prove value with low disruption, then move toward coexistence once data owners agree on authoring rights. A centralized hub gives the strongest control but forces every creation workflow through the hub, which requires real organizational commitment.

Master data management is often confused with neighboring practices in data governance because they share people and tools. The distinction lies in what each practice manages: entities and their values, codes, definitions or metadata about datasets.

ConceptWhat it managesRelationship to MDM
Master data managementInstances of core entitiesProduces the trusted entity records
Reference dataControlled code lists such as countries or currenciesSupplies valid values used inside master records
Data catalogMetadata about datasets and assetsDocuments where master data lives and who uses it
Business glossaryAgreed meanings of business termsDefines what a customer or product means
Data stewardA role, not a datasetResolves match tasks and quality issues
How master data management relates to neighboring concepts

Reference data is a frequent point of confusion. Country codes or units of measure are small, slowly changing lists, often defined externally by standards such as ISO 3166, whereas master data describes the organization’s own customers and products in thousands to many millions of records.

Planning a master data management program

A successful program starts with one domain and a clear business problem, such as duplicate customers that distort revenue reporting or inconsistent product attributes that block online sales. Starting with all domains at once is a common cause of multi-year projects with no visible result.

  • Define the entity in the business glossary before building match rules, including what counts as one customer when households, subsidiaries and individuals overlap.
  • Assign data ownership per domain and attribute, so a named owner decides survivorship disputes.
  • Choose identifiers that remain stable, such as tax numbers or global trade item numbers, while recognizing that they are often missing or wrong in source data.
  • Measure quality with completeness, uniqueness and validity metrics before and after the program, so improvement is visible.

Domain choice determines the dominant difficulty. Customer data is hardest to match because of spelling variants and privacy duties, while product data is hardest to model because attributes differ by category.

DomainMain difficultyCommon identifier
CustomerFuzzy matching, consent and privacyEmail, tax number, loyalty ID
ProductCategory-specific attributes and hierarchiesGTIN, internal SKU
SupplierCorporate hierarchies and legal entitiesLegal entity identifier, VAT number
LocationAddress formats and geocodingSite code, coordinates
Typical difficulties by master data domain

Common pitfalls in master data management

Most failures in master data management are organizational rather than technical. The software can match and merge records, but it cannot decide who owns an attribute or which definition of an active customer is correct.

  • Treating MDM as a one-time cleanup: without ongoing stewardship, duplicates return within months because source systems keep creating them.
  • Over-aggressive matching: a low auto-merge threshold merges distinct people or companies, and unmerging is far more expensive than merging.
  • No feedback to sources: if corrections stay in the hub, the same errors keep arriving from the originating application.
  • Ignoring privacy rules: consolidated customer records concentrate personal data, so retention, consent and residency obligations apply to the hub itself.

The short version

Large companies keep information about the same customer or product in many different programs, and each copy is slightly different. One system spells a name differently, another has an old address, a third lists the same person twice. Master data management is the practice of reconciling those copies into one reliable version and keeping it reliable over time.

Think of it as a shared address book that every department agrees to use. Someone checks new entries, removes duplicates and decides which phone number is current, so everyone works from the same facts.

Where it makes a difference

A mid-sized industrial distributor runs separate systems for sales, invoicing and its online shop. Finance discovers that the top 500 customers appear as roughly 800 accounts, because branches and the web shop each created their own records. Credit limits are therefore checked per duplicate account, and one customer exceeds its real limit without any alert.

The company starts a customer master data management program using a coexistence style. Records are standardized, matched on VAT number and normalized addresses, and pairs with medium match scores go to two data stewards in finance. Within one quarter, duplicate accounts fall to a small residual set, credit exposure is calculated per real customer, and every system now receives the same customer identifier from the hub.