Data redundancy sometime refers to in computer data storage, is a property of some disk arrays (most commonly in RAID systems) which provides fault tolerance, so that all or part of the data stored in the array can be recovered in the case of disk failure. The cost typically associated with providing this feature is a reduction of disk capacity available to the user, since the implementations require either a duplication of the entire data set, or an error-correcting code to be stored on the array.
Redundancy is attained when the same data values are stored more than once in a table, or when the same values are stored in more than one table.
To prevent redundancy in Database Tables, database normalization should be done to prevent redundancy and any other problems that might affect the performance of the database.
One of the biggest disadvantages of data redundancy is that it increases the size of the database unnecessarily. Also data redundancy might cause the same result to be returned as multiple search results when searching the database causing confusion and clutter in results.
See also
- Data maintenance
- Error detection and correction
- Redundancy (engineering)
- Redundancy (information theory)
 |
This computer storage-related article is a stub. You can help Wikipedia by expanding it. |
This entry is from Wikipedia, the leading user-contributed encyclopedia. It may not have been reviewed by professional editors (see full disclaimer)
