

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- 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