Data redundancy

Data redundancy

Data redundancy occurs in database systems which have a field that is repeated in two or more tables. For instance, in case when customer data is duplicated and attached with each product bought then redundancy of data is a known source of inconsistency, since customer might appear with different values for given attribute.[1] Data redundancy leads to data anomalies and corruption and generally should be avoided by design.[2] Database normalization prevents redundancy and makes the best possible usage of storage.[3] Proper use of foreign keys can minimize data redundancy and chance of destructive anomalies.[2] However sometimes concerns of efficiency and convenience can result redundant data design despite the risk of corrupting the data.[4]

Notes and references

  1. ^ Jorge H. Doorn; Laura C. Rivero (2002). Database integrity: challenges and solutions. Idea Group Inc (IGI). pp. 4–5. ISBN 9781930708389. http://books.google.com/books?id=fJWncL6mjnwC&pg=PA4. Retrieved 23 January 2011. 
  2. ^ a b Peter Rob; Carlos Coronel (2009). Database systems: design, implementation, and management. Cengage Learning. p. 88. ISBN 9781423902010. http://books.google.com/books?id=gCzfjlWOVAAC&pg=PA88. Retrieved 22 January 2011. 
  3. ^ I. T. L. Education Solutions Limited; Itl (2009). Introduction to Information Technology. Pearson Education India. p. 522. ISBN 9788177581188. http://books.google.com/books?id=ib2MI6_B9qYC&pg=PA522. Retrieved 4 February 2011. 
  4. ^ Allen G. Taylor (2 February 2010). SQL for Dummies. For Dummies. pp. 126–127. ISBN 9780470557419. http://books.google.com/books?id=r4s1QTHpQosC&pg=PA126. Retrieved 1 February 2011. 

See also

v · d · eDatabase management systems
Concepts
Objects
Components



Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • Data warehouse — Overview In computing, a data warehouse (DW) is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations… …   Wikipedia

  • Redundancy — may refer to: Redundancy (engineering) Redundancy (information theory) Redundancy (language) Redundancy (total quality management) Redundancy (user interfaces) Data redundancy Gene redundancy Logic redundancy Redundant acronym syndrome syndrome… …   Wikipedia

  • Redundancy (engineering) — In engineering, redundancy is the duplication of critical s of a system with the intention of increasing reliability of the system, usually in the case of a backup or fail safe. In many safety critical systems, such as fly by wire aircraft, some… …   Wikipedia

  • Redundancy (information theory) — Redundancy in information theory is the number of bits used to transmit a message minus the number of bits of actual information in the message. Informally, it is the amount of wasted space used to transmit certain data. Data compression is a way …   Wikipedia

  • Data remanence — is the residual representation of data that remains even after attempts have been made to remove or erase the data. This residue may result from data being left intact by a nominal file deletion operation, by reformatting of storage media that… …   Wikipedia

  • Data administration — or data resource management is an organizational function working in the areas of information systems and computer science that plans, organizes, describes and controls data resources. Data resources are usually as stored in databases under a… …   Wikipedia

  • Data center infrastructure management — (DCIM) is the integration of information technology (IT) and facility management disciplines to centralize monitoring, management and intelligent capacity planning of a data center s critical systems. Achieved through the implementation of… …   Wikipedia

  • Data Validation and Reconciliation — Industrial process data validation and reconciliation or short data validation and reconciliation (DVR) is a technology which is using process information and mathematical methods in order to automatically correct measurements in industrial… …   Wikipedia

  • Data compression — Source coding redirects here. For the term in computer programming, see Source code. In computer science and information theory, data compression, source coding or bit rate reduction is the process of encoding information using fewer bits than… …   Wikipedia

  • Data center — An operation engineer overseeing a Network Operations Control Room of a data center. A data center (or data centre or datacentre or datacenter) is a facility used to house computer systems and associated components, such as telecommunications and …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”