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

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