JNTU MCA 2022 DATABASE MANAGEMENT SYSTEMS Previous Question Paper (October/November - 2022 - R20)

Data abstraction in a Database Management System (DBMS) is the process of hiding complex implementation details from end-users while providing a simplified view of the data. This is achieved through a three-level architecture:

1. Physical Level (Internal Level): The lowest level of abstraction, describing how data is actually stored in the storage devices, including file structures, indexing, and data compression techniques.
2. Logical Level (Conceptual Level): Describes what data is stored in the database and the relationships among the data. It hides the physical storage details and is typically managed by database administrators.
3. View Level (External Level): The highest level, where only a part of the database is visible to specific users. This level provides security and simplifies interaction by presenting data in a format relevant to the user's needs.

This layering ensures data independence, allowing the physical storage or logical schema to change without requiring modifications to the user applications.

The system structure of a DBMS is divided into several components that manage the interaction between the user and the stored data:

• Query Processor: Parses, compiles, and optimizes user queries to determine the most efficient execution plan.
• Storage Manager: Acts as the interface between low-level data stored in the database and the application programs. It includes the Authorization and Integrity Manager (checking constraints), Transaction Manager (ensuring ACID properties), File Manager (managing space allocation), and Buffer Manager (caching data in memory).
• Disk Storage: The physical storage layer, including data files, indices, and data dictionaries (metadata) that store the structure of the database.

Together, these components ensure that data requests are processed efficiently, securely, and reliably while maintaining data consistency.