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 19:03] ezimanyi [Group Project] |
teaching:infoh419 [2019/10/04 13:25] ezimanyi [Groups of the current year] |
||
|---|---|---|---|
| Line 21: | Line 21: | ||
| The course is given during the first semester | The course is given during the first semester | ||
| * Lectures on Tuesdays from 2 pm to 4 pm at the room S.UA4.218 | * Lectures on Tuesdays from 2 pm to 4 pm at the room S.UA4.218 | ||
| - | * Exercises on Fridays from 4 pm to 6 pm at the room S.UB4.130 | + | * Exercises on Fridays from 2 pm to 4 pm at the room S.UB4.130 |
| ===== Grading ===== | ===== Grading ===== | ||
| 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 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 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 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. | ||
| Line 109: | 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. | ||
| + | |||
| + | ===== Groups of the current year ===== | ||
| + | |||
| + | * SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server: Hung Nguyen, Valdemar Hernández Siles, Julio Candela Caceres, Ariston Harianto Lim | ||
| + | * Pentaho Analysis Services, Pentaho Data Integration: Dimitrios Tsesmelis, Andrea Armani, Hridaya Subedi, Uchechukwu Fortune Njoku | ||
| + | * Apache Kylin, Talend Open Studio, SQL Server: Ricardo Holthausen, Alp Albay, Jesus Huete | ||
| + | * MySQL, <ETL tool TBD>: Ali Arous, Fabrício Ferreira, Ishaan Rachit Dwivedi, Ledia Isaj | ||
| + | * Big Query, Cloud Data Fusion: Nithish Sankaranarayanan, Gayane Vardanyan, Yu-Hsuan Chen, Anant Gupta | ||
| + | |||
| ===== Examinations from Previous Years ===== | ===== Examinations from Previous Years ===== | ||