INFOH419 Data Warehousing - Week 4

• Storing the cube
  • ROLAP: star and snowflake schemas
  • MOLAP
• Increasing query performance
  • Materialize the cube
  • Indexing techniques for dataware housing

The theory session is in the normal room

• Slides
• Paper "Implementing Data Cubes Efficiently". This paper covers the greedy algorithm for view materialization.
• Section 2.5 and 4.1 of the book by Jensen et al.

The exercise session will be in the computer room. We will be using the AdventureWorksDW database again. If you want to install this database on your personal computer, please find instructions here.

• Exercises