Advanced Databases

Giorgio Ghelli      Tel. 0502212780

Database systems occupy a central position in our information-based society, and computer scientist and database application designers should have a good knowledge about both the theoretical and the engineering concepts that underline these systems to ensure the application performance desired. The student who completes the course successfully will demonstrate advanced technical knowledge of the main issues related to the implementation of both classical centralized relational database systems for operational and OLAP processing and of recent advances in non-relational data models (columnar, document, key-value, graph) and scalable distributed architectures. The skills provided will make the student a sophisticated developer of high-performance database applications.

• Internals of relational database management systems.
• Data Warehousing management systems and On-Line Analytical Processing.
• Extract-Transform-Load and query/reporting in OLAP systems.
• Beyond SQL: NoSQL data management systems for big data.
• Distributed data processing and the Map-Reduce paradigm