Differences

This shows you the differences between two versions of the page.

--- teaching:infoh419 [2018/08/14 17:38]
ezimanyi [Study Programme]
+++ teaching:infoh419 [2018/09/01 10:31]
ezimanyi [Prerequisites]
@@ 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 =====
@@ Line 23: / Line 20: @@
 ===== Grading =====
-  * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/description.pdf|Group project]] (30%)
+  * Group project (30%)
   * Written exam (70%)
     * the exam is open book; notes and books can be used. Laptops and other electronic devices are not allowed.
@@ Line 36: / Line 33: @@
 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.
   * [[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 ====
 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
     * Keys and functional dependencies: Section 8.3.1
     * 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 =====
-  * 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
+===== Exercises =====
+  * [[teaching:infoh419:TP|Exercices Web page]]
+===== 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}}
-=== Extra Resources ===
-[[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture'