This is an old revision of the document!


INFOH419 Data Warehousing - Week 1

Small Summary

Introduction to the course.

  • Requirements OLTP vs OLAP
  • Why a RDBMS is not suitable for Analytical Queries
  • Important conceptual notions
    • Data cube
    • Dimensions
    • Hierarchy
  • Querying data cubes
    • SQL99 extensions
    • MDX
  • Data Explosion Problem

There will be no exercises this week.

Slides

 
teaching/infoh419_-_week_1_lecture.1348132089.txt.gz · Last modified: 2012/09/20 11:08 by tcalders