Politecnico di Torino
Politecnico di Torino
   
Login  
it
Politecnico di Torino
Academic Year 2015/16
01NVVOV
Database management systems
Master of science-level of the Bologna process in Computer Engineering - Torino
Teacher Status SSD Les Ex Lab Years teaching
Chiusano Silvia Anna ORARIO RICEVIMENTO A2 ING-INF/05 46 22 12 8
SSD CFU Activities Area context
ING-INF/05 8 B - Caratterizzanti Ingegneria informatica
Esclusioni:
01NVU
Subject fundamentals
The course is taught in English.
The course, compulsory for the Master degree in Computer Engineering, is offered on the 1st semester of the 1st year. The course addresses the fundamental issues in the technology of database management systems and introduces database management techniques for data warehouses (database systems specialized in strategic decision support), typically characterized by the need of managing very large databases. Both traditional OLAP (On Line Analytical Processing) analysis techniques and complex data mining techniques will be addressed. Laboratory sessions allow experimental activities, both on technological characteristics and data analysis, on the most widespread commercial and open-source products.
Expected learning outcomes
- Knowledge of the main technological characteristics of a database management system: concurrent data access management, reliability, physical level structures, data access optimization.
- Ability to design the physical data structures for a relational database.
- Knowledge of distributed database system architecture and replication management.
- Knowledge of active database systems and SQL statements for trigger definition.
- Ability to write triggers in the SQL language.
- Knowledge of data warehouse architecture and of the methodology for conceptual, logical, and physical design of a data warehouse.
- Ability to design a data warehouse.
- Knowledge of the SQL statements for OLAP queries in a data warehouse.
- Ability to write OLAP queries in the SQL language.
- Knowledge of the major data mining algorithms for classification, clustering, and association rule mining.
Prerequisites / Assumed knowledge
Knowledge of the relational model and SQL language and basic programming skills.
Contents
- Technological characteristics of a database management system: concurrent data access management, reliability, physical level structures, data access optimization (1.8 cr.)
- Active database systems and SQL statements for trigger definition (0.4 cr.)
- Distributed database system architecture and replication management (0.4 cr.)
- Data warehouses: architecture, methodology for conceptual, logical, and physical design, SQL statements for OLAP queries (1.4 cr.)
- Data mining algorithms: classification, clustering, and association rule mining (1.6 cr.)
Delivery modes

The course includes practices on the lecture topics, and in particular SQL language, physical database design, and conceptual, logical, and physical data warehouse design (1.8 cr.). Students will prepare an individual written report on exercises proposed during the course. The report will contribute to the final exam grade. The course includes laboratory sessions on the SQL language (also for database physical design) and data warehouse design (1.2 cr.). Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.
Texts, readings, handouts and other learning resources
Reference books:
- Atzeni, Ceri, Paraboschi, Torlone, 'Database systems', 1 ed., McGraw Hill, 1999.
- Golfarelli, Rizzi, 'Data warehouse: teoria e pratica della progettazione', 2 ed., McGraw Hill, 2006.
- Tan, Steinbach, Kumar, 'An introduction to data mining', Addison Wesley, 2005.

Copies of the slides used during the lectures, examples of written exams and exercises, and manuals for the activities in the laboratory will be made available. All teaching material is downloadable from the course website or the Portal.
Assessment and grading criteria
The exam includes a written part, the evaluation of the report on the individual practices assigned during the course, and, optionally, an oral part. The written part includes questions and exercises on the main course topics (technological characteristics of a database management system, SQL language, physical database design, conceptual, logical, and physical data warehouse design, data mining algorithms). The oral part includes questions on the topics of the lectures. The final exam grade is defined by evaluating the written part, the report, and, optionally, the oral part.

Programma definitivo per l'A.A.2015/16
Back



© Politecnico di Torino
Corso Duca degli Abruzzi, 24 - 10129 Torino, ITALY
WCAG 2.0 (Level AA)
Contatti