Conference paper
Canonical abstraction for outerjoin optimization
Jun Rao, Hamid Pirahesh, et al.
SIGMOD 2004
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.
Jun Rao, Hamid Pirahesh, et al.
SIGMOD 2004
Ronald Barber, Christian Garcia-Arellano, et al.
CIDR 2017
Rainer Gemulla, Peter J. Haas, et al.
VLDB Journal
Markos Zaharioudakis, Roberta Cochrane, et al.
SIGMOD Record (ACM Special Interest Group on Management of Data)