Materialised view selection using BCO Online publication date: Sun, 05-Jun-2016
by T.V. Vijay Kumar; Biri Arun
International Journal of Business Information Systems (IJBIS), Vol. 22, No. 3, 2016
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.
Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Business Information Systems (IJBIS):
Login with your Inderscience username and password:
Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.
If you still need assistance, please email subs@inderscience.com
Our Blog 
Follow us on Twitter 
Visit us on Facebook