What is data independence, Database Management System

What is data independence?

Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data independence. The first type is data independence for data that is accomplished in a database management system (DBMS). It permits the database to be structurally changed without affecting most existing programs. Programs access data in a DBMS through field and are concerned with just the data fields they use, not the format of the finished record. Therefore, when the record layout is updated (fields added, deleted or changed in size), the only programs which must be changed are those in which use those new fields.

Posted Date: 5/13/2013 2:27:14 AM | Location : United States

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

Write discussion on What is data independence
Your posts are moderated
Related Questions
Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)

Write short note on Data models? Data models: A data model is an abstract model which elaborates how data is represented and accessed. The term data model has two commonly ac

Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them.         Ans: Entity:   An entity is a "thing" or "object" in th

Question: (a) Can a set of data requirements be correctly modelled by two or more different ER diagrams? Explain your answer. You may use a small example, if you think it will

With the linear commit protocol, sites are connected in a chain, and the subtransaction at the left-hand end of the chain initiates the protocol. Propose a crash recovery protocol

a project based on normalization with first, second and third normalization. There need to be a diagram also

Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category

Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

MySQL Database Merge Project Description: I have two databases, I need merge the data of one database into another Work to be done online right now. Payment can be done

For problems 1-4, give all candidate keys for the tables with FDs specified.  Composite candidate keys must be put in parentheses, and candidate keys must be separated with commas