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.
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 *