Data Modeling - Entity Integrity (Uniqueness|No Duplicate|Distinct)

1 - About

Entity integrity concerns the concept of:

Entity integrity is an integrity rule which states that every table must have a primary key and that the column or columns chosen to be the primary key should be unique and not null.

Asserting uniqueness of the entities within a data set implies that no:

exists more than once within the data set.

3 - Monitoring

This attribute can be monitored two ways :

  • As a static assessment, it implies applying duplicate analysis to the data set to determine if duplicate records exist
  • As an ongoing monitoring process, it implies providing an identity matching and resolution service at the time of record creation to locate exact or potential matching records.

You can find duplicate records with the use of an Function - Hash

The entity integrity is a data quality metrics.

data/modeling/entity_integrity.txt ยท Last modified: 2017/09/13 21:21 by gerardnico