Hello friends, in today's post you have been told about data independence, and how to use it, so let's start
data independence in dbms
In addition to User's Data in Database Management System, there is also a lot of data. DBMS is made up of three types of Schemas, which are about Data or Meta-Data instead of Data
Meta-Data is also stored in the database, once it is stored, it is difficult to improve it in any way. But as the DBMS expands, it needs to change over time to meet the needs of the users. But if all the data is highly dependent, then doing so will become very difficult and complicated.
About Data Data itself is divided into Layered Architecture so that when we make any change in the data on one layer, it does not affect the data located on any other layer. This data is independent but mapped on each other.
types of data independence in DBMS
Logical Data Independence
Logical Data is data about the database, that is, it stores information about how the data is being managed under the database. Logical Data Independence is a type of mechanism that makes itself independent from the actual data stored on the disk. If we make any change in the table format, it does not make any change in the data located on the disk.
Physical Data Independence
All schemas are logical and the actual data is stored on the disk in bit format. Physical data independence is the ability to change physical data without affecting schema and logical data. For example, in case of changing or upgrading the storage system ie using a Solid-State Drive instead of Hard-Disk, there should be no effect on Schema and Logical Data.
Difference between Physical and Logical Data Independence
We can easily understand the difference between them by the table given below:
Physical Data Independence | Logical Data Independence |
It mainly concerns how the data is stored in the system. | It mainly concerns the changes in structure or data definition. |
It is easier to achieve than logical independence. | It is difficult to achieve as compared to physical independence. |
To make changes at the physical level, we usually do not require changes at the application program level. | To make changes at the logical level, we need to make changes at the application level. |
It tells about the internal schema. | It tells about the conceptual schema. |
Changes made at the internal level may or may not be required to improve the structure. | Whenever the logical structure of the database has to be changed, the changes made at the logical level are important. |
Example- change in compression technology, hashing algorithm. | Example – add/modify or delete the new attribute. |
Conclusion
Here in this post, we add all related information about data independence like types of data independence in DBMS, Logical Data Independence, and Physical Data Independence if you want to know what is data independence in dbms then you should read our article at the end.