Scribd
Upload
19 views2 pages

Chapter2 DBMS Architecture and Abstraction

The document outlines the three-level architecture of a Database Management System (DBMS), which includes the External, Conceptual, and Internal levels. It emphasizes the importance of data abstraction and independence, allowing for modifications in the logical and physical schemas without affecting user views. This architecture enhances security and flexibility in managing databases.

Uploaded by

Amit Shekhar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
19 views2 pages

Chapter2 DBMS Architecture and Abstraction

The document outlines the three-level architecture of a Database Management System (DBMS), which includes the External, Conceptual, and Internal levels. It emphasizes the importance of data abstraction and independence, allowing for modifications in the logical and physical schemas without affecting user views. This architecture enhances security and flexibility in managing databases.

Uploaded by

Amit Shekhar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Chapter 2: DBMS Architecture and Data Abstraction

DBMS Architecture and Data Abstraction

Three-Level Architecture of DBMS:

1. External Level (View Level):

- Closest to the users.

- Describes only part of the entire database that a particular user group is interested in.

- Users have different views customized to their needs.

2. Conceptual Level (Logical Level):

- Describes what data is stored in the database and the relationships among the data.

- Hides the physical storage details.

- Focuses on logical structure like tables, relationships, constraints, etc.

3. Internal Level (Physical Level):

- Closest to the storage system.

- Describes how the data is actually stored in the database (e.g., indexes, pointers, data blocks).

Mapping Between Levels:

- External/Conceptual Mapping: Maps user views to the logical schema.

- Conceptual/Internal Mapping: Maps logical schema to the physical storage.

Data Independence:

- Logical Data Independence: Ability to change the logical schema without altering external

schemas.

- Physical Data Independence: Ability to change the internal schema without altering the conceptual
schema.

Importance of 3-Level Architecture:

- Separates user applications and physical database.

- Enhances database security and abstraction.

- Provides flexibility to modify storage structure or user views independently.

Summary:

- DBMS follows a three-level architecture: External, Conceptual, and Internal.

- Data abstraction helps in separating the logical and physical aspects of the data.

- Data independence is a key advantage of this architecture.

You might also like