Data Independence and it's Types
- Get link
- Other Apps
What is Data Independence?
Data Independence:-
Data Independence is ability to modify a schema definition in one level without affecting a schema definition in the next higher level.
Data Independence is defined as a property of DBMS that helps you to change the Database schema at one level of a Database system without requiring to change the schema at the next higher level.
Types of Data Independence:-
There are two types of Data Independence
1) Physical Data Independence
2) Logical Data Independence
1) Physical Data Independence:-
All the schemas are logical and the actual data is stored in bit format on the disk. Physical data Independence is the power to change the physical data without impacting the schema or logical data.
2) Logical Data Independence:-
Logical data is data about database that is, it stores information about how data is managed inside.
Logical data Independence is a kind of mechanism, which liberalizes itself from actual data stored on the disk. If we do some changes on table format, it should not change the data residing on the disk.
- Get link
- Other Apps
Comments
Post a Comment