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/14 17:38] ezimanyi [INFO-H-419: Data Warehouses 2016-2017] |
teaching:infoh419 [2018/08/30 15:16] ezimanyi [Books and other lecture material] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== INFO-H-419: Data Warehouses ====== | ||
- | [[teaching/infoh419-2013|Edition 2013]] ([[https://dl.dropboxusercontent.com/u/5119252/DW/2013/solution-exam-DW-january-2014.pdf|Exam January 2014 + Solution]]) | ||
- | \\ [[DW Edition 2012|Edition 2012]] ([[https://dl.dropbox.com/u/5119252/DW/solution-exam-DW-january-2013.pdf|Exam January 2013 + Solution]]) | ||
- | <note important>From 2014 on we will be using the Moodle site for managing the course. Please go to http://uv.ulb.ac.be and search for the course INFO-H419-0-201415</note> | + | ====== INFO-H-419: Data Warehouses ====== |
===== Lecturer ===== | ===== Lecturer ===== | ||
Line 20: | Line 17: | ||
* Master in Computer Science and Engineering [MA-IRIF] | * Master in Computer Science and Engineering [MA-IRIF] | ||
* Master in Computer Sciences [INFO] | * Master in Computer Sciences [INFO] | ||
- | * Erasmus Mundus Master in Information Technologies for Business Intelligence (IT4BI) | + | * Erasmus Mundus Master in Big Data Management and Analytics (BDMA) |
===== Grading ===== | ===== Grading ===== | ||
Line 37: | Line 34: | ||
===== Books and other lecture material ===== | ===== Books and other lecture material ===== | ||
+ | * [[https://www.springer.com/9783642546549|Data Warehouse Systems: Design and Implementation]] by Aljeandro 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 Golfarelli and 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 |
==== Extra books ==== | ==== Extra books ==== | ||
Line 45: | Line 43: | ||
* White and Research Papers | * White and Research Papers | ||
* 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]] | * 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]] | ||
- | * Slides (via detailed schedule) | + | * [[https://www.springer.com/9783540744047|Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications]], Elzbieta Malinowski, Esteban Zimányi, Springer, 2008 |
- | * Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications, Elzbieta Malinowski, Esteban Zimányi, Springer, 2008 | + | |
* The Data Warehouse Toolkit, 2nd Ed., Kimball and Ross, Wiley, 2002 | * The Data Warehouse Toolkit, 2nd Ed., Kimball and Ross, Wiley, 2002 | ||
* Building the Data Warehouse. 4th edition. Inmon, Wiley, 2005 | * Building the Data Warehouse. 4th edition. Inmon, Wiley, 2005 | ||
* Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010 | * Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010 | ||
+ | |||
+ | === Extra Resources === | ||
+ | [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' | ||
==== Prerequisites ==== | ==== Prerequisites ==== | ||
Line 56: | Line 56: | ||
* 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\\ | * For the exercises we use the SQLServer tools: MS SQLServer, SS Intergration Services, SS Analysis services, and SS Reporting Services\\ | ||
- | === Extra Resources === | + | |
- | [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' | + | |