INFOH419 Data Warehousing - Week 1

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 Theory
• Extra notes about the data explosion problem