Database Systems II

Degree course: 
Corso di First cycle degree in COMPUTER SCIENCE
Academic year when starting the degree: 
Academic year in which the course will be held: 
Course type: 
Compulsory subjects, characteristic of the class
Second semester
Standard lectures hours: 
Detail of lecture’s hours: 
Lesson (48 hours)

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%).

Voto Finale

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.