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 15:18] ezimanyi [Books and other lecture material] |
teaching:infoh419 [2018/09/01 10:16] ezimanyi [Examinations from Previous Years] |
||
---|---|---|---|
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: | ||
- | * Kimball, Ralph; Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker (2008). The Data Warehouse Lifecycle Toolkit (2nd ed.). Wiley. | + | * [[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 | * 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]] | ||
Line 49: | Line 49: | ||
==== Extra Resources ==== | ==== Extra Resources ==== | ||
- | [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' | + | * [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' |
===== Prerequisites ===== | ===== Prerequisites ===== | ||
- | * Database System Concepts (Sixth Edition) by Silberschatz, Korth, and Sudarshan. McGraw-Hill (2011) [A copy of the book is available - ask the lecturer] | + | * [[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) |
* 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 76: | Line 76: | ||
===== 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 |
+ | |||
+ | ===== Exercises ===== | ||
+ | |||
+ | * [[teaching:infoh419:TP|Exercices Web page]] | ||
+ | |||
+ | ===== Examinations from Previous Years ===== | ||
+ | |||
+ | * Academic year 2017-2018 | ||
+ | * {{:teaching:infoh419:dw-exam-2017-january-solution.pdf|First session}} | ||
+ | * Academic year 2016-2017 | ||
+ | * {{:teaching:infoh419:dw-exam-2016-january.pdf|First session}} | ||
+ | * Academic year 2015-2016 | ||
+ | * {{:teaching:infoh419:dw-exam-2015-january.pdf|First session}} | ||
+ | * Academic year 2014-2015 | ||
+ | * {{:teaching:infoh419:dw-exam-2014-january-solution.pdf|First session}} | ||
+ | * {{:teaching:infoh419:dw-exam-2014-july.pdf|Second session}} | ||
+ | * Academic year 2013-2014 | ||
+ | * {{:teaching:infoh419:dw-exam-2013-january-solution.pdf|First session}} | ||
+ | * {{:teaching:infoh419:dw-exam-2013-july.pdf|Second session}} | ||