We start with a framework for reasoning about aggregations given the technology at hand, including methodology and standards for designing, maintaining and automating the deployment and maintenance of redundant tables, and the automation of the process. We address these and more questions as we approach real problems in aggregation design. Although the motivation for the approaches discussed comes from specific experiences, we try to evaluate a variety of options available and propose pros and cons. Some of these may appear farfetched, but they are driven from real concerns and attempt to bring concepts that evolved over many years of experience together with more and more capable technology while designing real VLDB systems.

VDM Access: