Journal of Computer Applications ›› 2009, Vol. 29 ›› Issue (10): 2772-2773.

• Data mining • Previous Articles     Next Articles

Strategy of materializing views based on queries of time period

  

  • Received:2009-04-28 Revised:2009-06-10 Online:2009-10-28 Published:2009-10-01
  • Contact: Xiang YU

基于时间段查询的物化视图策略

于翔1,印桂生2   

  1. 1. 哈尔滨工程大学
    2. 哈尔滨工程大学计算机科学与技术学院
  • 通讯作者: 于翔
  • 基金资助:
    863高新技术研究发展基金:基于自律计算的分布式系统自恢复关键技术研究

Abstract: An effective method to reduce the response time to query is to materialize views in data warehouse. The current strategies mainly consider the methods of the primary selection of materialized views and the methods of dynamic updating. Concerning the situation that the updating of views based on queries of time period did not get enough attention, based on greedy algorithm and dynamic refreshment algorithm, the authors proposed a method of materializing views based on queries of time period. The method of materializing views based on queries of time period can meet the needs of clients, and enhance the efficiency of queries.

Key words: data warehouse, materialized view, query, refreshment

摘要: 物化视图是减少数据仓库中查询响应时间的有效方法。现有的物化视图选择策略主要考虑物化视图的初始选择方法以及动态更新方法。针对某时间段内查询进行物化视图更新的情况考虑不足,在贪心算法以及动态更新算法的基础上,提出了基于时间段内查询的物化视图更新策略。基于时间段查询的物化视图更新策略可充分适应用户需求,提高查询效率。

关键词: 数据仓库, 物化视图, 查询, 更新