Efficient Materialized View Selection for Multi-Dimensional Data Cube Models

Naveen Dahiya, Vishal Bhatnagar and Manjeet Singh
Additional contact information
Naveen Dahiya: Maharaja Surajmal Institute of Technology, New Delhi, India
Vishal Bhatnagar: Department of Computer Science and Engineering, Ambedkar Institute of Advanced Communication Technologies and Research, New Delhi, India
Manjeet Singh: Y.M.C.A. University of Science and Technology, Faridabad, India

International Journal of Information Retrieval Research (IJIRR), 2016, vol. 6, issue 3, 52-74

Abstract: Decision Support Systems help managers to make intelligent decisions by throwing complex queries on large databases. The response time to queries is a very crucial factor in governing the quality of decision support systems. The response time can be greatly improved by using query optimization techniques. A powerful query optimization technique selects only some of the views and not all views for materialization. The authors in this paper present a refined greedy selection approach using forward references to give better materialized view selection. The approach works on lattice framework of data that is capable enough to show inter dependencies of data. The choice of materialized views using the proposed approach gives a better trade off in terms of space/benefits, which is proved from the experimental results. The refined greedy selection approach is independent of space constraint and depends on number of passes entered by the user. The view selection is further enhanced by including space constraints to the results of greedy and refined greedy approach using knapsack implementation.

Date: 2016
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 018/IJIRR.2016070104 (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:jirr00:v:6:y:2016:i:3:p:52-74

Access Statistics for this article

International Journal of Information Retrieval Research (IJIRR) is currently edited by Zhongyu Lu

More articles in International Journal of Information Retrieval Research (IJIRR) from IGI Global
Bibliographic data for series maintained by Journal Editor ().