Data Independence in DBMS

A database contains a large amount of data. Not all of that data is user data, some of it can be metadata etc. So, it is very important that a database has data independence.

Data independence basically means that if data is changed at a level, it does not impact the data view at the higher levels.Hence, the data at the higher levels should be independent of the data modification in the lower levels. 

There is two types of data independence. These are −

Logical Data Independence

Logical data is independent from how data is actually stored on the disk. So logical data independence means that all changes done to the database at the virtual or logical level should not change how the data is actually stored on the disk. Also the users view of the data should not be altered even if the data is changed in the logical level.

Physical Data Independence

All the data in the database is actually stored in the form of bits on the disk. So physical data independence means that the changes made to the data on the physical level i.e in the disk storage etc. should not be reflected in the logical level. For example - If the database storage methods are changed or the database is moved, this should not impact the database logical structure.

David Meador

Updated on 20-Jun-2020 07:21:17

• Related Questions & Answers
• What is Data Independence in DBMS?
• Data and structural independence
• Data Dictionary in DBMS
• Data Definition Commands in DBMS
• Data Manipulation Commands in DBMS
• What is data Abstraction in DBMS?
• What is a Data Model in DBMS?
• Explain the object oriented data model in DBMS?
• What is the data Dictionary or metadata in DBMS?
• What is the difference between data and information in DBMS?
• What do you mean by data base management system (dbms)?
• In which year did the first war of Indian Independence take place?
• Deadlocks in DBMS
• What is the role of Rash Behari Bose in the Indian independence movement?
• Partial Dependency in DBMS