Difference Between Physical and Logical Data Independence
Physical Data Independence |
Logical Data Independence |
---|---|
It mainly concerns how the data is stored in the system. |
It mainly concerns about changes to the structure or data definition. |
It is easier to achieve than logical independence. |
It is difficult to achieve compared to physical independence. |
To make changes at the physical level we generally do not require changes at the application program level. |
To make changes at the logical level, we need to make changes at the application level. |
It tells about the internal schema. |
It tells about the conceptual schema. |
There may or may not be a need for changes to be made at the internal level to improve the structure. |
Whenever the logical structure of the database has to be changed, the changes made at the logical level are important. |
Example- change in compression technology, hashing algorithm, storage device etc. |
Example – adding/modifying or deleting a new attribute. |
What is Data Independence in DBMS?
Data independence is a property of a database management system by which we can change the database schema at one level of the database system without changing the database schema at the next higher level. In this article, we will learn in full detail about data independence and will also see its types. If you read it completely, you will understand it easily.
Contact Us