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 [2018/10/17 09:50] ezimanyi [Groups of the current year] |
teaching:infoh419 [2022/09/19 11:25] ezimanyi [Books] |
||
|---|---|---|---|
| Line 38: | Line 38: | ||
| ===== Books ===== | ===== Books ===== | ||
| - | * [[https://www.springer.com/9783642546549|Data Warehouse Systems: Design and Implementation]] by Alejandro A. Vaisman and Esteban Zimányi. Springer, 2014. | + | * [[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/2018) | + | * Part I: Implement the TPC-DS benchmark (deadline 1/11/2021) |
| - | * Part II: Implement the TPC-DI benchmark (deadline 20/12/2018) | + | * Part II: Implement the TPC-DI benchmark (deadline 24/12/2021) |
| 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. | ||
| - | Furthermore, both benchmarks can be implemented with several scale factors, which determine the size of the resulting data warehouse. For the purposes of this project you can use the smallest scale factor. | + | Furthermore, both benchmarks must be implemented with several scale factors, which determine the size of the resulting data warehouse. You DO NOT need to use the scale factors mentioned in the TPC requirements. The pedagogical objectives aimed at is that you learn how to properly perform a benchmark. Therefore, you need to estimate the biggest scale factor that you can put on your own computer: this will be your reference scale factor, say 1.0, and then you will need to have 3 smaller scale factors, e.g., at 0.1, 0.2, and 0.5 of the full size in order to see the evolution of the performance. |
| - | The project is carried out in groups of 3 to 4 persons, which will be the same for the two parts. Before you can submit part I of the project, you will have to register in a group. For this, please send an email to the lecturer with the information about your group by 1/10/2018 at the latest. The submission deadlines for parts I and II are strict. | + | The project is carried out in groups of 3-4 persons, which will be the same for the two parts. Before you can submit part I of the project, you will have to register in a group. For this, please send an email to the lecturer with the information about your group by 1/10/2020 at the latest. The submission deadlines for parts I and II are strict. |
| The deliverables expected for each part of the project are the following: | The deliverables expected for each part of the project are the following: | ||
| Line 111: | Line 111: | ||
| ===== Groups of the current year ===== | ===== Groups of the current year ===== | ||
| - | * MySQL: Sara Diaz, Buse Ozer, Pinar Turkyilmaz and Shabana Salmaan | + | * SQL Server: Nicole Zafalón, Diogo Rapas, Andrés Espinal, Adam Broniewski |
| - | * Group 2: Carlos Badillo, Sokratis Papadopoulos, Ioannis Prapas, Gabriela Martinez | + | * PostgreSQL: Niccolò Morabito, CHUN HAN LI, Víctor Diví, Filip Sotiroski |
| - | * Apache Spark, Apache Hive, Kubernetes, Google Cloud Platform (GPC): Ricardo Rojas Ruiz, Annemarie Burger, Danilo J. Acosta Villalobos, Elena Ouro Paz | + | * mySQL: Valada kylynnyk, Yanjian Zhang, Zhicheng Lou, Kainaat Amjid |
| - | * MariaDB: Gonçalo Moreira, Nezrin Necefzade, Rémy Detobel, Shafagh Kashefzarelialestani | + | * Oracle: El Achouchi Iliass, Belgada Wassim, Ajouaou Soufiane |
| - | * Cloudera Impala, Hadoop, Google Cloud Platform (GPC): Eugen Patrascu, Kunal Arora, Edoardo Conte, Carlos E. Muniz Cuza | + | * SQLite: Laamiri Achraf, Mareghni Nidhal, Kuete Kamta Frank Jordan |
| - | * Group 6: Evgeny Pozdeev, Fernando Mendes Stefanini, Braulio Blanco Lambruschini, Pablo Jose Lopez Estigarribia | + | * mariadb: Tejaswini Dhupad, Himanshu Choudhary, Kamdem Tagne Thomas Borel, Sergio Postigo |
| - | * Apache Spark over MySQL: Ankush Sharma, René Gomez, Haftamu Hailu, Kaoutar Chennaf | + | * Spark SQL: Yi Wu, Hang Yu, Zhiyang Guo, Mohammad Zain Abbas |
| - | * PostgreSQL: Pablo Molina Mata, Danish Amjad, Carlos Martínez Lorenzo | + | * DB2/Airflow: Md Jamiur Rahman Rifat, Khushnur Binte Jahangir, Asha Said Seif, Pietro Ferrazzi |
| - | * SQL Server: Sivaporn Homvanish, Tzu-man Wu, Ainhoa Zapirain Mariezcurrena | + | * Microsoft Azure SQL: Davide Rendina, Marita Hernandez, Luiz Fonseca, Zyrako Musaj |
| - | * MemSQL: Amritansh Sharma, Dwi Prasetyo Adi Nugroho, Haydar Ali Ismail, Pratham Solanki | + | * 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 ===== | ||