Aggregate Maintenance for Data Warehousing in Informix Red Brick~(～R) Vista~(TM)

摘要

Dramatic performance gains can be realized in decision support DBMSs by leveraging pre-computed aggregates (i.e., materialized aggregate views). Informix Red Brick Vista provides a comprehensive solution for aggregate computation and management in data warehousing environments through the effective use of precomputed aggregates. Vista's transparent rewrite, advisor, and maintenance components allow users to maximize the benefits of precomputed aggregates while minimizing the costs associated with creating and maintaining them. In this paper, we provide an overview of Vista's maintenance subsystem. We describe optimizations used to make maintenance highly efficient, and discuss how Vista's focus on star schemas and data warehousing environments influenced the maintenance subsystem.