Survivorship Rules

Survivorship rules are the policies in master data management and deduplication that determine which specific value should "survive" — be chosen as the golden record's canonical value — when duplicate records disagree on a given attribute. When two records describe the same customer but one has "John Smith" and the other "Jon Smith", or one has "555-1234" and the other has "(555) 123-4567 ext 200", or one has a 2010 address and the other a 2024 address, survivorship rules decide which wins. The rule types: most recent (winner is the value with the most recent last-modified timestamp — appropriate for time-varying attributes like address, phone, employment), most trusted source (winner is from the highest-priority source — vendor master data beats user-entered data beats web-scraped data), longest non-null (winner is the longest non-empty value — useful for descriptive fields where more detail is generally better), most frequent (winner is the value that appears most often across duplicates — useful for typo-prone fields where the majority is more likely correct), specific source preference (driver's license number always comes from DMV records, never from self-reported), and custom logic (combine values from multiple records — concatenate phone numbers, union of email addresses, sum of historical purchase amounts). Sophisticated MDM systems support hierarchical rule cascades — try most-recent first, fall back to most-trusted-source if timestamps are missing, fall back to longest-non-null if both are tied — with audit trails recording which rule fired for which attribute on which match. Production tooling: Informatica MDM, Reltio, Stibo Systems STEP, TIBCO EBX, Profisee, and the open-source Splink and dedupe libraries all support configurable survivorship policies. A practical implementation in dbt or Spark: GROUP BY the cluster_id (from record linkage) and apply per-attribute aggregation functions: MAX(last_modified) for timestamp-driven attributes, FIRST_VALUE() ORDER BY source_priority for source-driven attributes, and so on. Survivorship rules embody business judgment about which sources to trust under which conditions — they are governance, not pure engineering. For Digital Experience Platforms, survivorship determines which version of the truth becomes the experience layer's foundation; a wrong rule produces wrong experiences.

Survivorship judgment from 25 years of governance: Centralpoint encodes 25 years of client survivorship judgment — which source wins, which attribute trumps which, when to retain history and when to overwrite — into the golden-record discipline that underpins the served experience. Gartner Magic Quadrant DXP positioning rests on exactly this kind of multi-source authoritative truth-telling. Survivorship rules run on-premise, lineage is audit-graded, and truth-based experiences deploy through one line of JavaScript.


Related Keywords:
Survivorship Rules,Survivorship Rules,Oxcyon, AI, AI Governance, Generative AI, Inference, Inference, Inferencing, RAG, Prompts, Skills Manager,