JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech IV DATABASE MANAGEMENT SYSTEMS Previous Question Paper (July/August - 2022 - R18)

Data independence is the capacity to change the schema definition in one level of a database system without requiring a change in the schema definition at the next higher level. It is a critical property that separates the physical storage of data from the conceptual and external views, ensuring that application programs remain unaffected by changes in data organization.

There are two types of data independence:

1. Logical Data Independence: The ability to change the conceptual schema without having to change the external schemas or application programs. This allows for modifications such as adding new entities, attributes, or relationships to the database without breaking existing user views.
2. Physical Data Independence: The ability to change the physical schema (internal level) without having to change the conceptual schema. This includes changes to storage structures, file organizations, or indexing strategies to improve performance, which remain transparent to the conceptual model and the users.

The overall structure of a database management system is designed to manage the interaction between users and the stored data. The architecture is typically divided into several key components:

• Query Processor: This component parses, optimizes, and executes user queries. It includes the DDL interpreter, DML compiler, and the query evaluation engine which determines the most efficient way to access data.
• Storage Manager: This is the interface between the low-level data stored in the database and the queries submitted to the system. It consists of the Authorization and Integrity Manager, Transaction Manager, File Manager, and Buffer Manager.
• Disk Storage: This represents the physical layer where the actual data, indices, and metadata (data dictionary) are stored.

The system structure functions by receiving a user request, which is processed by the Query Processor. The Query Processor then interacts with the Storage Manager to retrieve or update the necessary data from the physical storage. The Buffer Manager ensures efficient data transfer between disk and main memory, while the Transaction Manager guarantees ACID properties during concurrent operations.