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

Data System Architecture


Entity integrity concerns the concept of uniqueness (also called no duplicate)

Uniqueness is enforced with:

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.


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 Cryptography - Hash

The entity integrity is a data quality metrics.

Discover More
Sorting Quicksort Anim
Algorithm - Big O Notation

The big-Oh notation is a vocabulary for the design and analysis of algorithms. See: Asymptotic analysis Notation is just . Terminology: running time is O(n...
Testing Infrastructure
Code - Testing (Software Quality Assurance|SQA|Validator|Checker)

A test is performed to verify that the system is conformed to the specification and is the most important part of code quality. In a “Test-driven_developmenttest-driven software development (tdd)”...
Data System Architecture
Collection - Sequence (Ordered)

A sequence is an abstract collection: of non-unique element where order matters - ie (A,B) is not equal to (B,A) non-unique means that it allows duplicate member (the same element/value may occur...
Venn Diagram
Collection - Set

A set is: a data structure of the set theory a collection ofdistinct objects (then without duplicate) an unordered collection of objects The objects element of the set have the same type (the type...
Consistent Hashing
Cryptography - Hash

A hash function is an encryption crypto algorithm that takes as data as input (possibly large and of variable-sized) and produces a short fixed-length integer value (generally printed as an hexadecimal...
Dataquality Metrics
Data Quality - Entity (Resolution|Disambiguation) - Record (linkage|matching) - Conflation

Entity Resolution, or Record linkage is the process of (joining|matching) records from one data source with another that describe the same Entity. Also known as : entity disambiguation/linking,duplicatidentificatioidentifiedata...
Dataquality Metrics
Data Quality - Metrics

Very often these metrics are named dimension but it is an abuse language, it acts rather in a dimensional model as attribute of the data rules. Timeliness refers to the time expectation for...
Java Conceptuel Diagram
Java - Set (Collection)

This interface is a member of the Java Collections Framework. Set is a collection that cannot contain duplicate elements. This interface models the mathematical set abstraction and is used to represent...
Data System Architecture
Logical Data Modeling - Data Integrity

Data/Database integrity ensures that data entered into the database is: accurate, correct (valid), and consistent. Three basic types of integrity are: Entity integrity, allowing no two rows...
Erd Entity Instance
Logical Data Modeling - Entity Set (Class, Table)

An entity set is a set of entity. An entity set is implemented: in a relational database by a table and an entity by a row in code by a Class and an instance by an object entity of a language...

Share this page:
Follow us:
Task Runner