This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
teaching:infoh419_-_week_4_lecture [2012/10/11 13:39] tcalders [Slides] |
teaching:infoh419_-_week_4_lecture [2012/10/18 10:12] tcalders [Small Summary] |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| * Increasing query performance | * Increasing query performance | ||
| * Materialize the cube | * Materialize the cube | ||
| - | * Indexing techniques for dataware housing | ||
| - | |||
| ===== Slides ===== | ===== Slides ===== | ||
| The theory session is in the normal room | The theory session is in the normal room | ||
| * [[https://dl.dropbox.com/u/5119252/DW/DW03-Storage.pdf|Slides]] | * [[https://dl.dropbox.com/u/5119252/DW/DW03-Storage.pdf|Slides]] | ||
| + | * 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 2.5 and 4.1 of the book by Jensen et al. | ||
| ===== Exercises ===== | ===== Exercises ===== | ||
| The exercise session will be in the computer room. We will be using the AdventureWorksDW database again. If you want to install this database on your personal computer, please find instructions [[https://dl.dropbox.com/u/5119252/DW/Install_AdventureWorksDW.pdf|here]]. | The exercise session will be in the computer room. We will be using the AdventureWorksDW database again. If you want to install this database on your personal computer, please find instructions [[https://dl.dropbox.com/u/5119252/DW/Install_AdventureWorksDW.pdf|here]]. | ||
| * [[https://dl.dropbox.com/u/5119252/DW/Exercises-CreateCube.pdf|Exercises]] | * [[https://dl.dropbox.com/u/5119252/DW/Exercises-CreateCube.pdf|Exercises]] | ||