Title: A bottom-up approach for creating goal hierarchy using OLAP query recommendation technique

Authors: Ranjeet Kumar Ranjan; N. Parimala

Addresses: School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi 110067, India ' School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi 110067, India

Abstract: Traditionally, data warehouses have been designed guided by an analysis of the underlying data sources. On the other hand, goal-oriented approaches build a goal decomposition structure which is further mapped to a data warehouse model. Goal-oriented approaches address the requirements of the decision makers. In this paper, we propose to build a goal decomposition structure for traditional data warehouses. As a result it can be assessed whether the existing data warehouse model satisfies the decision makers' requirements. The approach is bottom-up wherein the tasks are identified first and the path to the strategic goal is built later. The tasks themselves are identified using OLAP query recommendation technique.

Keywords: data analysis; data warehousing; online analytical processing; OLAP; multidimensional expressions; MDX; goal decomposition; goal hierarchy; strategic rationale diagram; query recommendation; cosine similarity; similarity measure.

DOI: 10.1504/IJBIS.2018.093656

International Journal of Business Information Systems, 2018 Vol.28 No.4, pp.425 - 446

Received: 02 Jul 2016
Accepted: 20 Dec 2016
Published online: 31 Jul 2018 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article