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/01 10:41] ezimanyi [Grading] |
teaching:infoh419 [2018/09/17 18:32] ezimanyi [Group assignment] |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| * [[http://cs.ulb.ac.be/members/esteban/|Esteban Zimányi]] | * [[http://cs.ulb.ac.be/members/esteban/|Esteban Zimányi]] | ||
| * <ezimanyi@ulb.ac.be> | * <ezimanyi@ulb.ac.be> | ||
| - | * Tuesday 2 pm - 4 pm | ||
| - | * Friday 4 pm - 6 pm | ||
| - | |||
| ===== Volume ===== | ===== Volume ===== | ||
| Line 66: | Line 63: | ||
| * {{teaching:infoh419:dw01-introduction.pdf|Introduction}} | * {{teaching:infoh419:dw01-introduction.pdf|Introduction}} | ||
| * {{teaching:infoh419:dw02-cubes.pdf|Cubes}} | * {{teaching:infoh419:dw02-cubes.pdf|Cubes}} | ||
| + | * {{teaching:infoh419:database_explosion_report.pdf|Database explosion report}} | ||
| + | * {{teaching:infoh419:database_explosion.pdf|Database explosion}} | ||
| * {{teaching:infoh419:dw03-dfm.pdf|Dimension Fact Model}} | * {{teaching:infoh419:dw03-dfm.pdf|Dimension Fact Model}} | ||
| * {{teaching:infoh419:dw04-logicalmodel.pdf|Logical Model}} | * {{teaching:infoh419:dw04-logicalmodel.pdf|Logical Model}} | ||
| Line 92: | Line 91: | ||
| ===== Group assignment ===== | ===== Group assignment ===== | ||
| - | The assignment 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. The link to register a group is included below. Please to select your group before or on 25/10/2018. | + | The assignment 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 assignment consist of 2 parts: | The assignment consist of 2 parts: | ||
| - | * Part I: Create a conceptual model and translate to a logical schema (deadline 15/11/2018) | + | * Part I: Implement the TPC-DS benchmark (deadline 1/11/2018) |
| - | * Part II: (deadline 20/12/2018) | + | * Part II: Implement the TPC-DI benchmark (deadline 20/12/2018) |
| - | * Creating ETL scripts for updating the database in SSIS, | + | |
| - | * Predicting how the size of the data warehouse will grow over time, | + | |
| - | * Deploy a data cube on top of the data warehouse and create a report. | + | |
| - | Assignment part I will be available on 25/10. For the next parts, assignment II will become available right after the submission deadline of assignment part I. The submission deadlines for parts I and II are strict. | + | The submission deadlines for parts I and II are strict. |
| The assignment evaluation will count for 30% of your total grade. This may seem undervalued, however, putting effort in the assignment 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 assignment evaluation will count for 30% of your total grade. This may seem undervalued, however, putting effort in the assignment 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. | ||