Question

Difference between controlled and uncontrolled redundancy in dbms

Answer 1

hi there!

i'm kinjal

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 helps u

Answer 2

Controlled vs Un-Controlled redundancy

Redundancy refers to duplicacy of data in the same database.

Controlled Redundancy:

• It refers to sorting the redundancy as soon as the input is given.
• Although maximum platforms do not support controlled redundancy.

Un-Controlled redundancy:

• It is an inconsistent state which cannot be sorted or controlled.
• It is the most common occurring and realistic situation.