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

  title={Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals},
  author={J. Gray and S. Chaudhuri and A. Bosworth and Andrew Layman and D. Reichart and Murali Venkatrao and Frank Pellow and H. Pirahesh},
  journal={Data Mining and Knowledge Discovery},
  • J. Gray, S. Chaudhuri, +5 authors H. Pirahesh
  • Published 2004
  • Mathematics, Computer Science
  • Data Mining and Knowledge Discovery
  • Data analysis applications typically aggregate data across manydimensions looking for anomalies or unusual patterns. The SQL aggregatefunctions and the GROUP BY operator produce zero-dimensional orone-dimensional aggregates. Applications need the N-dimensionalgeneralization of these operators. This paper defines that operator, calledthe data cube or simply cube. The cube operator generalizes the histogram,cross-tabulation, roll-up,drill-down, and sub-total constructs found in most report… CONTINUE READING
    2,123 Citations
    Different Cube Computation Approaches : Survey Paper
    • 4
    • PDF
    Rolling Up Random Variables in Data Cubes
    • PDF
    Optimization of Percentage Cube Queries
    • 1
    • PDF
    Novel Materialized View Selection in a Multidimensional Database
    Efficient incremental maintenance of data cubes
    • 29
    • PDF
    Horizontal Aggregations in SQL to Prepare Data Sets for Data Mining Analysis
    • 43
    • PDF


    On the Computation of Multidimensional Aggregates
    • 633
    • PDF
    Implementing data cubes efficiently
    • 1,476
    • PDF
    Using the New DB2: IBM's Object-Relational Database System
    • 88
    Query evaluation techniques for large databases
    • 1,389
    • PDF
    Understanding the New SQL: A Complete Guide
    • 402
    • PDF
    An Introduction to Database Systems
    • 485
    Introduction to Database Systems
    • 1,499
    • PDF