- Docente: Alessandra Lumini
- Credits: 9
- SSD: ING-INF/05
- Language: Italian
- Moduli: Alessandra Lumini (Modulo 1) Gabriele Monti (Modulo 2)
- Teaching Mode: In-person learning (entirely or partially) (Modulo 1); In-person learning (entirely or partially) (Modulo 2)
- Campus: Cesena
- Corso: Second cycle degree programme (LM) in Computer Engineering (cod. 8200)
Learning outcomes
This course is intended to give students a solid background in databases, with a focus on relational database management systems and data warehouses. Topics include DBMS architecture, DBMS administration, data warehouse design and managing.
Course contents
- Warehousing: architectures; techniques for data analysis; lifecycle; conceptual, logical, and physical design; design of loading procedures.
- DBMS Architecture: Query Optimizer, Transaction Manager, Scheduler, Recovery Manager, Cache Manager, Storage Manager, Access Methods Manager.
- Physical database design: record formats, index
structures, access plans, optimization.
Readings/Bibliography
- R. Ramakrishnan, J. Gehrke. Sistemi di basi di dati.
McGraw-Hill, 2004.
- R. Elmasri, S. Navathe, Sistemi di basi di dati - Fondamenti, Pearson - Addison-Wesley, 2004
- R. Elmasri, S. Navathe, Sistemi di basi di dati - Complementi, Pearson - Addison-Wesley, 2005
- M. Golfarelli, Stefano Rizzi. Data Warehouse: teoria e pratica della progettazione. McGraw-Hill, 2006.
- Slides
Teaching methods
Lecture notes, seminars, guided laboratory activities.
Assessment methods
A final project is required. Written final exam and optional
final oral examination.
Teaching tools
Slides, PC, lab.
Links to further information
http://bias.csr.unibo.it/lumini/silm/
Office hours
See the website of Alessandra Lumini
See the website of Gabriele Monti