What is data redundancy and data integrity?

Answer 1

Data inconsistency exists when different and conflicting versions of the

same data appear in different places. Data inconsistency creates

unreliable information, because it will be difficult to determine which

version of the information is correct. (It's difficult to make correct - and

timely - decisions if those decisions are based on conflicting information.)

Data inconsistency is likely to occur when there is data redundancy. Data

redundancy occurs when the data file/database file contains redundant -

unnecessarily duplicated - data. That's why one major goal of good

database design is to eliminate data redundancy.

In the below link you can find more details.

http://opencourseware.kfupm.edu.sa/colleges/cim/acctmis/mis311/files%5CChapter1-Database_Systems_Topic_2_Introducing_Databases.pdf

Answer 2

Redundancy

A volume that maintains redundant data.

Extended by capability: Raid5Capability.

Extended by capability: DataMirroring.

integrity

The accuracy and consistency of stored data, indicated by an absence of any alteration in data between two updates of a data record. Data integrity is imposed within a database at its design stage through the use of standard rules and procedures, and is maintained through the use of error checking and validation routines

Answer 3

To really understand data redundancy and data integrity,

you must understand:

• What is data redundancy?
• What is data integrity?
• What is difference between data integrity and data security?

See the "related questions" below.

Redundancy of data is a known source of inconsistency.

Answer 4

Data redundancy is a situation created in a database or data storage technologies where the same piece of data is held in two separate places. This can mean two different fields in a single database, or two different spots in multiple software environments or platforms.

However, there are 2 forms of Redundancy - positive and of course negative.

Negative - excessive or wasteful data redundancy generally occurs when a given piece of data does not have to be repeated, but ends up being duplicated or triplicated due to inefficient coding or process complexities.

A positive type of data redundancy works to safeguard data and promote a consistency. Many developers consider it acceptable for data to be stored in multiple places. The key to this type because it classed perhaps as critical data is to have a master field or space for this data, so that there is a way to update all of the places where data is redundant through one central access point else it becomes a problem because users will not always complete the multiple updates.

Data inconsistency is a situation which occurs between files when similar data is kept in different formats in two different files, or when the matching of data must be done between files. This results of the data inconsistency, these files duplicate some data such as addresses and names, compromising data integrity. A classic case would come programmes store same data in two or more places and when updates are require to that data one of other of the location s is not updated. This needs therefore a single key or master field to bring all the areas together at one time to ensure user update is undertaken