This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
teaching:infoh419 [2022/09/19 11:24] ezimanyi [Books] |
teaching:infoh419 [2022/09/19 15:07] ezimanyi [Group Project] |
||
---|---|---|---|
Line 38: | Line 38: | ||
===== Books ===== | ===== Books ===== | ||
- | * [[https://link.springer.com/978-3-662-65167-4|Data Warehouse Systems: Design and Implementation]], second edition, Alejandro A. Vaisman and Esteban Zimányi. Springer, 20<22. | + | * [[https://link.springer.com/978-3-662-65167-4|Data Warehouse Systems: Design and Implementation]], second edition, Alejandro A. Vaisman and Esteban Zimányi. Springer, 2022. |
* [[http://www.morganclaypool.com/doi/abs/10.2200/s00299ed1v01y201009dtm009|Multidimensional Databases and Data Warehousing]] by Cristian S. Jensen, Torben Bach Pedersen, and Christian Thomsen. Morgan & Claypool Publishers. | * [[http://www.morganclaypool.com/doi/abs/10.2200/s00299ed1v01y201009dtm009|Multidimensional Databases and Data Warehousing]] by Cristian S. Jensen, Torben Bach Pedersen, and Christian Thomsen. Morgan & Claypool Publishers. | ||
* [[http://www.mcgraw-hill.co.uk/html/0071610391.html|Data Warehouse Design: Modern Principles and Methodologies]] by Matteo Golfarelli and Stefano Rizzi. McGraw-Hill, 2009 | * [[http://www.mcgraw-hill.co.uk/html/0071610391.html|Data Warehouse Design: Modern Principles and Methodologies]] by Matteo Golfarelli and Stefano Rizzi. McGraw-Hill, 2009 | ||
Line 95: | Line 95: | ||
The project of the course consist of 2 parts: | The project of the course consist of 2 parts: | ||
- | * Part I: Implement the TPC-DS benchmark (deadline 1/11/2021) | + | * Part I: Implement the TPC-DS benchmark (deadline 1/11/2022) |
- | * Part II: Implement the TPC-DI benchmark (deadline 24/12/2021) | + | * Part II: Implement the TPC-DI benchmark (deadline 24/12/2022) |
You have free choice to use the tools on which the two benchmarks will be implemented. For example, the TPC-DS benchmark could be implemented on SQL Server Analysis Services, Pentaho Analysis Services (aka Mondrian), etc. Similarly, the TPC-DI benchmark could be implemented on SQL Server Integration Services, Pentaho Data Integration, Talend Data Studio, SQL scripts, etc., which then load the data warehouse on a DBMS such as SQL Server, Oracle, PostgreSQL, etc. | You have free choice to use the tools on which the two benchmarks will be implemented. For example, the TPC-DS benchmark could be implemented on SQL Server Analysis Services, Pentaho Analysis Services (aka Mondrian), etc. Similarly, the TPC-DI benchmark could be implemented on SQL Server Integration Services, Pentaho Data Integration, Talend Data Studio, SQL scripts, etc., which then load the data warehouse on a DBMS such as SQL Server, Oracle, PostgreSQL, etc. | ||
Line 108: | Line 108: | ||
The project evaluation will count for 30% of your total grade. This may seem undervalued, however, putting effort in the project will definitely help you in achieving a better understanding of the course material which will result in a better score in the paper exam which amounts for 70% of the grade. | The project evaluation will count for 30% of your total grade. This may seem undervalued, however, putting effort in the project will definitely help you in achieving a better understanding of the course material which will result in a better score in the paper exam which amounts for 70% of the grade. | ||
+ | |||
+ | ===== Tools of the previous year ===== | ||
+ | |||
+ | SQL Server, PostgreSQL, mySQL, Oracle, SQLite, mariadb, Spark SQL, DB2/Airflow, Microsoft Azure SQL, Citus, AWS Aurora, Google BigQuery, Impala | ||
===== Groups of the current year ===== | ===== Groups of the current year ===== | ||
- | * SQL Server: Nicole Zafalón, Diogo Rapas, Andrés Espinal, Adam Broniewski | + | TBD |
- | * PostgreSQL: Niccolò Morabito, CHUN HAN LI, Víctor Diví, Filip Sotiroski | + | |
- | * mySQL: Valada kylynnyk, Yanjian Zhang, Zhicheng Lou, Kainaat Amjid | + | |
- | * Oracle: El Achouchi Iliass, Belgada Wassim, Ajouaou Soufiane | + | |
- | * SQLite: Laamiri Achraf, Mareghni Nidhal, Kuete Kamta Frank Jordan | + | |
- | * mariadb: Tejaswini Dhupad, Himanshu Choudhary, Kamdem Tagne Thomas Borel, Sergio Postigo | + | |
- | * Spark SQL: Yi Wu, Hang Yu, Zhiyang Guo, Mohammad Zain Abbas | + | |
- | * DB2/Airflow: Md Jamiur Rahman Rifat, Khushnur Binte Jahangir, Asha Said Seif, Pietro Ferrazzi | + | |
- | * Microsoft Azure SQL: Davide Rendina, Marita Hernandez, Luiz Fonseca, Zyrako Musaj | + | |
- | * Citus: Nazgul K. Rakhimzhanova, Mohammad Ismail Tirmizi, Maël Touret, Wassim Kezai | + | |
- | * AWS Aurora: Hind Bakkali, Gaëlle Frauenkron, Mahmut Asım Onat, Salma Salmani | + | |
- | * Google BigQuery: Soufian El Bakkali Tamara, Maciej Piekarski, David Silberwasser, Sami Abdul Sater | + | |
- | * Impala: Yahya Bakkali, Amirmohammad Fallahi, Maxime Hauwaert, Alexandre Libert | + | |
===== Examinations from Previous Years ===== | ===== Examinations from Previous Years ===== | ||