Question:
What is data integrity?
anonymous
1970-01-01 00:00:00 UTC
What is data integrity?
Four answers:
slurpee55
2009-01-06 07:22:41 UTC
Data integrity, which is an item that you could read up on for weeks, essentially is a set of rules established that require the data in a database meet certain criteria, such as the data is accurate and reflects the entirety of the data in the db. One of the most common ways to start enforcing data integrity is through the use of primary keys in every table - or a set of keys that meets certain criteria that are set up in advance (something that is tricky to do - far easier to use an autonumber for a primary key!) Foreign keys can generally only have 1 of 2 states, and all the data in a db must exist within the specified domain - which is by far the easiest to not understand (in my mind) and to corrupt.

Cascade Updates and Deletes? If you are using data integrity correctly, frankly I would avoid them - they update or delete across all linked tables or queries - a very easy way to damage your db accidentally or lose data that you need for something else.
?
2016-05-25 05:52:27 UTC
essentially: Data Integrity means: 1.Ensuring that the data is "whole" or complete. 2.The condition in which data is identically maintained during any operation, such as transfer, storage, and retrieval. 3.The preservation of data for their intended use. Data Security: is the process of protecting data from unauthorized access, use, disclosure, destruction, modification, or disruption. Data integrity makes sure the data is the same, and not corrupt. data security can do many things: hide data, encrypt data, password protect, etc.
anonymous
2009-01-06 07:01:54 UTC
Describes the many ways that data can be corrupted without the corruption being detected. The page is provided by Rocksoft, which sells a data integrity tool called Veracity.

Data integrity is normally enforced in a database system by a series of integrity constraints or rules. Three types of integrity constraints are an inherent part of the relational data model: entity integrity, referential integrity and domain integrity.
Killswitch
2009-01-06 07:05:56 UTC
a term used in computer science and telecommunications that can mean ensuring data is "whole" or complete, the condition in which data are identically maintained during any operation (such as transfer, storage or retrieval), the preservation of data for their intended use, or, relative to specified operations, the a priori expectation of data quality. Put simply, data integrity is the assurance that data is consistent and correct.



Often such integrity is ensured by use of a number referred to as a Message Integrity Code (MIC) or Message Authentication Code (MAC).



In cryptography and information security in general, integrity refers to the validity of data. Integrity can be compromised through:



Malicious altering, such as an attacker altering an account number in a bank transaction, or forgery of an identity document

Accidental altering, such as a transmission error, or a hard disk crash

In terms of a database data integrity refers to the process of ensuring that a database remains an accurate reflection of the universe of discourse it is modelling or representing. In other words there is a close correspondence between the facts stored in the database and the real world it models [1].



Data integrity is normally enforced in a database system by a series of integrity constraints or rules. Three types of integrity constraints are an inherent part of the relational data model: entity integrity, referential integrity and domain integrity.



Entity integrity concerns the concept of a primary key. 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.



Referential integrity concerns the concept of a foreign key. The referential integrity rule states that any foreign key value can only be in one of two states. The usual state of affairs is that the foreign key value refers to a primary key value of some table in the database. Occasionally, and this will depend on the rules of the business, a foreign key value can be null. In this case we are explicitly saying that either there is no relationship between the objects represented in the database or that this relationship is unknown.



Domain integrity specifies that all columns in relational database must be declared upon a defined domain. The primary unit of data in the relational data model is the data item. Such data items are said to be non-decomposable or atomic. A domain is a set of values of the same type. Domains are therefore pools of values from which actual values appearing in the columns of a table are drawn.



An example of a data integrity mechanism in cryptography is the use of MD5 hash values. These blocks of bytes function as a numeric summation of the content of a data item. Should the data change, the MD5 hash would yield a different result.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...