Materialised view selection using randomised algorithms Online publication date: Sat, 16-May-2015
by T.V. Vijay Kumar; Santosh Kumar
International Journal of Business Information Systems (IJBIS), Vol. 19, No. 2, 2015
Abstract: A data warehouse stores historical data for the purpose of answering decision making queries. Such queries are usually exploratory and complex in nature and have a high response time when processed against a continuously growing data warehouse. This response time can be reduced by materialising the views in a data warehouse. All views cannot be materialised due to space constraints. Also, optimal view selection is an NP-complete problem. This paper proposes a randomised view selection two phase optimisation algorithm (VS2POA) that selects the top-T views from a multi-dimensional lattice. VS2POA selects views in two phases wherein, in the first phase, iterative improvement is used to select the best local optimised top-T views. These become the initial set of top-T views for the next phase, which is based on simulated annealing. VS2POA, in comparison to the well known greedy algorithm HRUA, selects comparatively better quality views for higher dimensional datasets.
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