Table of Contents

Small Summary
Slides
Reading material
Exercises

INFOH419 Data Warehousing - Week 8

Small Summary

Indexing
- Projection index,
- Join index,
- Bitmap-join index
- Indexing dimension and fact tables
- Partitioning
Data warehouse architectures
Extract-Transform/cleanse-Load

Slides

Reading material

Indexing:
- Jensen et al. 4.2 - 4.4
- Golfarelli et al. Chapter 11.
ETL: Sec. 1.3, 1.4; Ch. 10 of Golfarelli and Rizzi book

Exercises

Solution and Explanation

Exercises
Additional material:
- Link to documentation of SQL Server Integration Services
- If you want to do the exercises locally: Northwind database