Back to index

Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals.

Jim Gray, Adam Bosworth, Andrew Layman, and Hamid Pirahesh.

Summary by: Steve Gribble and Armando Fox

One-line summary: Aggregates and group-by operators produce 0- or 1-dimensional answers; cross-tabs produce 2-d answers; the data-cube produces N-dimensional aggregates and answers by treating each of the N aggregation attributes as a dimension of N-space.


Cool new operator - proven to be very, very useful while playing with data, and has become widely adopted. Good to read about.


Overview/Main Points

Back to index