INFOH419 Data Warehousing - Week 1

Small Summary

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

There will be no exercises this week.

Slides