What is Data Consistency and Difference in Inconsistency

Data Consistency:

Data consistency means that the changes made to different occurrence of data should be controlled and managed in such a way that all the occurrences have same value for any specific data item. Data inconsistency leads to a number of problems, including loss of information and incorrect results. In database approach it is controlled because data is shared and consistency is controlled and maintained.

Difference of consistency and inconsistency:

Data consistency means the validity, accuracy and usability of related data. It ensures that each user observes a consistent(Same) view of the data, including changes made by the user's own transactions and transactions of other users. Whereas data inconsistency means that different versions of the same data appear in different places.

For example, the ZIP code in one application may be represented in a 5+4 numeric data format; while in another application it may be represented in 9 characters.

Redundant Data:

It means if different systems of an organization are using some common data then rather than storing it once and sharing it, each system stores data in separate files. This creates the problem of redundancy or wastage of storage and on the other hand the problem on inconsistency.

Post a Comment