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:30] ezimanyi [Books] |
teaching:infoh419 [2018/09/01 10:34] ezimanyi [Examinations from Previous Years] |
||
---|---|---|---|
Line 34: | Line 34: | ||
===== Books ===== | ===== Books ===== | ||
- | * [[https://www.springer.com/9783642546549|Data Warehouse Systems: Design and Implementation]] by Aljeandro A. Vaisman and Esteban Zimányi. Springer, 2014. | + | * [[https://www.springer.com/9783642546549|Data Warehouse Systems: Design and Implementation]] by Alejandro A. Vaisman and Esteban Zimányi. Springer, 2014. |
* [[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 48: | Line 48: | ||
===== Prerequisites ===== | ===== Prerequisites ===== | ||
- | * [[https://www.mheducation.com/highered/product/database-system-concepts-silberschatz-korth/M0073523321.html|Database System Concepts]] (Sixth Edition) by Abraham Silberschatz, Henri Korth, and S. Sudarshan. McGraw-Hill (2011) | + | * [[https://www.mheducation.com/highered/product/database-system-concepts-silberschatz-korth/M0073523321.html|Database System Concepts]] (6th ed.) by Abraham Silberschatz, Henri Korth, and S. Sudarshan. McGraw-Hill, 2011. |
* ER-modeling: Chapter 7 | * ER-modeling: Chapter 7 | ||
* Keys and functional dependencies: Section 8.3.1 | * Keys and functional dependencies: Section 8.3.1 | ||
Line 77: | Line 77: | ||
* [[teaching:infoh419:TP|Exercices Web page]] | * [[teaching:infoh419:TP|Exercices Web page]] | ||
+ | |||
+ | ===== 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 consist of 2 parts: | ||
+ | |||
+ | * Part I: Create a conceptual model and translate to a logical schema (deadline 15/11/2018) | ||
+ | * Part II: (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 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. | ||
===== Examinations from Previous Years ===== | ===== Examinations from Previous Years ===== |