Materialized View Selection and Maintenance Using Multi-Query Optimization

Materialized views have been found to be very effective at speeding up queries, and are increasingly being supported by commercial databases and data warehouse systems. However, whereas the amount of data entering a warehouse and the number of materialized views are rapidly increasing, the time window available for maintaining materialized views is shrinking. These trends necessitate efficient techniques for the maintenance of materialized views. In this paper, we show how to find an efficient plan for the maintenance of a set of materialized views, by exploiting common subexpressions between different view maintenance expressions. In particular, we show how to efficiently select (a) expressions and indices that can be effectively shared, by transient materialization; (b) additional expressions and indices for permanent materialization; and (c) the best maintenance plan ? incremental or recomputation ? for each view. These three decisions are highly interdependent, and the choice of o...

• Type: Conference
• Year: 2001
• Where: SIGMOD
• Authors: Hoshi Mistry, Prasan Roy, S. Sudarshan, Krithi Ramamritham
• Keywords: Database, Materialized Views, SIGMOD 2001, View Maintenance Expressions, View Maintenance Time