Materialized View Selection Using Bumble Bee Mating Optimization

Biri Arun and T.V. Vijay Kumar
Additional contact information
Biri Arun: School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi, India
T.V. Vijay Kumar: School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi, India

International Journal of Decision Support System Technology (IJDSST), 2017, vol. 9, issue 3, 1-27

Abstract: Decision support systems (DSS) constitute one of the most crucial components of almost every corporation's information system. Data warehouse provides the DSS with massive volumes of quality corporate data for analysis. On account of the volume of corporate data, its processing time of on-line analytical queries is huge (in hours and days). Materialized views have been used to substantially improve query performance. Nevertheless, selecting appropriate sets of materialized views is an NP-Complete problem. In this paper, a new discrete bumble bee mating inspired view selection algorithm (BBMVSA) that selects Top-K views from a multidimensional lattice has been proposed. Experimental results show that BBMVSA was able to select fairly good quality Top-K views incurring a lower TVEC. Materialization of the selected views would improve the overall data analysis of DSS and would facilitate the decision making process.

Date: 2017
References: Add references at CitEc
Citations: View citations in EconPapers (3)

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 18/IJDSST.2017070101 (application/pdf)

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:igg:jdsst0:v:9:y:2017:i:3:p:1-27

Access Statistics for this article

International Journal of Decision Support System Technology (IJDSST) is currently edited by Shaofeng Liu

More articles in International Journal of Decision Support System Technology (IJDSST) from IGI Global
Bibliographic data for series maintained by Journal Editor ().