Master Data Management
Master data management keeps shared records about core business entities, such as customers, products, suppliers, and locations, consistent across systems. It combines governance, data quality, matching, and distribution so teams can use trusted entity data.
itEnterprise architecture and integration | OpenSkills.info
Course pathWalk it in order
Look it upDip in anytime
Go furtherLeaves this page
Don't Panic
Don't Panic — Master Data Management
Master data management is the discipline of making shared descriptions of customers, products, suppliers, locations, and other reused entities agree across systems. This sounds like asking several filing cabinets to stop disagreeing about the spelling of a supplier. It is that, except the filing cabinets can send payments, ship goods, and produce reports.
The trouble begins when one supplier appears in purchasing, finance, logistics, and analytics with different identifiers and conflicting details. Each local record can be perfectly useful to its own application. None can settle the enterprise identity question alone. MDM keeps the original claims, works out which ones describe the same entity, and publishes a trusted view for the consumers allowed to use it.
The memorable machinery has three parts. Entity resolution decides which source records refer to one real-world subject. Survivorship chooses a value for each attribute according to approved policy. Provenance records where the value came from, which rule chose it, and who made an exception. A golden record is therefore not a magical record that has won a pageant. It is calculated evidence with a change history.
The surprising part is that matching is a risk decision, not a contest to merge the most rows. A false merge joins two different entities. A missed match leaves one entity split. Those errors have different business costs, so uncertain cases belong with data stewards and a safe split path, not behind an impressive-looking score.
MDM also does not repair a poor source process by glaring at it from a central hub. Source owners still fix defects where records are created. Data owners define the domain and policy. Stewards keep definitions, rules, and corrections usable. Technical teams run integration and distribution. The system works when these responsibilities connect; a database sitting alone is mostly an ambitious cupboard.
Read the intro when you need the full flow and architecture. Use the slides for the relationships among source records, best records, and the three architecture choices. Keep the cheatsheet nearby while deciding on blocking, thresholds, survivorship, provenance, and operating measures. Then try the practice session and exercise to turn a few fictional supplier rows into a mastered domain with evidence you can inspect.
Where this skill leads
Relevant careers
See how this topic contributes to broader role-level skill maps.
Sources
- https://www.ibm.com/think/topics/master-data-management
Supports
- MDM combines technology, tools, processes, data models, and stewardship across enterprise systems
- Master data describes core entities such as customers, products, suppliers, and locations
- MDM work includes integration, standardization, matching, deduplication, reconciliation, enrichment, governance, and distribution
- Golden records integrate source records into a unified entity view
- Master data differs from transaction data, reference data, metadata, and other organizational data
- Recurring source inconsistency, quality problems, and synchronization are central MDM challenges
- https://www.ibm.com/docs/en/ws-and-kc?topic=data-concepts
Supports
- MDM creates entities by matching records from one or more data assets
- Source-system identifiers track record origin
- MDM data models include record, attribute, relationship, hierarchy, and entity concepts
- https://www.iso.org/standard/62392.html
Supports
- ISO 8000-100 covers fundamentals and requirements for master-data quality
- The ISO 8000 master-data series includes quality management and quality metrics
- The standard addresses computer-checkable master-data exchange at system interfaces
- https://dama.org/learning-resources/dama-data-management-body-of-knowledge-dmbok/
Supports
- DAMA-DMBOK places master and reference data within the wider data-management discipline
- The body of knowledge connects governance, quality, architecture, modeling, integration, metadata, and related functions
- https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/6d52de87aa0d4fb6a90924720a5b0549/56a57357f2b1aa6be10000000a4450e5.html
Supports
- Central governance controls creation and change through workflow, validation, approval, activation, and distribution
- Consolidation loads distributed source data, standardizes it, detects duplicates, and calculates a best record through survivorship rules
- Consolidation and central governance can be combined in a coexistence approach
- Best-record decisions depend on duplicate groups and attribute-level survivorship rules
- https://learning.sap.com/courses/sap-master-data-governance-on-sap-s-4hana/explaining-consolidation-in-master-data-governance
Supports
- SAP documents central governance, decentralized consolidation, data-quality management, and coexistence as MDM approaches
- A consolidation flow can load, check, standardize, match, calculate best records, validate, and activate
- Consolidation can support analytics, initial loads, mergers, and mixed ownership
- https://learn.microsoft.com/en-us/purview/data-governance-master-data-management-semarchy
Supports
- A representative MDM architecture includes ingestion, quality, validation, matching, deduplication, authoring, curation, and collaboration
- MDM can integrate governed metadata with a cloud data platform and operational sources
- https://learn.microsoft.com/en-us/openspecs/sql_data_portability/ms-dpmds/8eb2e6be-e4f1-4ecc-9486-50fc0592bb75
Supports
- MDM supports shared definitions, stewardship, business rules, workflows, hierarchies, and publication
- Critical entity domains can include product, customer, location, equipment, employee, and vendor
- https://github.com/sindresorhus/awesome
Supports
- The Awesome master list provides the starting discovery path for data-engineering ecosystem lists
- https://github.com/OlivierBinette/Awesome-Entity-Resolution
Supports
- The focused list curates Splink, Zingg, and dedupe as end-to-end entity-resolution software
- The list distinguishes entity-resolution tools from supporting comparison, cleaning, quality, and blocking tools
- https://moj-analytical-services.github.io/splink/index.html
Supports
- Splink performs probabilistic record linkage for deduplication and cross-dataset linking
- Its documentation covers blocking, comparison, training, prediction, clustering, diagnostics, evaluation, and several SQL backends
- Match evaluation uses labeled evidence and exposes tradeoffs between linkage errors
- https://docs.zingg.ai/latest
Supports
- Zingg provides entity resolution for building unified core business entities
- Zingg uses labeled pairs and active learning in its entity-resolution flow
- https://docs.dedupe.io/en/stable/
Supports
- dedupe is a Python library for structured-data deduplication and entity resolution
- dedupe learns weights and blocking rules from human-labeled data
- https://www.informatica.com/products/master-data-management.html
Supports
- Informatica MDM and 360 Applications supports multidomain master data, match and merge, and customer, product, supplier, finance, and reference domains.
- https://www.reltio.com/master-data-management/
Supports
- Reltio Multidomain MDM provides cloud-native entity resolution, data quality, survivorship, persistent identifiers, hierarchies, governance, auditability, and lineage.
- https://semarchy.com/platform/master-data-management/
Supports
- Semarchy Data Platform provides governed master data across customer, product, supplier, location, and reference domains with federated governance.
- https://www.sap.com/products/master-data-governance.html
Supports
- SAP Master Data Governance provides a governed model, matching, consolidation, stewardship workflows, validation, monitoring, and audit trails for master data.
- https://www.ataccama.com/platform/master-data-management
Supports
- Ataccama Master Data Management supports profiling, cleansing, matching, golden-record creation, stewardship, approval workflows, and distribution.
- https://www.apqc.org/blog/lessons-learned-master-data-management-implementation
Supports
- An implementation lesson is to operationalize MDM through feedback loops and incremental business outcomes rather than wait for a fully stabilized program.
- Master-data work requires cross-functional design and an operating model rather than a technology-only implementation.
- https://www.mckinsey.com/capabilities/tech-and-ai/our-insights/master-data-management-the-key-to-getting-more-from-your-data
Supports
- MDM programs benefit from a pilot in one domain to validate governance, workflow, and design before scale.
- Clear governance roles and upstream and downstream integration are needed to avoid stale information and maintain MDM capability.
