Office hours | ||
Monday | 15.30 - 18.30 | Room 291 - Department of Computer Science - Via F. Buonarroti, 2 |
Vengono presentate le tecniche per la realizzazione di sistemi per la gestione di basi di dati, in particolare quelli relazionali. Vengono discusse le funzionalità, le strutture e gli algoritmi dei moduli principali per (a) organizzare i dati nella memoria permanente, (b) per ottimizzare lesecuzione delle operazioni sui dati espresse nel linguaggio SQL (c) per gestire le transazioni e gli accessi concorrenti ai dati.
The course presents the basic concepts, fundamental data structures, and general techniques that are needed to implement a database management system (DBMS) with the main emphasis on relational DBMSs. The course will cover (a) the most frequently used data structures to store and access efficiently sets of data and relationships between them, (b) the techniques used in database management systems to process and optimize queries specified in SQL, (c) the techniques to implement transactions, recovery, and concurrency control, and (d) techniques for physical data base design and tuning.
Lectures with exercises and discussion of students solutions
Fundamentals of relational systems: Relational algebra, Normalization, SQL querying
The course material will be updated as we progress through the semester.
Oral exam on the basis of a written test