Differences

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

--- teaching:infoh419 [2018/09/01 10:17]
ezimanyi [Examinations from Previous Years]
+++ teaching:infoh419 [2018/09/17 18:39]
ezimanyi [Group Project]
@@ Line 6: / Line 6: @@
   * [[http://cs.ulb.ac.be/members/esteban/|Esteban Zimányi]]
   * <ezimanyi@ulb.ac.be>
-  * Room SU A 4.115
 ===== Volume =====
@@ Line 18: / Line 16: @@
   * Master in Computer Sciences [INFO]
   * 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 =====
@@ Line 34: / Line 38: @@
 ===== 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.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 ====
 The following materials have been used to construct the course material, but are not required reading for the course:
-  * [[https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-toolkit/|The Data Warehouse Lifecycle Toolkit]] (3rd ed.) by Ralph Kimball and Margy Ross. Wiley, 2013.
-  * 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]]
   * [[https://www.springer.com/9783540744047|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
+  * [[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.
-  * Building the Data Warehouse. 4th edition. Inmon, Wiley, 2005
+  * [[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.
-  * Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010
+  * [[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.
+  * [[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
-==== Extra Resources ====
-  * [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture'
 ===== 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
     * Keys and functional dependencies: Section 8.3.1
@@ Line 63: / Line 63: @@
   * {{teaching:infoh419:dw01-introduction.pdf|Introduction}}
   * {{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:dw04-logicalmodel.pdf|Logical Model}}
@@ Line 76: / Line 78: @@
 ===== 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 =====
   * [[teaching:infoh419:TP|Exercices Web page]]
+===== Group Project =====
+[[http://www.tpc.org|TPC]] is a non-profit corporation that defines transaction processing and database benchmarks and disseminates objective, verifiable TPC performance data to the industry. Regarding data warehouses, two TPC benchmarks are relevant:
+  * [[http://www.tpc.org/tpcds/|TPC-DS]], the Decision Support Benchmark, which models the decision support functions of a retail product supplier.
+  * [[http://www.tpc.org/tpcdi/|TPC-DI]], the Data Integration Support Benchmark, which models a typical ETL process that loads a data warehouse.
+The project of the course 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)
+You will have free choice to use the tools on which the two benchmarks will be built. For example, the TPC-DS benchmark can be implemented on SQL Server Analysis Services, Pentaho Analysis Services (aka Mondrian), etc. Similarly, the TPC-DI could be implemented on SQL Server Integration Services, Pentaho Data Integration, Talend Data Studio, or even SQL scripts.
+The project 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 submission deadlines for parts I and II are strict.
+The project evaluation will count for 30% of your total grade. This may seem undervalued, however, putting effort in the project 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 =====