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:16] ezimanyi [Examinations from Previous Years] |
teaching:infoh419 [2018/09/01 10:31] ezimanyi [Prerequisites] |
||
|---|---|---|---|
| Line 40: | Line 40: | ||
| ==== 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: | ||
| - | * [[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 | * [[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 ===== | ===== 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 | * ER-modeling: Chapter 7 | ||
| * Keys and functional dependencies: Section 8.3.1 | * Keys and functional dependencies: Section 8.3.1 | ||
| Line 84: | Line 80: | ||
| ===== Examinations from Previous Years ===== | ===== Examinations from Previous Years ===== | ||
| - | * Academic year 2017-2018 | ||
| - | * {{:teaching:infoh419:dw-exam-2017-january-solution.pdf|First session}} | ||
| * Academic year 2016-2017 | * Academic year 2016-2017 | ||
| - | * {{:teaching:infoh419:dw-exam-2016-january.pdf|First session}} | + | * {{:teaching:infoh419:dw-exam-2017-january-solution.pdf|First session}} |
| * Academic year 2015-2016 | * Academic year 2015-2016 | ||
| - | * {{:teaching:infoh419:dw-exam-2015-january.pdf|First session}} | + | * {{:teaching:infoh419:dw-exam-2016-january.pdf|First session}} |
| * Academic year 2014-2015 | * 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-january-solution.pdf|First session}} | ||
| * {{:teaching:infoh419:dw-exam-2014-july.pdf|Second session}} | * {{:teaching:infoh419:dw-exam-2014-july.pdf|Second session}} | ||
| - | * Academic year 2013-2014 | + | * Academic year 2012-2013 |
| * {{:teaching:infoh419:dw-exam-2013-january-solution.pdf|First session}} | * {{:teaching:infoh419:dw-exam-2013-january-solution.pdf|First session}} | ||
| * {{:teaching:infoh419:dw-exam-2013-july.pdf|Second session}} | * {{:teaching:infoh419:dw-exam-2013-july.pdf|Second session}} | ||