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
ORA-01722: invalid number
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.)