Mohanad Ahamed  Salih, Murtadha M.  Hamad, 
    Materialized Views Optimal Selection for Data Warehouse Quality,
    Journal of Engineering and Applied Sciences,
    Volume 12,Issue 22,
    2017,
    Pages 5997-6005,
    ISSN 1816-949x,
    jeasci.2017.5997.6005,
    (https://makhillpublications.co/view-article.php?doi=jeasci.2017.5997.6005)
    Abstract: 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.
    Keywords: Data warehouse;select materialized view;OLAP;query processing;query access frequency;performance