Guy M. Lohman, Bruce Lindsay, et al.
CACM
Paper
Maintenance of cube automatic summary tables
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.
Related
Conference paper
Robust query processing through progressive optimization
Volker Markl, Vijayshankar Raman, et al.
SIGMOD 2004
Conference paper
A snapshot differential refresh algorithm
Bruce Lindsay, Laura Haas, et al.
SIGMOD 1986
Hamid Pirahesh, Joseph M. Hellerstein, et al.
SIGMOD Record