answersLogoWhite

0


Best Answer

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

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

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

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

7y ago

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

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is data redundancy and data integrity?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Engineering

What are the disadvantages of file systems?

1)Limited Security 2)limited Data Sharing 3)Data Redundancy 4)Integrity Problems


What does data integrity mean?

"Data integrity refers to the maintenance of, and the assurance of the accuracy and consistency of, data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data". Source: Wikipedia.


Various integrity rules in a DBMS?

Three basic types of database integrity constraints are:Entity integrity, not allowing multiple 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.


Is the cyclic redundancy check better than hamming code?

It depends on what you are doing. The cyclic redundancy check will only detect an error, while the hamming code can also correct many types of errors. However to perform this correction the extra error detection parity bits required in hamming code are many more than the bits needed for cyclic redundancy check, per data byte being checked. Normally cyclic redundancy check is done on large block of data that can be resent or retried to get the correct block of data (e.g. telecommunication channels, disk sectors). Normally hamming code is done on individual bytes or words of computer memory.


Difference between temporal redundancy and spatial redundancy?

The redundancy is nothing but the reduction.The temporal locality is of relating to short time requirements.And the spatial is of relating to over environment.The redundancy occur in the images are of most common,so many techniques applied to overcome this. In image temporal redundancy is of abrupt transitions while in spatial it is of block based transitions.Spatial is applied at minimum cost and temporal is at maximum cost.Threshold values apply to temporal redundancy and the pixel comparison technique applies to spatial redundancy.

Related questions

What is the definition of form in database?

it is a process of eliminate data redundancy and improved data integrity, storage efficiency, or scalability.


What are the strength of the database?

Reduced data redundancy, Improved data integrity, Shared data, Easier access, Reduced development time


What is the definition of normal form in database?

it is a process of eliminate data redundancy and improved data integrity, storage efficiency, or scalability.


Identify the characteristics of database system?

* Data integration * Data independence * Data sharing * Data redundancy * Data security * Integrity and consistency * Concurrency and recovery


What is traditional approach?

•Traditional approach: separate data files are created and stored for each application program •Results in data redundancy: duplication of data in separate files •Data redundancy conflicts with data integrity (the degree to which the data in any one file is accurate)


What are five strengths of the database approach?

Reduced data redundancy, Improved data integrity, Shared data, Easier access, Reduced development time


Limitation of data processing system?

Hi, Data redundancy Data Inconsistancy Difficulty in accessing data Data Isolation Integrity problem Atomicity problem security problem


Why normalizations are important for database development?

Normalisation is process of taking data from a problem and reducing it to a set of relations. Meanwhile ensuring data integrity and eliminating data redundancy.


What are advantages of dbms approach?

There are number of advantages of DBMS approach , some of them are : Data integrity is maintained, Data accessibility is also easy, The redundancy of data is also reduced.


How can a primary key be useful in controlling data redundancy?

controlling data redundancy


What are threats to data integrity?

If referential integrity is not enforced, this can lead to data anomalies. For example, if a row in table A contains a foreign key referencing a row in table B, deletion of that table B row would cause an anomaly in table A should RI not be enforced, since it would now be referencing a row that doesn't exist.


DO you have redundancy of records in distributed DBMS?

Redundancy means duplicacy of data or repetitive data. In distributed database case the data is stored in different systems . So the answers is yes there can be redundancy of records / data.In distributed database , data is stored in different systems. Since the data is distributed there is redundancy of records.