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/08/30 14:55] ezimanyi [Books and other lecture material] |
teaching:infoh419 [2018/09/01 10:42] ezimanyi [Lecturer] |
||
---|---|---|---|
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 ===== | ||
- | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/description.pdf|Group project]] (30%) | + | * Group project (30%) |
* Written exam (70%) | * Written exam (70%) | ||
* the exam is open book; notes and books can be used. Laptops and other electronic devices are not allowed. | * the exam is open book; notes and books can be used. Laptops and other electronic devices are not allowed. | ||
Line 33: | Line 37: | ||
In the course, the main concepts of multidimensional databases will be covered and illustrated using the SQL Server tools. Complimentary to the course, IBM and Teradata will give invited lectures. | In the course, the main concepts of multidimensional databases will be covered and illustrated using the SQL Server tools. Complimentary to the course, IBM and Teradata will give invited lectures. | ||
- | ===== Books and other lecture material ===== | + | ===== 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 40: | Line 44: | ||
==== Extra books ==== | ==== Extra books ==== | ||
The following materials have been used to construct the course material, but are not required reading for the course: | The following materials have been used to construct the course material, but are not required reading for the course: | ||
- | * Kimball, Ralph; Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker (2008). The Data Warehouse Lifecycle Toolkit (2nd ed.). Wiley. | + | * [[https://www.springer.com/9783540744047|Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications]], Elzbieta Malinowski, Esteban Zimányi, Springer, 2008 |
- | * White and Research Papers | + | * [[https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-lifecycle-toolkit/|The Data Warehouse Lifecycle Toolkit]] (2nd ed.) by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker. Wiley, 2008. |
- | * Two survey papers: [[https://dl.dropbox.com/u/5119252/DW/papers/chaudhuri.pdf|paper 1]], [[https://dl.dropbox.com/u/5119252/DW/papers/olap.pdf|paper 2]] | + | * [[https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-toolkit/|The Data Warehouse Toolkit]] (3rd ed.) by Ralph Kimball and Margy Ross. Wiley, 2013. |
- | * Slides (via detailed schedule) | + | * [[https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-etl-toolkit/|The Data Warehouse ETL Toolkit]] by Ralph Kimball and Joe Caserta. Wiley, 2004. |
- | * Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications, Elzbieta Malinowski, Esteban Zimányi, Springer, 2008 | + | * [[https://www.wiley.com/en-be/Building+the+Data+Warehouse%2C+4th+Edition-p-9780471774235|Building the Data Warehouse]] (4th ed.) by William H. Inmon, Wiley, 2005 |
- | * The Data Warehouse Toolkit, 2nd Ed., Kimball and Ross, Wiley, 2002 | + | |
- | * Building the Data Warehouse. 4th edition. Inmon, Wiley, 2005 | + | |
- | * Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010 | + | |
- | ==== Prerequisites ==== | + | |
- | * Database System Concepts (Sixth Edition) by Silberschatz, Korth, and Sudarshan. McGraw-Hill (2011) [A copy of the book is available - ask the lecturer] | + | ===== Prerequisites ===== |
+ | * [[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 | ||
* BCNF: 8.3.2 | * BCNF: 8.3.2 | ||
+ | |||
+ | |||
+ | ===== Course Slides ===== | ||
+ | |||
+ | * {{teaching:infoh419:dw00-refresher.pdf|Refresher Databases}} | ||
+ | * {{teaching:infoh419:dw01-introduction.pdf|Introduction}} | ||
+ | * {{teaching:infoh419:dw02-cubes.pdf|Cubes}} | ||
+ | * {{teaching:infoh419:dw03-dfm.pdf|Dimension Fact Model}} | ||
+ | * {{teaching:infoh419:dw04-logicalmodel.pdf|Logical Model}} | ||
+ | * {{teaching:infoh419:dw05-dimensionchanges.pdf|Dimension Changes}} | ||
+ | * {{teaching:infoh419:dw06-etl.pdf|ETL}} | ||
+ | * {{teaching:infoh419:dw07-viewmaterialization.pdf|View Materialization}} | ||
+ | * {{teaching:infoh419:dw08-indexing.pdf|Indexing}} | ||
+ | * {{teaching:infoh419:dw09-aggregatecomputation.pdf|Aggregate Computation}} | ||
+ | * {{teaching:infoh419:dw10-conclusion.pdf|Conclusion}} | ||
+ | |||
+ | |||
+ | |||
+ | |||
===== Software ===== | ===== Software ===== | ||
- | * For the exercises we use the SQLServer tools: MS SQLServer, SS Intergration Services, SS Analysis services, and SS Reporting Services\\ | ||
- | === Extra Resources === | + | 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> |
- | [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' | + | |
+ | * 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 ===== | ||
+ | |||
+ | * [[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 ===== | ||
+ | |||
+ | * Academic year 2016-2017 | ||
+ | * {{:teaching:infoh419:dw-exam-2017-january-solution.pdf|First session}} | ||
+ | * Academic year 2015-2016 | ||
+ | * {{:teaching:infoh419:dw-exam-2016-january.pdf|First session}} | ||
+ | * Academic year 2014-2015 | ||
+ | * {{:teaching:infoh419:dw-exam-2015-january.pdf|First session}} | ||
+ | * Academic year 2013-2014 | ||
+ | * {{:teaching:infoh419:dw-exam-2014-january-solution.pdf|First session}} | ||
+ | * {{:teaching:infoh419:dw-exam-2014-july.pdf|Second session}} | ||
+ | * Academic year 2012-2013 | ||
+ | * {{:teaching:infoh419:dw-exam-2013-january-solution.pdf|First session}} | ||
+ | * {{:teaching:infoh419:dw-exam-2013-july.pdf|Second session}} | ||
+ | |||