Friday, April 15, 2011

What are Physical and Logical data independence?

Physical data independence is the ability to modify the physical schema without causing application programs to be rewritten. Modifications at the physical level are occasionally necessary to improve performance.

Logical data independence is the ability to modify the logical schema without causing application programs to be rewritten. Modifications at the logical level are necessary whenever the logical structure of the database is altered. It is more difficult to achieve.

2 comments:

  1. If I understand correctly, we can achieve logical data independence using views??????/

    ReplyDelete