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
  • Chapter 3 of the book by Jensen et al.
• View materialization
  • 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.

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