The course aims to give students basic knowledge of the architecture underlying a relational database management system (DBMS). The aim is to provide a set of tools to better control operations on relational data (i.e., queries and storage) in terms of executions and optimizations. With this objective, the course will analyze the essential components of the relational DBMS architecture, presenting the physical structures, transaction management, and concurrency control.
At the end of the course, the student will be able to:
O1. Know the main physical data structures (indexes, access methods) used in the DBMS. O2. Being able to optimize queries to be performed. O3. Recognize and handle problems related to transaction management
Applied knowledge and understanding
The course aims to analyze the DBMS architecture. The skills acquired will allow him to define optimized queries based on the workload and data volume to integrate the application logic with DBMS functionalities efficiently.
Autonomy of judgment and communication skills The main expected learning result is to make the student express an opinion on the database design, related physical data structures and functionalities.
Course Prerequisites
It is required basic knowledge of relational DBMS.
Teaching Methods
The course is organized in 48 hours of lectures. Lectures will present the conceptual and application aspects related to the architecture underlying a relational database management system (DBMS).
Assessment Methods
The exam consists of a written exam of 2 hours in which the student is required to respond to open questions, aimed at verifying the acquisition and proper understanding of the topics presented during the course. The final vote, out of thirty, will take into account the accuracy and quality of the responses (70%), the skill of exposure (10%) and the ability to adequately justify statements, analyzes and opinions (20%).
Contents
Lectures will cover the following topics:
Physical structures (16h, training objective O1) - Physical data organization of data (records, buffer management) - Data structures and related indexes - Data access methods
Database optimization (16h, training objective O3)
- Query Optimization
Transaction management (16h, training objective O2) - concurrency control - Lock problems
