Welcome to the InfoSci Platform
Reference Hub23
Materialized View Selection using Artificial Bee Colony Optimization

Materialized View Selection using Artificial Bee Colony Optimization

Biri Arun, T.V. Vijay Kumar
Copyright: © 2017 |Volume: 13 |Issue: 1 |Pages: 24
ISSN: 1548-3657|EISSN: 1548-3665|EISBN13: 9781522511458|DOI: 10.4018/IJIIT.2017010102
Cite Article Cite Article

MLA

Arun, Biri, and T.V. Vijay Kumar. "Materialized View Selection using Artificial Bee Colony Optimization." IJIIT vol.13, no.1 2017: pp.26-49. http://doi.org/10.4018/IJIIT.2017010102

APA

Arun, B. & Kumar, T. V. (2017). Materialized View Selection using Artificial Bee Colony Optimization. International Journal of Intelligent Information Technologies (IJIIT), 13(1), 26-49. http://doi.org/10.4018/IJIIT.2017010102

Chicago

Arun, Biri, and T.V. Vijay Kumar. "Materialized View Selection using Artificial Bee Colony Optimization," International Journal of Intelligent Information Technologies (IJIIT) 13, no.1: 26-49. http://doi.org/10.4018/IJIIT.2017010102

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Data warehouse is an essential component of almost every modern enterprise information system. It stores huge amount of subject-oriented, time-stamped, non-volatile and integrated data. It is highly required of the system to respond to complex online analytical queries posed against its data warehouse in seconds for efficient decision making. Optimization of online analytical query processing (OLAP) could substantially minimize delays in query response time. Materialized view is an efficient and effective OLAP query optimization technique to minimize query response time. Selecting a set of such appropriate views for materialization is referred to as view selection, which is a nontrivial task. In this regard, an Artificial Bee Colony (ABC) based view selection algorithm (ABCVSA), which has been adapted by incorporating N-point and GBFS based N-point random insertion operations, to select Top-K views from a multidimensional lattice is proposed. Experimental results show that ABCVSA performs better than the most fundamental view selection algorithm HRUA. Thus, the views selected using ABCVSA on materialization would reduce the query response time of OLAP queries and thereby aid analysts in arriving at strategic business decisions in an effective manner.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.