DataTerminology.comNEW
Match-merge rules determine when duplicates are merged and how attribute survivorship creates a single trusted record.
DESCRIPTION
Match-merge rules govern consolidation of duplicate records into a golden record. They specify thresholds or conditions for auto-merge and define survivorship policies for attributes. Rules may prioritize source reliability, recency, or completeness. Stewardship workflows review borderline cases and reverse erroneous merges. Effective match-merge reduces inconsistency, improves analytics, and enhances customer experiences.
ALTERNATIVE DEFINITIONS
IBM InfoSphere MDM
Match and merge rules determine how and when records are merged and which attributes survive.
Highlights governance of merge criteria and attribute survivorship.
Semarchy xDM
Matching finds duplicates; merging consolidates them into a single, best version of the truth.
Emphasizes consolidation into a single trusted record.
RELATED TERMS
Matching Duplicate Identification Survivorship Rules Single Source of Truth Master Data Management Identity Resolution Stewardship Workflow Thresholding Data Quality Consolidation
COMPETING TERMS
KNOWLEDGE AREAS
Data Management Reference & Master Data Data Quality Data Governance Data Architecture
TARGET AUDIENCE
Data Steward Data Architect Data Modeler Data Engineer Information Analyst
EXTERNAL SOURCES
- Wikipedia - Master data management
- IBM - Detailed match-merge rule configuration
- Semarchy - Concepts of matching and merging
- Reltio - Merge workflows and survivorship
TOP QUESTIONS
What are Match-Merge Rules in MDM?
They set conditions for merging duplicates and define attribute survivorship to create golden records.
Category: Definition
How are thresholds used in Match-Merge Rules?
Thresholds classify pairs into auto-merge, auto-link, or review; tuning balances precision and recall.
Category: Tuning
What is survivorship in Match-Merge Rules?
Survivorship selects the best attribute values from sources based on rules like source trust or recency.
Category: Management
What risks exist in Match-Merge Rules?
Incorrect merges corrupt records; reversible merges, audit logs, and stewardship reduce impact.
Category: Risk
How do Match-Merge Rules differ from Match-Link Rules?
Match-merge consolidates duplicates; match-link creates non-duplicate relationships without merging.
Category: Distinction
What data preparation supports Match-Merge Rules?
Standardization, source reliability metadata, and completeness indicators enable accurate survivorship.
Category: Preparation
How do you validate Match-Merge Rules?
Use labeled pairs, monitor precision/recall, and audit merged records for errors.
Category: Metrics
Can Match-Merge Rules be automated?
Yes, automation applies for high-confidence merges, with stewards handling ambiguous cases.
Category: BestPractices
How do Match-Merge Rules impact analytics?
They reduce duplication and inconsistency, improving metric accuracy and customer insights.
Category: Impact