Title :
Strategy of Selecting Materialized Views Based on Cache-updating
Author :
Yin, Guisheng ; Yu, Xiang ; Lin, Liandong
Author_Institution :
Univ. Eng.Harbin, Harbin
Abstract :
An effective method to reduce the time of response time about query is to materialize views in data warehouse. Current strategies mainly consider the methods of the primary selection of materialized views. Due to the insufficient consideration of the dynamic refreshment, we address a new dynamic method which can wash out materialized views and add new materialized views in the set of current materialized views on the basis of the greedy algorithm.
Keywords :
cache storage; data warehouses; greedy algorithms; query processing; cache updating; data warehouse; greedy algorithm; materialized views; query response time; Books; Contracts; Costs; Data engineering; Data warehouses; Databases; Delay; Educational institutions; Greedy algorithms; Marketing and sales; data warehouse; materialized views; refreshment; selection;
Conference_Titel :
Integration Technology, 2007. ICIT '07. IEEE International Conference on
Conference_Location :
Shenzhen
Print_ISBN :
1-4244-1092-4
Electronic_ISBN :
1-4244-1092-4
DOI :
10.1109/ICITECHNOLOGY.2007.4290430