Database Systems II
- Overview
- Assessment methods
- Learning objectives
- Contents
- Full programme
- Delivery method
- Teaching methods
- Contacts/Info
It is required basic knowledge of relational DBMS.
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%).
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 (deadlock)
O4. Know the main NoSQL data models
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.
Lectures will cover the following topics:
Physical structures (14h, training objective O1)
- Physical data organization of data (records, buffer management)
- Data structures and related indexes
- Data access methods
Database optimization (14h, training objective O3)
- Normalization in database design
- Query Optimization
Transaction management (14h, training objective O2)
- concurrency control
- Lock problems
Introduction to NoSQL databases (6h, training objective O4)
- NoSQL data models (key-value, document-based)
refer to "contents" section
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).
Teacher is available on student requests.