MDM (Master Data Management)
MDM
Master Data Management
1. Overview of MDM — A System for Consolidating and Distributing Distributed Core Data as a Single Golden Record
flowchart LR
A["Master data scattered<br/>across systems<br/>(duplication, inconsistency)"] --"Standardize and<br/>manage centrally"--> B["Golden Record<br/>Single source of truth"] --"Distribute &<br/>synchronize"--> C["Enterprise-wide<br/>data consistency"]
style A fill:#FFEBEE,stroke:#D32F2F,color:#000
style B fill:#1E3A5F,stroke:#1E3A5F,color:#fff
style C fill:#E8F5E9,stroke:#388E3C,color:#000
Definition: A data management system that centrally standardizes an enterprise’s core shared data (master data) — such as customers, products, suppliers, and organizations — creates a Golden Record, and consistently distributes and manages it across enterprise systems.
Characteristics: (Core reference data) Unlike transaction data, master data changes infrequently and is shared broadly across the enterprise — it is core reference data. (Acts as SSOT) Serves as the Single Source of Truth (SSOT) that resolves data inconsistency between distributed systems. (Applied across domains) Applied across diverse business domains such as a customer 360 view, product information management (PIM), and supply-chain data integration.
2. Core Structure of MDM
A. Master Data Management
flowchart TD
subgraph R1[" "]
direction LR
D1["Master data domains<br/>Customer, product, supplier,<br/>organization, account, location"]
D2["Data quality management<br/>De-duplication<br/>Cleansing, standardization, validation"]
end
subgraph R2[" "]
direction LR
D3["Golden record creation<br/>Confidence-based merging<br/>Determine the survivor record"]
D4["Governance integration<br/>Ownership, stewardship<br/>Change-history management"]
end
style D1 fill:#E3F2FD,stroke:#1976D2,color:#000
style D2 fill:#F3E5F5,stroke:#7B1FA2,color:#000
style D3 fill:#FFF3E0,stroke:#F57C00,color:#000
style D4 fill:#E8F5E9,stroke:#388E3C,color:#000
style R1 fill:none,stroke:none
style R2 fill:none,stroke:none
| Management Area | Key Content | Core Technique |
|---|---|---|
| Master data domains | Identifying and classifying the core reference data used enterprise-wide | Domain definitions, establishing a standard data model |
| Data quality management | Securing trustworthy data through duplicate detection, cleansing, and standardization | Match & merge algorithms |
| Golden record creation | Creating a single confidence-weighted record from multiple source records | Applying survivorship rules |
| Governance integration | Managing ownership, change history, and approval processes for master data | Operating a data-stewardship process |
B. Data Integration and Distribution Architecture
flowchart LR
SRC1["Source system A<br/>(ERP)"]
SRC2["Source system B<br/>(CRM)"]
SRC3["Source system C<br/>(SCM)"]
MDM["MDM hub<br/>(Golden record store)"]
TGT1["Target system<br/>(DW / BI)"]
TGT2["Target system<br/>(App / API)"]
TGT3["Target system<br/>(Analytics)"]
SRC1 --> MDM
SRC2 --> MDM
SRC3 --> MDM
MDM --> TGT1
MDM --> TGT2
MDM --> TGT3
style MDM fill:#1E3A5F,stroke:#1E3A5F,color:#fff
style SRC1 fill:#E3F2FD,stroke:#1976D2,color:#000
style SRC2 fill:#E3F2FD,stroke:#1976D2,color:#000
style SRC3 fill:#E3F2FD,stroke:#1976D2,color:#000
style TGT1 fill:#E8F5E9,stroke:#388E3C,color:#000
style TGT2 fill:#E8F5E9,stroke:#388E3C,color:#000
style TGT3 fill:#E8F5E9,stroke:#388E3C,color:#000
| Implementation Style | Description | Characteristics & Application |
|---|---|---|
| Registry Style | The MDM system only references the location of source data | Minimal invasive change, existing systems can remain as-is |
| Consolidation Style | Source data is consolidated into the MDM hub to create a golden record for analytics | Focused on reporting/analysis, not distributed back to sources |
| Coexistence Style | The golden record is managed in the MDM hub but also synced back to sources | A balanced approach used by most enterprises |
| Centralized Style | The MDM hub is the sole system of storage and management for master data | Strong control, but higher implementation cost |
3. Expected Benefits and Application of MDM
| Category | Key Benefit | Application in Practice |
|---|---|---|
| Data consistency | Establishing a single source of truth for enterprise-wide core data | Resolving customer/product data inconsistency across ERP, CRM, and SCM |
| Improved analytical quality | Management decisions based on trustworthy master data | Supplying cleansed golden records to DW/BI platforms |
| Operational efficiency | Reduced cost of managing duplicate data and handling errors | Building a customer 360 view to improve marketing/service quality |
| Regulatory compliance | Strengthened data-lineage tracking and privacy management | Maintaining data history to support GDPR/privacy-law compliance |