 Materialised view selection using BCOT.V. Vijay Kumar and Biri Arun International Journal of Business Information Systems, 2016, vol. 22, issue 3, 280-301 Abstract: Economists in the post-industrial era had long realised that data, information and knowledge are the key capital of any organisation. Presently, almost every enterprise maintains their data in a data warehouse. This helps the analyst in accessing critical business information in real time using online analytical processing (OLAP) tools. Materialised views have been the popular mode used to achieve very fast OLAP operations. Selecting appropriate sets of optimal views, from amongst all possible views, is an NP-complete problem. In this paper, the bee colony optimisation (BCO) meta-heuristic, which is inspired by the foraging behaviour of bees in nature, has been adapted to address the view selection problem. In this regard, a BCO-based view selection algorithm (BCOVSA), that selects the Top-K views from a multidimensional lattice, has been proposed. The experimental results show that BCOVSA, in comparison to the most fundamental greedy view selection algorithm HRUA, is able to select comparatively better quality of views. Keywords: data warehouse; materialised view selection; swarm intelligence; bee colony optimisation; BCO; online analytical processing; OLAP; artificial bee colony; ABC; business information systems. (search for similar items in EconPapers) Downloads: (external link) Related works: Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text Persistent link: https://EconPapers.repec.org/RePEc:ids:ijbisy:v:22:y:2016:i:3:p:280-301 Access Statistics for this article More articles in International Journal of Business Information Systems from Inderscience Enterprises Ltd |
Is your work missing from RePEc? Here is how to contribute.
Questions or problems? Check the EconPapers FAQ or send mail to .
EconPapers is hosted by the
School of Business at Örebro University.