Research and realization on query_cost view selection problem
Minhua Wu · Computer Engineering and Applications Journal · 2007
One of the important problems in a data warehouse is the selection of views to materialize.Materialized views are stored in a data warehouse for the purpose of efficiently implementing on-line analytical processing queries.A query response time is the first issue for user’s requirement.So,this paper proposes view selection problem based on query cost and its cost model.The paper presents solution and strategy using genetic algorithm.The experimental study shows that the algorithm has better solutions and high efficiency.