What is Data Independence?
Data independence means that “the application is independent of the storage structure and access strategy of data”. In other words, The ability to modify the schema definition in one level should not affect the schema definition in the next higher level. Two types of Data Independence: • Physical Data Independence : Modification in physical level should not affect the logical level. • Logical Data Independence : Modification in logical level should affect the view level. Logical Data Independence is more difficult to achieve.
Data independence means that “the application is independent of the storage structure and access strategy of data”. In other words, The ability to modify the schema definition in one level should not affect the schema definition in the next higher level.Two types of Data Independence:Ø Physical Data Independence: Modification in physical level should not affect the logical level.Ø Logical Data Independence: Modification in logical level should affect the view level.
Data independence is a form of database management that keeps data separated from all programs that make use of the data. As a cornerstone for the idea of a DBMS or database management system, data independence ensures that the data cannot be redefined or reorganized by any of the programs that make use of the data. In this manner, the data remains accessible, but is also stable and cannot be corrupted by the applications using it. Database management within the environment of a centralized DBMS relies on the process of data independence. While data transparency still exists as far as the ability of different applications to access and use the data for completing tasks, no program or application can read and then begin to make changes to the data itself. The consistency of the data makes the overall process of maintaining and managing a single database or multiple databases within a single environment much easier. The concept of data independence is different from another approach refe
