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:08] ezimanyi [Course Slides] |
teaching:infoh419 [2018/09/01 09:41] ezimanyi [Software] |
||
|---|---|---|---|
| Line 20: | Line 20: | ||
| ===== Grading ===== | ===== Grading ===== | ||
| - | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/description.pdf|Group project]] (30%) | + | * Group project (30%) |
| * Written exam (70%) | * Written exam (70%) | ||
| * the exam is open book; notes and books can be used. Laptops and other electronic devices are not allowed. | * the exam is open book; notes and books can be used. Laptops and other electronic devices are not allowed. | ||
| Line 33: | 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. | 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. | * [[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. | ||
| 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 48: | Line 48: | ||
| * Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010 | * Data Warehousing Fundamentals For IT Professionals. 2nd edition. Paulraj Ponniah, Wiley, 2010 | ||
| - | ==== Prerequisites ==== | + | ==== Extra Resources ==== |
| - | * Database System Concepts (Sixth Edition) by Silberschatz, Korth, and Sudarshan. McGraw-Hill (2011) [A copy of the book is available - ask the lecturer] | + | * [[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) | ||
| * ER-modeling: Chapter 7 | * ER-modeling: Chapter 7 | ||
| * 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 ===== | ===== Course Slides ===== | ||
| Line 66: | Line 70: | ||
| * {{teaching:infoh419:dw08-indexing.pdf|Indexing}} | * {{teaching:infoh419:dw08-indexing.pdf|Indexing}} | ||
| * {{teaching:infoh419:dw09-aggregatecomputation.pdf|Aggregate Computation}} | * {{teaching:infoh419:dw09-aggregatecomputation.pdf|Aggregate Computation}} | ||
| + | * {{teaching:infoh419:dw10-conclusion.pdf|Conclusion}} | ||
| Line 71: | 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]] | ||
| - | === Extra Resources === | ||
| - | [[http://www.teradatauniversitynetwork.com/|Teradata University Network]] For the 2013-2014 academic year, the student password is 'UnifiedDataArchitecture' | ||