This is an old revision of the document!
Table of Contents
INFOH419 Data Warehousing - Week 3
Small Summary
Introduction to the course.
- Important conceptual notions
- Data cube
- Dimensions
- Hierarchy
- Querying data cubes
- SQL99 extensions
- Data Explosion Problem
Slides
Exercises
For the exercises, please consider using SQL-Server to try out the queries and study sparsity.
For those who wish to explore cube browsing, connect to SSAS (Analysis services); use for instance the “AdventureWorks” database. This database is available on the server.
