Answering query-based selection of materialised views Online publication date: Fri, 28-Feb-2014
by T.V. Vijay Kumar
International Journal of Information and Decision Sciences (IJIDS), Vol. 5, No. 1, 2013
Abstract: Materialised views aim to improve the response time of analytical queries posed on a data warehouse. This entails that they contain information that can provide answers to most of the future queries. The selection of such information is referred to as view selection. Several view selection algorithms exist in literature, most of which are greedy-based. In this paper, an answering query-based view selection approach (AQVSA), which considers both the size and the query frequency of each view, to greedily select top-k views for materialisation is presented. AQVSA first arrives at a reduced set of candidate views based on the query frequency of each view. This is followed by greedily selecting beneficial views from amongst these candidate views. Further, the experimental results show that AQVSA is able to achieve an acceptable trade-off between the total cost of evaluating all the views and the total number of queries answered by the selected 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 Information and Decision Sciences (IJIDS):
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