INFOH419 Data Warehousing - Week 6

Small Summary

  • 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

Reading material

  • 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.

Exercises

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.

 
teaching/dw2013-w6.txt · Last modified: 2013/10/23 12:48 by tcalders