What is difference between logical data independence and physical data independence?

This answer is restricted. Please login to view the answer of this question.

Login Now

The major difference between logical data independence and physical data independence is

Physical Data Independence Logical Data Independence
It is mainly concerned with how the data is stored in the system. It is mainly concerned with the structure or the changing data definition.
It is easy to retrieve. It is difficult to retrieve because the data is mainly dependent on the logical structure of the data.
As compared to logical independence it is easy to achieve physical data independence. As compared to physical independence it is not easy to achieve logical data independence.
Any change at the physical level does not require change at the application level. The change in the logical level requires a change at the application level.
The modifications made at the internal level may or may not be needed to improve the performance of the structure. The modifications made at the logical level are significant whenever the logical structure of the database is to be changed.
It is concerned with the internal schema. It is concerned with the conceptual schema.
Example: Change in compression techniques, Hashing algorithms, and storage devices, etc. Example: Add/Modify or Delete a new attribute.
If you found any type of error on the answer then please mention on the comment or report an answer or submit your new answer.
Leave your Answer:

Click here to submit your answer.

Discussion
0 Comments
  Loading . . .