Lecture 16. Data warehousing
Readings:
- Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals.
J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, and M. Venkatrao.
Data Mining and Knowledge Discovery 1, 29-53 (1997). Also in Red Book (3rd and 4th ed).
[pdf]
As you read this paper consider the following questions:
- What are the requirements of data analysis applications that make it difficult to support them in a traditional DBMS?
- What is the data cube operator?
Lecture notes:
lecture16.pdf
Additional resources:
- Chapter 25 (in R&G, third edition).