Welcome to the InfoSci Platform
Reference Hub19
Materialized View Selection using Marriage in Honey Bees Optimization

Materialized View Selection using Marriage in Honey Bees Optimization

Biri Arun, T.V. Vijay Kumar
Copyright: © 2015 |Volume: 5 |Issue: 3 |Pages: 25
ISSN: 1947-928X|EISSN: 1947-9298|EISBN13: 9781466678255|DOI: 10.4018/IJNCR.2015070101
Cite Article Cite Article

MLA

Arun, Biri, and T.V. Vijay Kumar. "Materialized View Selection using Marriage in Honey Bees Optimization." IJNCR vol.5, no.3 2015: pp.1-25. http://doi.org/10.4018/IJNCR.2015070101

APA

Arun, B. & Kumar, T. V. (2015). Materialized View Selection using Marriage in Honey Bees Optimization. International Journal of Natural Computing Research (IJNCR), 5(3), 1-25. http://doi.org/10.4018/IJNCR.2015070101

Chicago

Arun, Biri, and T.V. Vijay Kumar. "Materialized View Selection using Marriage in Honey Bees Optimization," International Journal of Natural Computing Research (IJNCR) 5, no.3: 1-25. http://doi.org/10.4018/IJNCR.2015070101

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Data warehouse was designed to cater to the strategic decision making needs of an organization. Most queries posed on them are on-line analytical queries, which are complex and computation intensive in nature and have high query response times when processed against a large data warehouse. This time can be substantially reduced by materializing pre-computed summarized views and storing them in a data warehouse. All possible views cannot be materialized due to storage space constraints. Also, an optimal selection of subsets of views is shown to be an NP-Complete problem. This problem of view selection has been addressed in this paper by selecting a beneficial set of views, from amongst all possible views, using the swarm intelligence technique Marriage in Honey Bees Optimization (MBO). An MBO based view selection algorithm (MBOVSA), which aims to select views that incur the minimum total cost of evaluating all the views (TVEC), is proposed. In MBOVSA, the search has been intensified by incorporating the royal jelly feeding phase into MBO. MBOVSA, when compared with the most fundamental greedy based view selection algorithm HRUA, is able to select comparatively better quality views.

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.