Article

Free access

Maintenance of cube automatic summary tables

Authors:

Wolfgang Lehner,

Richard Sidle,

Hamid Pirahesh,

Roberta Wolfgang CochraneAuthors Info & Claims

SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

Pages 512 - 513

https://doi.org/10.1145/342009.335454

Published: 16 May 2000 Publication History

PDF eReader

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

[1]

Harinarayan, V.; Rajaraman, A.; Ullman, J.: Implementing Data Cubes Efficiently. In: SIGMOD'96, pp. 205

Digital Library

Google Scholar

[2]

Mumick, I.; Quass, D.; Mumick, B.: Maintenance of Data Cubes and Summary Tables in a Warehouse. In. SIGMOD' 97, pp. 100-111

Digital Library

Google Scholar

[3]

Beyer, K.; Cochrane, B. Lindsay, B.; Salem K.: How To Roll a Join. IBM research paper. In. SIGMOD'2000

Google Scholar

[4]

Zaharioudakis, M.; Cochrane, R.; Lapis, G.; Pirahesh, H.; Urata, M.: Answering Complex SQL Queries Using Automatic Summary Tables. In: SIGMOD'2000

Digital Library

Google Scholar

Cited By

View all

Phani ATekur CSai Krishna R(2019)Commit Time Materialized View Maintenance for Bulk Load Operations in Teradata2019 IEEE International Conference on Electrical, Computer and Communication Technologies (ICECCT)10.1109/ICECCT.2019.8869100(1-5)Online publication date: Feb-2019
https://doi.org/10.1109/ICECCT.2019.8869100
Muller S(2014)Aggregates caching for enterprise applications2014 IEEE 30th International Conference on Data Engineering Workshops10.1109/ICDEW.2014.6818353(345-349)Online publication date: Mar-2014
https://doi.org/10.1109/ICDEW.2014.6818353
Ammendola CBöhlen MGamper J(2013)Efficient Evaluation of Ad-Hoc Range AggregatesProceedings of the 15th International Conference on Data Warehousing and Knowledge Discovery - Volume 805710.1007/978-3-642-40131-2_5(46-59)Online publication date: 26-Aug-2013
https://dl.acm.org/doi/10.1007/978-3-642-40131-2_5
Show More Cited By

Index Terms

Maintenance of cube automatic summary tables
1. Information systems
  1. Data management systems
    1. Query languages
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query languages (principles)

Recommendations

Maintenance of cube automatic summary tables

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 ...
Answering complex SQL queries using automatic summary tables

We investigate the problem of using materialized views to answer SQL queries. We focus on modern decision-support queries, which involve joins, arithmetic operations and other (possibly user-defined) functions, aggregation (often along multiple ...
Answering complex SQL queries using automatic summary tables
SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

We investigate the problem of using materialized views to answer SQL queries. We focus on modern decision-support queries, which involve joins, arithmetic operations and other (possibly user-defined) functions, aggregation (often along multiple ...

Comments

Information & Contributors

Information

Published In

SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

May 2000

604 pages

ISBN:1581132174

DOI:10.1145/342009

Chairmen:
Maggie Dunham
Southern Methodist Univ.
,
Jeffrey F. Naughton
Univ. of Wisconsin-Madison
,
Weidong Chen
Southern Methodist Univ.
,
Nick Koudas
AT &T Labs

ACM SIGMOD Record Volume 29, Issue 2
June 2000
609 pages
ISSN:0163-5808
DOI:10.1145/335191
Editors:
Weidong Chen
Southern Methodist Univ., Dallas, TX
,
Jeffrey Naughton
Univ. of Wisconsin-Madison, Madison
,
Philip A. Bernstein
Microsoft
Issue’s Table of Contents

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 May 2000

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

SIGMOD/PODS00

Sponsor:

SIGMOD

SIGMOD/PODS00: ACM International Conference on Management of Data and Symposium on Principles of Database Systems

May 15 - 18, 2000

Texas, Dallas, USA

Acceptance Rates

SIGMOD '00 Paper Acceptance Rate 42 of 248 submissions, 17%;

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

21
Total Citations
View Citations
134
Total Downloads

Downloads (Last 12 months)53
Downloads (Last 6 weeks)17

Reflects downloads up to 15 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Phani ATekur CSai Krishna R(2019)Commit Time Materialized View Maintenance for Bulk Load Operations in Teradata2019 IEEE International Conference on Electrical, Computer and Communication Technologies (ICECCT)10.1109/ICECCT.2019.8869100(1-5)Online publication date: Feb-2019
https://doi.org/10.1109/ICECCT.2019.8869100
Muller S(2014)Aggregates caching for enterprise applications2014 IEEE 30th International Conference on Data Engineering Workshops10.1109/ICDEW.2014.6818353(345-349)Online publication date: Mar-2014
https://doi.org/10.1109/ICDEW.2014.6818353
Ammendola CBöhlen MGamper J(2013)Efficient Evaluation of Ad-Hoc Range AggregatesProceedings of the 15th International Conference on Data Warehousing and Knowledge Discovery - Volume 805710.1007/978-3-642-40131-2_5(46-59)Online publication date: 26-Aug-2013
https://dl.acm.org/doi/10.1007/978-3-642-40131-2_5
Lee KChung YKim M(2010)An efficient method for maintaining data cubes incrementallyInformation Sciences: an International Journal10.1016/j.ins.2009.11.037180:6(928-948)Online publication date: 1-Mar-2010
https://dl.acm.org/doi/10.1016/j.ins.2009.11.037
Zhang YZhang YXiao YWang SChen H(2009)The Tradeoff of Delta Table Merging and Re-writing Algorithms in What-If Analysis ApplicationProceedings of the Joint International Conferences on Advances in Data and Web Management10.1007/978-3-642-00672-2_24(260-272)Online publication date: 22-Mar-2009
https://dl.acm.org/doi/10.1007/978-3-642-00672-2_24
Jin DTsuji TTsuchida THiguchi K(2008)An incremental maintenance scheme of data cubesProceedings of the 13th international conference on Database systems for advanced applications10.5555/1802514.1802534(172-187)Online publication date: 19-Mar-2008
https://dl.acm.org/doi/10.5555/1802514.1802534
Jin DTsuji TTsuchida THiguchi K(2008)An Incremental Maintenance Scheme of Data CubesDatabase Systems for Advanced Applications10.1007/978-3-540-78568-2_15(172-187)Online publication date: 2008
https://doi.org/10.1007/978-3-540-78568-2_15
Zhou JLarson PElmongui HKlas WNeuhold E(2007)Lazy maintenance of materialized viewsProceedings of the 33rd international conference on Very large data bases10.5555/1325851.1325881(231-242)Online publication date: 23-Sep-2007
https://dl.acm.org/doi/10.5555/1325851.1325881
Lee KKim M(2006)Efficient incremental maintenance of data cubesProceedings of the 32nd international conference on Very large data bases10.5555/1182635.1164198(823-833)Online publication date: 1-Sep-2006
https://dl.acm.org/doi/10.5555/1182635.1164198
El-Sayed MRundensteiner EMani M(2006)Incremental Maintenance of Materialized XQuery ViewsProceedings of the 22nd International Conference on Data Engineering10.1109/ICDE.2006.80Online publication date: 3-Apr-2006
https://dl.acm.org/doi/10.1109/ICDE.2006.80
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

Maintenance of cube automatic summary tables

Answering complex SQL queries using automatic summary tables

Answering complex SQL queries using automatic summary tables