INFOH419 Data Warehousing - Week 6

• Logical design
  • Dealing with changing dimensions
    • Slowly Changing Dimensions
      • Type I, II, and II
    • Rapidly changing dimensions
      • Mini dimension
  • Specific dimension types
    • Junk dimension
    • Outriggers
    • Degenerate dimension
• Physical level
  • View materialization

• Slides SCD
• Slides materialization

• Different types of dimensions and dealing with change
  • Sections 3.1 and 3.2 of the book “Multidimensional Databases and

DataWarehousing” by Jensen et al.

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

We will be using MS SSAS again. For the problem with the server connection a workaround was found; instead of server name CS-MSSQL use directly the IP-address of the server, that is: 164.15.81.95.

• Exercises