This shows you the differences between two versions of the page.
Last revision Both sides next revision | |||
teaching:infoh419_-_week_1_lecture [2012/09/20 11:05] tcalders created |
teaching:infoh419_-_week_1_lecture [2012/09/20 11:08] tcalders [Small Summary] |
||
---|---|---|---|
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 | ||