Logical Data Modeling - Data Integrity

Data System Architecture


Data/Database integrity ensures that data entered into the database is:

Three basic types of integrity are:

  • Entity integrity, allowing no two rows to have the same identity within a table.
  • Domain integrity, restricting data to predefined data types, e.g.: dates.
  • Referential integrity, requiring the existence of a related row in another table, e.g. a customer for a given customer ID.


Integrity is enforce with the help of constraint

Any applicable integrity constraints and data validation rules must be satisfied before permitting a change to the database.

See also: Relational Data Modeling - (Integrity) (Constraints|action assertions)

Discover More
Data Modeling Chebotko Logical
Cassandra NoSql Database

Cassandra is a NoSql database for transactional workloads that require high scale and maximum availability. Cassandra is suited for transactional workloads at high volume and shouldn’t be considered...
Data System Architecture
Concurrency - Concurrency

Data concurrency means that many thread (that may represents users) can access and modify data at the same time. Data concurrency ensures that users can access data at the same time ...reubenbond/status/662061791497744384/photo/1Reuben...
Data System Architecture
Concurrency - Lock (Mutex)

A lock is a synchronizationmechanism designed to enforce a mutual exclusion of threads. A lock is also known as a mutex. Type: binary semaphore - yes / no Most locking designs block the execution...
Cryptography - Data integrity

Data integrity in cryptography is perform with a hash function. It is based on the fact that the output of a hash function changes when the input has changed. Therefore, by controlling the computed...
Cryptography - Message Digest (checksum|hash) (sha1|md5)

A message digest is the output of hash function (also known as a checksum). The input is known as the message (ie a piece of data: file, payload). It is used to verify that the data has not been altered...
Data System Architecture
Data Property - Data Consistency - (Strong|Atomic) consistency - Linearizability)

In its most basic form, consistency refers to data values in one data set being consistent with values in another data set at the same point in time. In an other form, consistency, also known as atomic...
Yarn Hortonworks
HDFS - Data Integrity Implementation

in HDFS The HDFS client software implements checksum checking on the contents of HDFS files. When a client creates an HDFS file, it computes a checksum of each block of the file and stores these checksums...
HTML - Integrity attribute

integrity is an attribute of the fetch elements. Its value is a digest that controls that the file was not altered in transit. It's a data integrity functionality. If the calculation output with...
Data System Architecture
Logical Data Modeling - Domain Integrity

Domain integrity is a data integrity which specifies that all values in an attribute must be declared upon a defined domain. conformity
Data System Architecture
Logical Data Modeling - Entity Integrity (Uniqueness|No Duplicate|Distinct)

Entity integrity concerns the concept of uniqueness (also called no duplicate) Uniqueness is enforced with: primary key unique key (on a column or indice) Entity integrity is an integrity rule...

Share this page:
Follow us:
Task Runner