多维数据实视图的动态选择

Dynamic Selection of Materialized Views of Multi-Dimensional Data

提出了多维数据中实视图的动态选择方案.其基本思想是由系统跟踪查询的分布情况,并据此动态地调整实视图集合.具体实现了该方案,并证明了在一定条件下,单次选择算法的效果与最优效果的差具有一定的上限.实验结果表明,动态方案的效果优于已有的其他选择方案.

A novel method is proposed to select materialized views of multi-dimensional data called dynamic selection. The idea of dynamic selection is that the system is in charged of collecting the queries to obtain their distribution. The set of materialized views is adjusted dynamically according to the queries?distribution. The method is given in detail including the algorithm of single-step selection and the instant adjusting method. It is also proved that under certain constraints, the performance of the single-step algorithm is guaranteed to be no worse than that of the optimal one by a certain bound. The experimental results show that the dynamic selection is more effective than other solutions.