Data cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-totals

Data Mining and Knowledge Discovery

Volumn 1, Issue 1, 1997, Pages 29-53

  Gray, Jim ^a   Chaudhuri, Surajit ^a   Bosworth, Adam ^a   Layman, Andrew ^a   Reichart, Don ^a,c   Venkatrao, Murali ^a,c   Pellow, Frank ^b,d   Pirahesh, Hamid ^b  

^a MICROSOFT RESEARCH   (United States)

^b IBM ALMADEN RESEARCH CENTER   (United States)

^c MICROSOFT   (United States)

^d IBM TORONTO LAB   (Canada)

Author keywords

Aggregation; Analysis; Data cube; Data mining; Database; Query; Summarization

Indexed keywords

EID: 21744433274     PISSN: 13845810     EISSN: None     Source Type: Journal    
DOI: 10.1023/A:1009726021843     Document Type: Article

References (19)

1. Agrawal, R., Deshpande, P., Gupta, A., Naughton, J.F., Ramakrishnan, R., and Sarawagi, S. 1996. On the Computation of Multidimensional Aggregates. Proc. 21st VLDB, Bombay.
2. Chamberlin, D. 1996. Using the New DB2-IBM's Object-Relational Database System. San Francisco, CA: Morgan Kaufmann.
3. DataBlade Developer's Kit: Users Guide 2.0. Informix Software, Menlo Park, CA, 1996.
4. Date, C.J. 1995. Introduction to Database Systems. 6th edition, N.Y.: Addison Wesley.
5. Date, C.J. 1996. Aggregate functions. Database Programming and Design, 9(4): 17-19.
6. Graefe, C.J. 1993. Query evaluation techniques for large databases. ACM Computing Surveys, 25.2, pp. 73-170.
7. Gray, J. (Ed.) 1991. The Benchmark Handbook. San Francisco, CA: Morgan Kaufmann.
8. Gray, J., Bosworth, A., Layman, A., and Pirahesh, H. 1996. Data cube: A relational operator generalizing group-by, cross-tab, and roll-up. Proc. International Conf. on Data Engineering. New Orleans: IEEE Press.
9. Harinarayn, V., Rajaraman, A., and Ullman, J.D. 1996. Implementing data cubes efficiently. Proc. ACM SIGMOD. Montreal, pp. 205-216.
10. 1992. IS 9075 International Standard for Database Language SQL, document ISO/IEC 9075:1992, J. Melton (Ed.).
11. 1996. ISO/IEC DBL:MCI-006 (ISO Working Draft) Database Language SQL-Part 4: Persistent Stored Modules (SQL/PSM), J. Melton (Ed.).
12. Melton, J. and Simon, A.R. 1993. Understanding the New SQL: A Complete Guide. San Francisco, CA: Morgan Kaufmann.
13. 1994. Method and Apparatus for Storing and Retrieving Multi-Dimensional Data in Computer Memory. Inventor: Earle; Robert J., Assignee: Arbor Software Corporation, US Patent 05359724.
14. 1994. Microsoft Access Relational Database Management System for Windows, Language Reference-Functions, Statements, Methods, Properties, and Actions, DB26142, Microsoft, Redmond, WA.
15. 1995. Microsoft Excel - User's Guide. Microsoft. Redmond, WA.
16. 1996. Microsoft SQL Server: Transact-SQL Reference, Document 63900. Microsoft Corp. Redmond, WA.
17. 1994. RISQL Reference Guide, Red Brick Warehouse VPT Version 3, Part no.: 401530, Red Brick Systems, Los Gatos. CA.
18. Shukla, A., Deshpande, P., Naughton, J.F., and Ramaswamy, K. 1996. Storage estimation for multidimensional aggregates in the presence of hierarchies. Proc. 21st VLDB, Bombay.
19. 1993. The Benchmark Handbook for Database and Transaction Processing Systems - 2nd edition, J. Gray (Ed.), San Francisco, CA: Morgan Kaufmann. Or http://www.tpc.org/