INFOH419 Data Warehousing - Week 3

Introduction to the course.

• Important conceptual notions
  • Data cube
  • Dimensions
  • Hierarchy
• Querying data cubes
  • SQL99 extensions
• Data Explosion Problem

• Solution ER-modeling exercise W1
• Slides lecture
• A note on the database explosion problem

• Exercises - Solutions

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.

• Description of the database

• Note on installing this database on your own system