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 14:56] ezimanyi [Books and other lecture material] |
teaching:infoh419 [2018/08/30 15:06] ezimanyi [Course Slides] |
||
---|---|---|---|
Line 43: | Line 43: | ||
* 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]] | ||
- | * Slides (via detailed schedule) | ||
* [[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 | * The Data Warehouse Toolkit, 2nd Ed., Kimball and Ross, Wiley, 2002 | ||
Line 54: | Line 53: | ||
* 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 ===== | ||
+ | |||
+ | * {{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-indexing.pdf|Indexing}} | ||
+ | * {{teaching:infoh419:dw08-aggregatecomputation.pdf|Aggregate Computation}} | ||
+ | |||
+ | |||
+ | |||
+ | |||
===== 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\\ |