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

Question

Suresh Chand · Accepted Answer

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.

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

Leave your Answer:

Hits Counter

Question

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

Leave your Answer: