MindStudy - MindStudy

Question:

Published on: 22 December, 2024

Describe the Three-Schema Architecture of DBMS. Distinguish Physical Data Independence and Logical Independence.

Answer:

The Three-Schema Architecture:

The goal of the three-schema architecture is to separate the user applications and the physical database. In this architecture, schemas can be defined at 3 levels:

Internal level or Internal schema: Describes the physical storage structure of the database. The internal schema uses a physical data model and describes the complete details of data storage and access paths for the database.
Conceptual level or Conceptual schema: Describes the structure of the whole database for a community of users. It hides the details of physical storage structures and concentrates on describing entities, data types, relationships, user operations, and constraints. Implementation data model can be used at this level.
External level or External schema: It includes a number of external schemas or user views. Each external schema describes the part of the database that a particular user is interested in and hides the rest of the database from user. Implementation data model can be used at this level.

DATA INDEPENDENCE

The disjointing of data descriptions from the application programs (or user-interfaces) that uses the data is called data independence. Data independence is one of the main advantages of DBMS. The three-schema architecture provides the concept of data independence, which means that upper-levels are unaffected by changes to lower-levels. The three schemas architecture makes it easier to achieve true data independence. There are two kinds of data independence.

Physical data independence
- The ability to modify the physical scheme without causing application programs to be rewritten.
- Modifications at this level are usually to improve performance.

Logical data independence
- The ability to modify the conceptual scheme without causing application programs to be rewritten.
- Usually done when logical structure of database is altered.

Logical data independence is harder to achieve as the application programs are usually heavily dependent on the logical structure of the data. An analogy is made to abstract data types in programming languages.

Subjects

Design and Analysis of Algorithm Mobile computing Compiler Design Database Management System C Programming and Practices Software Engineering

Trending

What are the differences between Primary Index, Secondary Index, and Clustering Index?

22 December, 2024

Design a Generalization- Specialization hierarchy for a motor vehicle sales company. The company sells motor-cycles, passenger cars, vans, buses. Justify your placement of attributes at each level of the hierarchy. Explain why they should not be placed at a higher or lower level.

22 December, 2024

Let T1, T2, T3 be transactions that operate on the same data items A, B, C. Let r1(A) means that T1 reads A, w1(A) means that T1 writes A and so on for T2 and T3. Consider the following schedule: S1: r2(C), r2(B), w2(B), r3(C), r1(A), w1(A), w3(B), w3(C), r2(A), r1(B), w1(B), w2(A). Is the schedule serializable and why?

22 December, 2024

Consider the following relations and write down expressions for the following queries:

EMP (eid, ename, age, address, salary)

Works (eid, did, hours)

Dept (did, dname, managerid)

List the names of employees who work for the ‘Research’ department for 8 hours using Relational Algebra.
List the name and address of all employees with department number 5 using Relational Calculas.
Find the managerid of managers who manage only departments with budgets greater than 1 lac using SQL.
Find the employee who has highest salary using SQL.

23 January, 2022

What is attribute inheritance? Describe the concept of specialization and generalization in the context of ER-data model.

22 December, 2024