article

Free access

Maintenance of cube automatic summary tables

Authors:

Wolfgang Lehner,

Richard Sidle,

Hamid Pirahesh,

Roberta Wolfgang CochraneAuthors Info & Claims

ACM SIGMOD Record, Volume 29, Issue 2

Pages 512 - 513

https://doi.org/10.1145/335191.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

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
WANG SXIAO YZHANG YCHEN H(2009)Research on OLAP System Supporting What-if AnalysisChinese Journal of Computers10.3724/SP.J.1016.2008.0157331:9(1573-1587)Online publication date: 11-Oct-2009
https://doi.org/10.3724/SP.J.1016.2008.01573
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

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 ...
Maintenance of data cubes and summary tables in a warehouse

Data warehouses contain large amounts of information, often collected from a variety of independent sources. Decision-support functions in a warehouse, such as on-line analytical processing (OLAP), involve hundreds of complex aggregate queries over ...
Maintenance of cube automatic summary tables
SIGMOD '00: Proceedings of the 2000 ACM SIGMOD international conference on Management of data

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 ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

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

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

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

Published in SIGMOD Volume 29, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

21
Total Citations
View Citations
142
Total Downloads

Downloads (Last 12 months)60
Downloads (Last 6 weeks)12

Reflects downloads up to 13 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

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
WANG SXIAO YZHANG YCHEN H(2009)Research on OLAP System Supporting What-if AnalysisChinese Journal of Computers10.3724/SP.J.1016.2008.0157331:9(1573-1587)Online publication date: 11-Oct-2009
https://doi.org/10.3724/SP.J.1016.2008.01573
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
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.

Abstract

References

Cited By

Index Terms

Recommendations

Answering complex SQL queries using automatic summary tables

Maintenance of data cubes and summary tables in a warehouse