MCA World :: Computer Application ::
Questions :  Answers : Solutions of TMA & Project Assignment  of  MCA courses of IGNOU, NIT & Other Universities.

::: Data Independence in DBMS



Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems

Data Independence in DBMS

Up • RDBMS VS OODBMS • Data Independence in DBMS • Data Redundancy • Functional Dependency • Entity Types & Relationship

Main Chapters

Home
Introduction to Software
Data Structures
System Engineering
Database Management System
Discrete Mathematics
Numerical & Statistical Computing
Software Engineering
Operation Research
Accounting & Finance
Computer Architecture
Operating Systems
Intelligent Systems
Relational Database
Obejct Oiented Systems

Data Independence in DBMS

 Problems Discussed in this chapter

 Question 2:  Discuss the concept of data independence and explain its importance in database environment with the help of a suitable example.

Answer 2:    Data independence, is usually considered from two points of view Physical data independence and Logical data independence. The physical data independence allows changes in the physical storage devices or organization of the files to be made without requiring changes in  the conceptual view or any of the external views and hence in the application programs using the database. Thus the files may migrate from  one type of physical media to another of the file structure may change without any need for changes in the application programs. Logical data independence implies that application programs need not be changed if fields are added to an existing record nor do they have to be changed if fields not used by application programs are deleted. Logical data independence indicates that the conceptual schema can be changed without affecting the existing external schemas. Data independence is advantageous  in the database environment since it allows for changes at one level of the database without affecting other levels.

 Logical data independence is more difficult to achieve than physical  independence. Since application programs are heavily dependent on the logical structure of the data they access .

The concept of data independence is similar in many respect to the concept of abstract data type in modern programming language like C++. Both hide  implementation details from the users. This allow users to concentrate on  the general structure rather than low-level implementation details.

Up ]

 

 

 
 


Home • Introduction to Software • Data Structures • System Engineering • Database Management System • Discrete Mathematics • Numerical & Statistical Computing • Software Engineering • Operation Research • Accounting & Finance • Computer Architecture • Operating Systems • Intelligent Systems • Relational Database • Obejct Oiented Systems



This is complete MCA study materials containing question, solutions, answers, programming, scripts, TMA, Project assignment solutions for aspiring MCA or BCA student. This website may be useful for all in general and IGNOU student in particulars. Disclaimer : Execution and correctness of programs/answers may be established by the users himself and the mcaworld.net shall not held responsible for any damage/loss caused due to the use of code over this site.



Dear Visitor, If you are not able to find what you have been looking for on this site, please do try your search once again with different combination of words in the following Google Tool Bar, Specially designed to provide enhanced search option. Thank you.
Google

Webmaster Bipin Bihari Pandey, An IT Expert of DotNet Technology, MCA from IGNOU
bipin9830@rediffmail.com or bipin9830@yahoo.com