Conference paper
WinMagic: Subquery Elimination Using Window Aggregation
Calisto Zuzarte, Hamid Pirahesh, et al.
SIGMOD 2003
Conference 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
C. Mohan, Don Haderle, et al.
ACM Transactions on Database Systems (TODS)
Paper
Magic Conditions
Inderpal Singh Mumick, Sheldon J. Finkelstein, et al.
ACM TODS
Conference paper
The Onion Technique: Indexing for Linear Optimizatin Queries
Yuan-Chi Chang, Lawrence Bergman, et al.
SIGMOD 2000