SHARE
SPREAD
HELP

The Tradition of Sharing

Help your friends and juniors by posting answers to the questions that you know. Also post questions that are not available.


To start with, Sr2Jr’s first step is to reduce the expenses related to education. To achieve this goal Sr2Jr organized the textbook’s question and answers. Sr2Jr is community based and need your support to fill the question and answers. The question and answers posted will be available free of cost to all.

 

#
Authors:
Elmasri Navathe
Chapter:
System Concepts And Architecture
Exercise:
Review Questions
Question:5 | ISBN:9780133970777 | Edition: 7

Question

What is the difference between logic data independence and physical data independence

TextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbook

Answer

Ans:The capacity to change the schema at one level of a database system without having to change the schema at the next higher level. We can define two types of data independence:

Logical data independence

Physical data independence

Logical data independence:It is the capacity to change the structure of the whole database without having to change the part of thedatabase that a particular user group.some times e may change the structure of database by adding details ,data items and sometimes e reduce like removing details,data items.

Physical data independence:It is the capacity to change the physical storage structure of the database without having to change the structure of the whole database.Changes in the physical storege is needed because physical files had to be reorganized.That means creating additional access structures—to improve the performance of retrieval or update.we should provide new accesspath to retrive the data.

physical data independence exists in most databases and physical details like location of data on disk, and hardware details of storage encoding,placement, compression, splitting, merging of records, and so on are hidden from the user.Where as logical data independence is harder to achieve because it allows structural and constraint changes without affecting application programs.

we have a multiple-level DBMS, its catalog must be expanded to include information on how to map requests and data among the various levels.

The DBMS uses additional software to accomplish these mappings by referring to the mapping information in the catalog. Data independence occurs because when the schema is changed at some level, the schema at the next higher level remains unchanged; only the mapping between the two levels is changed. Hence, application programs referring to the higher-level schema need not be changed.

 

0 0

Discussions

Post the discussion to improve the above solution.