TY  - JOUR
T1  - Materialized Views Optimal Selection for Data Warehouse Quality
AU - Salih, Mohanad Ahamed AU - Hamad, Murtadha M. 
JO  - Journal of Engineering and Applied Sciences
VL  - 12
IS  - 22
SP  - 5997
EP  - 6005
PY  - 2017
DA  - 2001/08/19
SN  - 1816-949x
DO  - jeasci.2017.5997.6005
UR  - https://makhillpublications.co/view-article.php?doi=jeasci.2017.5997.6005
KW  - Data warehouse
KW  -select materialized view
KW  -OLAP
KW  -query processing
KW  -query access frequency
KW  -performance
AB  - 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.
ER  -