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/09/17 18:39] ezimanyi [Group Project] |
teaching:infoh419 [2018/10/07 14:03] ezimanyi [Groups of the current year] |
||
---|---|---|---|
Line 62: | Line 62: | ||
* {{teaching:infoh419:dw00-refresher.pdf|Refresher Databases}} | * {{teaching:infoh419:dw00-refresher.pdf|Refresher Databases}} | ||
* {{teaching:infoh419:dw01-introduction.pdf|Introduction}} | * {{teaching:infoh419:dw01-introduction.pdf|Introduction}} | ||
- | * {{teaching:infoh419:dw02-cubes.pdf|Cubes}} | ||
* {{teaching:infoh419:database_explosion_report.pdf|Database explosion report}} | * {{teaching:infoh419:database_explosion_report.pdf|Database explosion report}} | ||
* {{teaching:infoh419:database_explosion.pdf|Database explosion}} | * {{teaching:infoh419:database_explosion.pdf|Database explosion}} | ||
- | * {{teaching:infoh419:dw03-dfm.pdf|Dimension Fact Model}} | + | * {{teaching:infoh419:dw02-dfm.pdf|Dimension Fact Model}} |
- | * {{teaching:infoh419:dw04-logicalmodel.pdf|Logical Model}} | + | * {{teaching:infoh419:dw03-logicalmodel.pdf|Logical Model}} |
- | * {{teaching:infoh419:dw05-dimensionchanges.pdf|Dimension Changes}} | + | * {{teaching:infoh419:dw04-dimensionchanges.pdf|Dimension Changes}} |
- | * {{teaching:infoh419:dw06-etl.pdf|ETL}} | + | * {{teaching:infoh419:dw05-etl.pdf|ETL}} |
- | * {{teaching:infoh419:dw07-viewmaterialization.pdf|View Materialization}} | + | * {{teaching:infoh419:dw06-viewmaterialization.pdf|View Materialization}} |
- | * {{teaching:infoh419:dw08-indexing.pdf|Indexing}} | + | * {{teaching:infoh419:dw07-indexing.pdf|Indexing}} |
- | * {{teaching:infoh419:dw09-aggregatecomputation.pdf|Aggregate Computation}} | + | * {{teaching:infoh419:dw08-aggregatecomputation.pdf|Aggregate Computation}} |
- | * {{teaching:infoh419:dw10-conclusion.pdf|Conclusion}} | + | * {{teaching:infoh419:dw09-conclusion.pdf|Conclusion}} |
Line 98: | Line 97: | ||
* Part I: Implement the TPC-DS benchmark (deadline 1/11/2018) | * Part I: Implement the TPC-DS benchmark (deadline 1/11/2018) | ||
* Part II: Implement the TPC-DI benchmark (deadline 20/12/2018) | * Part II: Implement the TPC-DI benchmark (deadline 20/12/2018) | ||
- | You will have free choice to use the tools on which the two benchmarks will be built. For example, the TPC-DS benchmark can be implemented on SQL Server Analysis Services, Pentaho Analysis Services (aka Mondrian), etc. Similarly, the TPC-DI could be implemented on SQL Server Integration Services, Pentaho Data Integration, Talend Data Studio, or even SQL scripts. | + | 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. |
- | The project is carried out in groups of 3 to 4 people. Before you can submit assignment part I, you will have to register in a group. For registering a group send an email to the lecturer. Please to select your group before or on 1/10/2018. The submission deadlines for parts I and II are strict. | + | 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. |
+ | |||
+ | 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 deliverables expected for each part of the project are the following: | ||
+ | * A report in pdf explaining the essential aspects of your implementation, and | ||
+ | * A zip file containing the code of your implementation, with all necessary instructions to be able to replicate your implementation by the lecturer in standard computing infrastructure. | ||
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. | ||
+ | |||
+ | ===== Groups of the current year ===== | ||
+ | |||
+ | * Group 1: Sara Diaz, Buse Ozer, Pinar Turkyilmaz and Shabana Salmaan | ||
+ | * Group 2: Carlos Badillo, Sokratis Papadopoulos, Ioannis Prapas, Gabriela Martinez | ||
+ | * Group 3: Ricardo Rojas Ruiz, Annemarie Burger, Danilo J. Acosta Villalobos, Elena Ouro Paz | ||
+ | * Group 4: Gonçalo Moreira, Nezrin Necefzade, Rémy Detobel, Shafagh Kashefzarelialestani | ||
+ | * Group 5: Eugen Patrascu, Kunal Arora, Edoardo Conte, Carlos E. Muniz Cuza | ||
+ | * Group 6: Evgeny Pozdeev, Fernando Mendes Stefanini, Braulio Blanco Lambruschini, Pablo Jose Lopez Estigarribia | ||
+ | * Group 7: Ankush Sharma, René Gomez, Haftamu Hailu, Kaoutar Chennaf | ||
+ | * Group 8: Pablo Molina Mata, Danish Amjad, Carlos Martínez Lorenzo | ||
+ | * Group 9: Sivaporn Homvanish, Tzu-man Wu, Ainhoa Zapirain Mariezcurrena | ||
+ | |||
===== Examinations from Previous Years ===== | ===== Examinations from Previous Years ===== |