Durable and Non-Durable Attributes
The term “golden record” is used to describe a master record that is made up of the best version of each attribute selected from contributing source systems. Durable attributes, like a social security number or date of birth, are not expected to change once identified. Attributes that can be expected to change over time such as address, credit terms or marital status are Non Durable Attributes. Durable and non durable attributes require different management techniques within the MDM Hub.
By Martin Dunn
The term “golden record” is used to describe a master record that is made up of the best version of each attribute selected from contributing source systems. Durable attributes, like a social security number or date of birth, are not expected to change once identified. Attributes that can be expected to change over time such as address, credit terms or marital status are Non-Durable Attributes. Durable and non-durable attributes require different management techniques within the MDM Hub.
When a durable attribute changes it is an indication that something unexpected or unusual has occurred – and in the world of MDM, unexpected or unusual events typically give rise to some form of data steward intervention.
Let’s take an example of the change to a social security number (SSID) on a customer record. When the MDM hub receives the updated social security number it will flag the change because SSID is a durable attribute. The hub will route the change and supporting information via a data governance workflow to a data steward for further action. The data steward will have the responsibility to investigate, understand and manage the consequences of this correction. Perhaps, for example, the incorrect number was used in a credit check that should be redone. Or perhaps the change to SSID indicates a previously incorrect match between two customer records which could give rise to any number of adverse consequences.
When the unexpected occurs it often takes human intervention to resolve the downstream consequences of the change. The MDM Hub should be configured to trap unexpected changes to data and to gather all of the necessary information for a data steward to investigate and resolve the consequential issues arising from the change.
It’s a great practice to identify the “durability” each key master data attributes and to engage the business stakeholders in a discussion about the process they would follow if durable data changes.
Understanding the difference between changes to durable and non-durable attributes is a key design consideration for MDM. The intervention of a data steward will vary depending on the nature of the change and the durable attribute that has changed. Each durable attribute will be associated with its own remediation process, workflows and reporting.
Martin Dunn was the co-founder of Delos Technology which developed the MDM technology marketed under the Siperian brand. The Delos MDM technology introduced many MDM concepts that are now widespread within the MDM discipline including a data steward console to adjudicate match results, opt-in synchronization, cell level delta detection and the concept of measuring trust.
Martin is now a partner with Gaine Solutions and continues to advance the techniques by which enterprise Master Data is managed.
Key Questions to Ask During Master Data ConsolidationsTypical master data consolidation starts with combining the operational master records from all the data silos where they exist. The key aspect being, creation of master data indexes to support single view; knowing...
Opt-in SynchronizationNot all operational systems will choose to, or be able to, consume the changes made to master data in an MDM hub. The reasons for being out-of-synchronization may be technical, regulatory, political or economic but at some point it will be...
Changing a Match RuleWhen we are talking to companies about our MDM platform we cover a broad range of topics, from measuring ROI, to more technical questions about the way the software operates. A common technical question is "How do we change a match rule?" Our...
Ready to master data mastering?
Subscribe to our mailing list and we’ll send you courses, insights, product updates, and more. Get to know the ins-and-outs of your Gaine MDX platform, features, and solutions.