Data Independence in DBMS - Shikshaglobe

A database management system (DBMS) is a collection of programs that enables users to create and maintain a database. A DBMS makes it possible for end users to create, read, update and delete data in a database. A DBMS hides the details of how the data is stored from users and provides a consistent interface to access and manipulate the data. This abstraction is called data independence. Data independence means that the application is independent of the physical storage of the data. The logical structure of the data is separate from the physical structure.Data independence is the capacity of a system to shield applications from changes in the structure of data stored in the system. There are two types of data independence: physical data independence and logical data independence. Physical data independence means that the application is not affected by changes to the physical structure of the data, such as changes to the location, format, or storage device. Logical data independence means that the application is not affected by changes to the logical structure of the data, such as changes to the relationships between tables or changes to the attributes of tables.Data Independence is the capacity of a database to be able to make changes to its structure without affecting the application that accesses the data. This means that the application can continue to access and manipulate the data even after the underlying structure of the database has been changed.There are two types of data independence: physical and logical. Physical data independence means that changes to the physical structure of the database (such as the location of files or changes to the hardware) do not affect the application. Logical data independence means that changes to the logical structure of the database (such as adding, deleting or modifying fields, records or tables) do not affect the application.Data independence is an important characteristic of a good database design because it allows for flexibility and easy maintenance. A well-designed database should be able to accommodate changes without having to rewriting large sections of code or redesigning entire applications.Data independence is the capacity of a system to shield applications from changes to the structure of data. It has two types:1. Physical data independence: The capacity to change the physical arrangement of data without influencing application programs. For example, moving data to a faster storage device.2. Logical data independence: The capacity to change the logical arrangement of data without influencing application programs. For example, adding a new field to a database table.