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.txt · Last modified: 2013/01/22 17:50 by tcalders