使用适当的算法选取视图集进行物化,可以使数据库取得更高的查询效率。从经典的物化视图模型出发,分析比较了不同物化视图选择算法的优缺点,指出传统算法难以解决大数据背景下海量高维度数据的物化视图选择问题,归纳了在云计算并行环境下解决物化视图选择问题研究的进展,提出了支持数据立方体物化视图选择算法的改进思路。
It makes the database get higher query processing efficiency when appropriate algorithms are applied to select the materialized view set. In this work, representative frameworks of materialized views were introduced; advantages and disadvantages of different algorithms for materialized view selection were compared. It is pointed out that the conventional algorithms are hard to solve the materialized view selection problem when the data sets are large in amount or the dimensions of them are very high. The latest researches on solving the materialized view selection problem by using parallel computing architecture under cloud computing environment were summarized. Some thoughts were proposed to improve the algorithms for solving materialized view selection problems.