This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
teaching:dw2013-w6 [2013/10/23 09:17] tcalders [Slides] |
teaching:dw2013-w6 [2013/10/23 12:48] tcalders [Exercises] |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW05b-viewmaterialization.pdf|Slides materialization]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW05b-viewmaterialization.pdf|Slides materialization]] | ||
| ===== Reading material ===== | ===== Reading material ===== | ||
| - | * ... | + | * Different types of dimensions and dealing with change |
| + | * Sections 3.1 and 3.2 of the book "Multidimensional Databases and | ||
| + | DataWarehousing" by Jensen et al. | ||
| + | * View materialization | ||
| + | * Paper [[https://dl.dropbox.com/u/5119252/DW/papers/p205-harinarayan.pdf|"Implementing Data Cubes Efficiently"]]. This paper covers the greedy algorithm for view materialization. | ||
| + | * Section 4.1 of the book by Jensen et al. | ||
| ===== Exercises ===== | ===== Exercises ===== | ||
| We will be using MS SSAS again. For the problem with the server connection a workaround was found; instead of server name CS-MSSQL use directly the IP-address of the server, that is: 164.15.81.95. | We will be using MS SSAS again. For the problem with the server connection a workaround was found; instead of server name CS-MSSQL use directly the IP-address of the server, that is: 164.15.81.95. | ||
| - | * Exercises | + | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/SCD-materialization.pdf|Exercises]] |