Advanced databases

Code 641AA
Credits 9

Learning outcomes

The course provides advanced technical knowledge of the main issues related to the implementation and performance optimization 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.


Syllabus

- Internals of relational database management systems.
- Optimizations of 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