Materialized Views Optimal Selection for Data Warehouse Quality

摘要

For the success of any data warehouse, accurate and timely consolidated information along with quick and effective query response times is the basic fundamental requirement. The materialization of all views is practically impossible because of the materialized view storage space and maintenance cost constraint thus proper materialized views selection is one of the intelligent decisions in designing a data warehouse to get optimal efficiency. This study presents a framework for selecting best materialized view using algorithm Particle Swarm Optimization (PSO) this algorithm one of the stochastic algorithm so as to achieve the effective combination of good query response time, low query processing cost and low view maintenance cost. The results showed that the proposed method for selecting best materialized view using PSO algorithm is better than other techniques through compute the ratio of query response time and compare it to the response time of the same queries on the materialized views ratio of implementing the query on the base table takes eleven times more than time of the query implementation on the materialized views. Where the response time of queries through MVs access were found 0092 msec while through direct access queries were found 1039 msec. This show the performance of query through materialized views access is 1029.34% better than those directly access through data warehouse.