INFOH419 Data Warehousing - Week 5

• Increasing query performance
  • Materialize the cube (continued)
  • Indexing techniques for data warehouses
    • Bitmap Index
    • Join Index
    • Bitmap Join Index

Both theory and exercises are in the normal room

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

Exercise session is in the normal lecture room. The exercises are pen-and-paper.

• Exercises