Data Integrity vs Data Consistency
Summary: Difference Between Data Integrity and Data Consistency is that for a computer to produce correct information, the data that is entered into a database must have integrity. Data integrity identifies the quality of the data. An erroneous student address in a student database is an example of incorrect data. While Data Consistency refers to the usability of the Data, and is mostly used in single site environment. But still in single site environment, some problems may arise in Data Consistency during recovery activities when original data is replaced by the backup copies of Data.
Data Integrity
Most organizations realize that data is one of their more valuable assets — because data is used to generate information. Many business transactions take less time when employees have instant access to information. To ensure that data is accessible on demand, an organization must manage and protect its data just as it would any other resource. Thus, it is vital that the data has integrity and is kept secure.
For a computer to produce correct information, the data that is entered into a database must have integrity. Data integrity identifies the quality of the data. An erroneous student address in a student database is an example of incorrect data. When a database contains this type of error, it loses integrity. Data integrity is very important because computers and people use information to make decisions and take actions.
Garbage in, garbage out (GIGO) is a computing phrase that points out the accuracy of a computer’s output depends on the accuracy of the input. If you enter incorrect data into a computer (garbage in), the computer will produce incorrect information (garbage out).
Data Consistency
Data Consistency refers to the usability of the Data, and is mostly used in single site environment. But still in single site environment, some problems may arise in Data Consistency during recovery activities when original data is replaced by the backup copies of Data. You have to make sure that you data is usable while backing up data. And for that you should understand the backup methodologies used to backup data. And you should learn how the data is created and accessed.
Also Read:
Difference Between Data Validation and Data Integrity
Difference Between Relational Database and Object Oriented Database
Difference Between Relational Database and Data Warehouse
Leave a Comment
You must be logged in to post a comment.