Table of Contents

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


Recap of important database notions:

  • ER Modelling
  • Translation to the relational model
  • Dependencies: Functional and foreign key dependencies

Slides

Exercises

Exercises are related to the refresher of ER-modeling

 
teaching/dw2013-w1.txt · Last modified: 2013/10/03 00:02 by tcalders