Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
DBMS BCA Unit-1 DBMS - Introduction The File Based System Database System vs. File Based System Limitations of File Based System Database System Components Advantages of Database Approach DBMS ARCHITECTURE Three Level Architecture of DBMS External or View Level Conceptual Level Internal or Physical Level Data Independence Physical DBMS Architecture Database Manager Database Users Database Administrator (DBA) Roles and Responsibilities of DBA Data Models The Relational Data Model The Network Data Model The Hierarchical Data Model MySQL Installation in Ubuntu


Data Independence

The ability to modify a schema definition in one level without affecting a scheme definition in the next higher level is called DATA INDEPENDENCE.
  • Physical Data Independence
    • It refers to the ability to modify the scheme followed at the physical level without affecting the scheme followed at the conceptual level.
    • The application programs remain the same even though the scheme at the physical level gets modified.
    • Modifications at the physical level are occasionally necessary in order to improve performance of the system.
  • Logical Data Independence
    • It refers to the ability to modify the conceptual scheme without causing any changes in the schemes followed at view levels.
    • The logical data independence ensures that the application programs remain the same.
    • Modifications at the conceptual level are necessary whenever logical structures of the database get altered because of some unavoidable reasons.
It is more difficult to achieve logical data independence than the physical data independence.
The reason being that the application programs are heavily dependent on the logical structure of the database.