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:31] ezimanyi [Prerequisites] |
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> | ||
| - | * Room SU A 4.115 | ||
| - | |||
| ===== Volume ===== | ===== Volume ===== | ||
| Line 18: | Line 16: | ||
| * Master in Computer Sciences [INFO] | * Master in Computer Sciences [INFO] | ||
| * Erasmus Mundus Master in Big Data Management and Analytics (BDMA) | * Erasmus Mundus Master in Big Data Management and Analytics (BDMA) | ||
| + | |||
| + | ===== Schedule ===== | ||
| + | |||
| + | The course is given during the first semester | ||
| + | * 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 | ||
| ===== Grading ===== | ===== Grading ===== | ||
| Line 34: | Line 38: | ||
| ===== 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 59: | 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 72: | Line 78: | ||
| ===== Software ===== | ===== Software ===== | ||
| - | * For the exercises we use the SQLServer tools: MS SQLServer, SS Intergration Services, SS Analysis services, and SS Reporting Services | + | |
| + | All software used in the course is available in the computer labs. Students who wish a personal copy of the software on their own computers, can get free copies of the software. Succinct instructions to acquire the software have been included below; in case additional help is required you can contact the sysadmin of the department: Arthur Lesuisse <alesuiss@ulb.ac.be> | ||
| + | |||
| + | * MS SQL Server Tools: can be downloaded for free from http://www.academicshop.be/msdnaa/ Register on this page with your ULB email address, and 'order' the free msdnaa. After verification you receive login credentials to download quite a few software packages for free. Select the SQL Server 2014 Enterprise edition. | ||
| + | * Indyco Builder can be downloaded from http://www.indyco.com/ . License keys for all students will be added soon. | ||
| ===== Exercises ===== | ===== Exercises ===== | ||
| * [[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. 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: | ||
| + | |||
| + | * Part I: Implement the TPC-DS benchmark (deadline 1/11/2018) | ||
| + | * Part II: Implement the TPC-DI benchmark (deadline 20/12/2018) | ||
| + | |||
| + | 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 ===== | ||