Approaches and issues in view selection for materialising in data warehouse

Rajib Goswami, Dhruba Kr Bhattacharyya, Malayananda Dutta and Jugal K. Kalita

International Journal of Business Information Systems, 2016, vol. 21, issue 1, 17-47

Abstract: To facilitate efficient query processing in data warehouses and develop online analytical processing (OLAP) for decision support systems, intermediate data derived in the middle of complex processing may be stored as a set of materialised views. It is not possible to save each and every intermediate query result due to limitation of space and updating cost. Therefore, an optimum set of views need to be selected for materialisation and, this requires a good optimisation technique. Many approaches have been presented in the literature to achieve good solutions to this problem. In this paper, we attempt to provide a comprehensive survey of the approaches and algorithms introduced to address the issue. We also attempt to identify the key issues and research challenges in this area.

Keywords: data warehousing; view selection; materialised views; query response cost; materialised view maintenance; online analytical processing; OLAP; HRU algorithm; randomised algorithm; AND-OR view graph; optimal query plan; query processing; decision support systems; DSS. (search for similar items in EconPapers)
Date: 2016
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=73379 (text/html)
Access to full text is restricted to subscribers.

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:ids:ijbisy:v:21:y:2016:i:1:p:17-47

Access Statistics for this article

More articles in International Journal of Business Information Systems from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().