Skip to main content

CS410: Advanced Databases

Unit 6: Data Warehousing
Traditionally, database management systems have been used for transaction processing. Recently, however, the field has seen a trend of creating separate data stores for the purposes of reporting and tracking historical data. In this unit, you will learn about data warehouses and how they are implemented.

Completing this unit should take you approximately 12 hours.
- Unit 6 Learning Outcomes Page
- 6.1: Data Warehouse Introduction
  - University of Zurich: Michael Böhlen's "Data Warehousing" URL
    Read these slides for an introduction to data warehousing and data mining.
- 6.2: SQL OLAP Extensions
  - University of Zurich: Michael Böhlen's "SQL OLAP extensions" URL
    Read these slides for an introduction to SQL usage and OLAP extension operations.
- 6.3: An Algebraic OLAP Operator
  - University of Zurich: Michael Böhlen's "Generalized Multi-Dimensional Join" URL
    Read these slides for an introduction to concepts involved in the generalized multi-dimensional join. While you read, focus on the components used for creating the Algebraic OLAP Operator and how it can affect performance.