Maintenance of Cube Automatic Summary Tables

Research output: Contribution to book/Conference proceedings/Anthology/Report › Conference contribution › Contributed › peer-review

Contributors

  • Wolfgang Lehner - , Friedrich-Alexander University Erlangen-Nürnberg (Author)
  • Richard Sidle - , IBM (Author)
  • Hamid Pirahesh - , IBM (Author)
  • Roberta Cochrane - , IBM (Author)

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.

Details

Original languageEnglish
Title of host publicationSIGMOD 2000 - Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data
PublisherAssociation for Computing Machinery, Inc
Pages512-513
Number of pages2
ISBN (electronic)9781581132175
Publication statusPublished - 2000
Peer-reviewedYes
Externally publishedYes

Conference

Title2000 ACM SIGMOD International Conference on Management of Data, SIGMOD 2000
Duration15 - 18 May 2000
CityDallas
CountryUnited States of America

External IDs

ORCID /0000-0001-8107-2775/work/198592319

Keywords

ASJC Scopus subject areas