What is the difference between controlled and uncontrolled redundancy? Illustrate with examples.
Answers
Answer:
Redundancy is the state of being not or no longer needed or useful.In the traditional approach, uncontrolled redundancy in storing the same data/information many times in the database leads to several problems. This leads to Duplication of effort, Wastage of storage space and inconsistent data.
Controlled redundancy
A controlled redundancy is a necessary technique to use redundant fields in a database. This speed ups the database access and also improves the performance of queries. Usually, the DBMS ensures the allocation of the data in the records. It should have the capability to control this redundancy in order to prohibit inconsistencies among the files.
Uncontrolled redundancy
Redundancy occurs when the storage of the same data occurs in multiple locations in the database.With uncontrolled redundancy, many issues can occur including inconsistent data such as multiple methods of data structure such as order of birth date information, waste of storage space and the duplication of effort of inputting data.
The difference between controlled redundancy and uncontrolled redundancy is with controlled redundancy, methods can be used to combine data that is input automatically.
hope it help You !