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
FDs in Entities : Student entity :                                                Enrolment number →  Student name, Address Course Entity :

How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)

What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

Draw an Entity-Relationship model for the relational schema given in the Appendix. Show all the entities, relationships, relationship names, and attributes and also underline the

Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Determine the Three Views of Data We know that the similar thing, if viewed from dissimilar angles produces difference sights. Similarly, the database that we have formed alrea

Control Files : The redo and control files logs support the rest of the architecture. Every database must have at least one control file, although you have more than one to guard

What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.