Integration of incremental view maintenance into query optimizers

Abstract

We report on our experiences in integrating view maintenance policies into a database query optimizer. We present the design, implementation and use of the RHODES query optimizer. RHODES is responsible for the generation of the maintenance expressions to be used for the maintenance of views, as well as for the generation of execution plans for their execution. We also discuss a variety of optimizations that RHODES applies during view maintenance and change propagation. We demonstrate the effectiveness of the proposed optimizations by experiments performed on the TPC-D database. The experiments also demonstrate the cost tradeoffs amongst multiple maintenance policies for a view.