Overview of business key validation

InfoSphere® MDM defines and validates business keys for various groups. Validation is performed when users add or update records corresponding to a group.

The business key of a given entity is made up of one or more attributes of the entity that uniquely identifies the entity at the business level. Each entity's business key is defined in the V_ELEMENTATTRIBUTE metadata table. InfoSphere MDM defines business keys for a predefined set of groups that require unique identification.

InfoSphere MDM validates the uniqueness of business keys to ensure that they remain unique among all existing active instances of the same business object. During add and update transactions, InfoSphere MDM determines entity duplicates based on the business key values.

InfoSphere MDM uses business key definitions in the following scenarios:
  • Maintaining entity uniqueness from a business perspective – One of the goals of business key validation is to ensure that duplicate records do not get inserted. If two records share the same values for their business key attributes, then they are considered to be duplicates. Since the business requirements drive the definition of duplicates, this validation is done at the application level.
  • Validating data survivorship – Data survivorship rules determine what data should ultimately survive when merging or collapsing parties. The default rule uses business key attributes for each business object to identify whether the corresponding business objects of the entities being merged or collapsed match. If the business key values for two entities match, then either both business objects survive or the business object that is most recent survives.

In addition to the existing, predefined business keys, InfoSphere MDM also provides a mechanism to enable you to define new business keys and enforce group validation against the new business keys. The business key validation framework helps you to customize business key validation for different groups.