INFOH419 Data Warehousing - Week 1

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 introduction
• Slides refresher
• Extra notes about the data explosion problem

Exercises are related to the refresher of ER-modeling

• Relations - Solution
• Doctors - Relational schema
• repairs
• Modeling exercises