Define data independence, Database Management System

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in one level could not change the schema definition in the next higher level. Two kinds of Data Independence:

  • Physical Data Independence: Change in physical level could not affect the logical level.
  • Logical Data Independence: Change in logical level could affect the view level.

 

 

 

1540_Data Independence.png

Posted Date: 7/30/2012 1:35:59 AM | Location : United States







Related Discussions:- Define data independence, Assignment Help, Ask Question on Define data independence, Get Answer, Expert's Help, Define data independence Discussions

Write discussion on Define data independence
Your posts are moderated
Related Questions
When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place

Write short notes on relational constraints? Relational Constraints are: 1. NOT NULL 2. Unique 3. Primary key 4. Foreign key 5. Table check


Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is

Explain what is RDBMS ? RDBMS - RDBMS is a database management system (DBMS) which stores data within the form of relations. Relational databases are powerful since they need f

What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

A B-tree of order how much children m has maximum ? m has maximum m mchildren in a B tree.

Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai