Data Independence

Data Independence refers to the ability to modify the schema or structure of a database system without affecting the applications or programs that use it. In other words, it is the ability to separate the application from the physical implementation of the database.

A database system follows a multilayered architecture. In order to make changes in database without affecting the other data a database system is always designed in multi layers. In database, there are also some database system data which support user data to be locate and retrieve easily and known as meta data.

Meta data always follows multi layer architecture, so that if any changes need to do in a layer, it should not affect the other layers.

Data Independence is of two types:

  1. Logical Data Independence
  2. Physical Data Independence

Logical Data Independence

Logical Data Independence is the ability to modify the logical schema of a database without affecting the application programs that use it. Logical schema refers to the organization of data in a database that is visible to users and application programs. It includes the definition of tables, columns, relationships, and constraints.

When changes are made to the logical schema of a database, it is important to ensure that the application programs that use the database are not affected. This is achieved through Logical Data Independence. With Logical Data Independence, modifications can be made to the logical schema without requiring changes to the application programs that use it.

For example, if a new column is added to a table in a database, the application programs that use that table do not need to be modified as long as the new column is not required by the application. This is because the application programs are not aware of the physical implementation of the database and only interact with the logical schema.

Similarly, if a table is split into two separate tables or merged with another table, the application programs that use the table should not be affected as long as the data relationships and integrity are maintained.

Logical Data Independence is essential in a database system because it allows for the separation of the logical schema and the application programs. This reduces the cost and time involved in modifying the database system. It also allows for greater flexibility and scalability in the system, as changes can be made to the logical schema without impacting the applications that use it.

Physical Data Independence

Physical Data Independence is the ability to modify the physical schema of a database without affecting the logical schema or the application programs that use it. Physical schema refers to the way data is stored in a database and includes details such as the file format, storage structures, indexing, and partitioning.

When changes are made to the physical schema of a database, it is important to ensure that the logical schema and application programs that use the database are not affected. This is achieved through Physical Data Independence. With Physical Data Independence, modifications can be made to the physical schema without requiring changes to the logical schema or application programs that use it.

For example, if the physical storage structure of a table is changed from one type to another, such as from a flat file to a binary file, the application programs that use that table do not need to be modified as long as the logical schema remains the same. This is because the application programs are not aware of the physical implementation of the database and only interact with the logical schema.

Similarly, if the location of a table is changed on the storage device or the partitioning scheme is modified, the application programs that use the table should not be affected as long as the logical schema and data relationships remain intact.

Physical Data Independence is important in a database system because it allows for changes to the physical storage structure of the database without affecting the logical schema or application programs that use it. This makes it easier to manage and maintain the database system, and provides greater flexibility and scalability as the physical storage requirements of the database evolve over time.

Wordpress Social Share Plugin powered by Ultimatelysocial
Wordpress Social Share Plugin powered by Ultimatelysocial