Approaches and issues in view selection for materialising in data warehouse
Rajib Goswami, Dhruba K. Bhattacharyya, Malayananda Dutta, Jugal Kumar Kalita · International Journal of Business Information Systems · 2015
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.