Maintenance of cube automatic summary tables

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

Maintenance of cube automatic summary tables

Full text

Pdf (26 KB)

Source

International Conference on Management of Data archive
Proceedings of the 2000 ACM SIGMOD international conference on Management of data table of contents

Dallas, Texas, United States

Pages: 512 - 513

Year of Publication: 2000

ISBN:1-58113-217-4

Also published in ...

Authors

Wolfgang Lehner	University of Erlangen-Nuremberg, Martensstr. 3, Erlangen, 91056, Germany
Richard Sidle	IBM Almaden Research Center, 650 Harry Road, San Jose, CA
Hamid Pirahesh	IBM Almaden Research Center, 650 Harry Road, San Jose, CA
Roberta Wolfgang Cochrane	IBM Almaden Research Center, 650 Harry Road, San Jose, CA

Sponsor

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 7, Downloads (12 Months): 63, Citation Count: 6

Additional Information:

abstract references cited by index terms collaborative colleagues peer to peer

Tools and Actions:	Review this Article Save this Article to a Binder Display Formats: BibTex EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/342009.335454 What is a DOI?

ABSTRACT

Materialized views (or Automatic Summary Tables—ASTs) are commonly used to improve the performance of aggregation queries by orders of magnitude. In contrast to regular tables, ASTs are synchronized by the database system. In this paper, we present techniques for maintaining cube ASTs. Our implementation is based on IBM DB2 UDB.

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	1	Venky Harinarayan , Anand Rajaraman , Jeffrey D. Ullman, Implementing data cubes efficiently, Proceedings of the 1996 ACM SIGMOD international conference on Management of data, p.205-216, June 04-06, 1996, Montreal, Quebec, Canada
	2	Inderpal Singh Mumick , Dallan Quass , Barinderpal Singh Mumick, Maintenance of data cubes and summary tables in a warehouse, Proceedings of the 1997 ACM SIGMOD international conference on Management of data, p.100-111, May 11-15, 1997, Tucson, Arizona, United States
	3	Beyer, K.; Cochrane, B. Lindsay, B.; Salem K.: How To Roll a Join. IBM research paper. In. SIGMOD'2000
	4	Markos Zaharioudakis , Roberta Cochrane , George Lapis , Hamid Pirahesh , Monica Urata, Answering complex SQL queries using automatic summary tables, Proceedings of the 2000 ACM SIGMOD international conference on Management of data, p.105-116, May 15-18, 2000, Dallas, Texas, United States

CITED BY 6

	Craig J. Bunker , Latha S. Colby , Richard L. Cole , William J. McKenna , Gopal Mulagund , David Wilhite, Aggregate Maintenance for Data Warehousing in Informix Red Brick Vista, Proceedings of the 27th International Conference on Very Large Data Bases, p.659-662, September 11-14, 2001
	Themistoklis Palpanas , Richard Sidle , Roberta Cochrane , Hamid Pirahesh, Incremental maintenance for non-distributive aggregate functions, Proceedings of the 28th international conference on Very Large Data Bases, p.802-813, August 20-23, 2002, Hong Kong, China
	Jingren Zhou , Per-Ake Larson , Hicham G. Elmongui, Lazy maintenance of materialized views, Proceedings of the 33rd international conference on Very large data bases, September 23-27, 2007, Vienna, Austria
	Ki Yong Lee , Myoung Ho Kim, Efficient incremental maintenance of data cubes, Proceedings of the 32nd international conference on Very large data bases, September 12-15, 2006, Seoul, Korea
	Stefano Ceri , Roberta Cochrane , Jennifer Widom, Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award), Proceedings of the 26th International Conference on Very Large Data Bases, p.254-262, September 10-14, 2000
	Himanshu Gupta , Inderpal Singh Mumick, Incremental maintenance of aggregate and outerjoin expressions, Information Systems, v.31 n.6, p.435-464, September 2006

INDEX TERMS

Primary Classification:
H. Information Systems
H.2 DATABASE MANAGEMENT

General Terms:
Languages, Management

Collaborative Colleagues:

Wolfgang Lehner: colleagues

Richard Sidle: colleagues

Hamid Pirahesh: colleagues

Roberta Wolfgang Cochrane: colleagues

Peer to Peer - Readers of this Article have also read:

The effect of latency on user performance in Warcraft III Proceedings of the 2nd workshop on Network and system support for games
Nathan Sheldon , Eric Girard , Seth Borg , Mark Claypool , Emmanuel Agu
Learning subjective relevance to facilitate information access Proceedings of the fourth international conference on Information and knowledge management
James R. Chen , Nathalie Mathé
Data structures for quadtree approximation and compression Communications of the ACM 28, 9
Hanan Samet
A hierarchical single-key-lock access control using the Chinese remainder theorem Proceedings of the 1992 ACM/SIGAPP Symposium on Applied computing
Kim S. Lee , Huizhu Lu , D. D. Fisher
The GemStone object database management system Communications of the ACM 34, 10
Paul Butterworth , Allen Otis , Jacob Stein

This Article has also been published in:

ACM SIGMOD Record
Volume 29 , Issue 2 June 2000

Adobe Acrobat

QuickTime

Windows Media Player

Real Player