Sciweavers

Share
SIGMOD
2001
ACM

Materialized View Selection and Maintenance Using Multi-Query Optimization

11 years 4 months ago
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...
Hoshi Mistry, Prasan Roy, S. Sudarshan, Krithi Ram
Added 08 Dec 2009
Updated 08 Dec 2009
Type Conference
Year 2001
Where SIGMOD
Authors Hoshi Mistry, Prasan Roy, S. Sudarshan, Krithi Ramamritham
Comments (0)
books