Materialized view selection using HBMO

T. V. Vijay Kumar () and Biri Arun
Additional contact information
T. V. Vijay Kumar: Jawaharlal Nehru University
Biri Arun: Jawaharlal Nehru University

International Journal of System Assurance Engineering and Management, 2017, vol. 8, issue 1, No 36, 379-392

Abstract: Abstract Strategic business decision making has become far more complex, challenging and consequential in today’s modern and highly competitive economy. So, managers have been using decision support systems to assist them in making accurate, efficient and effective decisions. These systems takes hours and days to process massive data sets in order to find relevant information for answering analytical queries. As a result the query response times are high. This response time can be reduced substantially by selecting and materializing pre-computed views that can provide answers to analytical queries. In this paper, an attempt has been made to select optimal sets of views, which would significantly reduce response time of analytical queries. In this regard, honey bee mating optimization based view selection algorithm (HBMOVSA) is proposed that selects Top-K views, from amongst all possible views, in a multidimensional lattice. Experimental results show that HBMOVSA is able to select comparatively better quality of views when compared with those selected by the most fundamental view selection algorithm HRUA.

Keywords: Data warehouse; Materialized view selection; Swarm intelligence; Honey bee mating optimization (search for similar items in EconPapers)
Date: 2017
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (4)

Downloads: (external link)
http://link.springer.com/10.1007/s13198-015-0356-4 Abstract (text/html)
Access to the full text of the articles in this series is restricted.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:ijsaem:v:8:y:2017:i:1:d:10.1007_s13198-015-0356-4

Ordering information: This journal article can be ordered from
http://www.springer.com/engineering/journal/13198

DOI: 10.1007/s13198-015-0356-4

Access Statistics for this article

International Journal of System Assurance Engineering and Management is currently edited by P.K. Kapur, A.K. Verma and U. Kumar

More articles in International Journal of System Assurance Engineering and Management from Springer, The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().