This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
teaching:infoh419_-_week_1_lecture [2012/09/20 11:05] tcalders created |
teaching:infoh419_-_week_1_lecture [2013/01/22 17:50] (current) tcalders [Slides] |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ===== Small Summary ===== | ===== Small Summary ===== | ||
| Introduction to the course. | Introduction to the course. | ||
| + | * Requirements OLTP vs OLAP | ||
| + | * Why a RDBMS is not suitable for Analytical Queries | ||
| + | * Important conceptual notions | ||
| + | * Data cube | ||
| + | * Dimensions | ||
| + | * Hierarchy | ||
| + | * Querying data cubes | ||
| + | * SQL99 extensions | ||
| + | * MDX | ||
| + | * Data Explosion Problem | ||
| Line 11: | Line 20: | ||
| ===== Slides ===== | ===== Slides ===== | ||
| * [[https://dl.dropbox.com/u/5119252/DW/introduction.pdf|Slides Theory]] | * [[https://dl.dropbox.com/u/5119252/DW/introduction.pdf|Slides Theory]] | ||
| + | * [[https://dl.dropbox.com/u/5119252/DW/explosion.pdf|Extra notes about the data explosion problem]] | ||