Dynamic Optimization Algorithm of Static Materialized Views

Dynamic Optimization Algorithm of Static Materialized Views

In this paper an algorithm DCO (dynamic cache optimization) is proposed for the static materialized views that lack better response performance to dynamic queries. Based on the optimal static materialized views, DCO combines cache mechanism to obtain dynamic materialized views with dynamic adaptability and quick response. Meanwhile, a novel method of allocating free space is presented to implement the dynamic cache, and thus the free space of system can be used efficiently to store more materialized views for improving the query response. Experimental results indicate the efficiency and feasibility of DCO, and also show that DCO can overcome the SPSE (space-performance saturation effect) of materialized views in some degree.