Logical Data Independence:
Logical data is data about database, that is, it stores information about how
data is managed inside. For example, a table (relation) stored in the database
and all its constraints, applied on that relation.
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.
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.
For example,
in case we want to change or upgrade the storage system itself − suppose we
want to replace hard-disks with SSD − it should not have any impact on the
logical data or schemas.
No comments:
Post a Comment