Insulation between conceptual and physical structures, Database Management System

Insulation between conceptual and physical structures

It can be defined as:

1. The Database Administrator should be capable to vary the storage structures without affecting users' views.

2. The internal structure of the database should be unaffected by the varies to the physical aspects of the storage, like changing to a new storage device.

3. The DBA should be able to vary the conceptual structure of the database without affecting all users.

 

Posted Date: 3/5/2013 5:05:55 AM | Location : United States







Related Discussions:- Insulation between conceptual and physical structures, Assignment Help, Ask Question on Insulation between conceptual and physical structures, Get Answer, Expert's Help, Insulation between conceptual and physical structures Discussions

Write discussion on Insulation between conceptual and physical structures
Your posts are moderated
Related Questions
What does Aggregation mean?

Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet

Project Description: Oracle Certified Professional with 20 years of practice, Oracle version 6.0.34, 7.3, 8.0, 8i, 9i, 10G, 11G, 12C. Crossplatform migration, Informix, MSSql

Consider the relations described below: PHYSICIAN (regno, name, telno, city) PATIENT (pname, street, city) VISIT (pname, regno, date_of_visit, fee) Where the regno and pname ide


Let consider the given partial relation EMP. Let us make some sub-queries for them EMPNO ENAME JOB SAL DEPTNO 7566

What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have

Explain the term- signal-to-noise ratio A signal-to-noise ratio of 20 dB means that S/N = 100. As log2101 is around 6.658, the Shannon limit is around 19.975 kbps. The Nyquist