You are here: Service CoDE » Enseignement » INFOH419 Data Warehousing - Week 8

Table of Contents

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

 
teaching/dw2013-w8.txt · Last modified: 2013/11/18 16:10 by tcalders