Lecture 15. Data warehousing: cubes

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 main contributions and limitations of this paper?
• 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:

lecture15.pdf

Additional resources:

• Chapter 25 (in R&G, third edition).