Title: An ontology-based approach for automatic goal requirements engineering in data warehouse design

Authors: Fahmi Bargui; Hanêne Ben-Abdallah

Addresses: Department of Computer Science, Faculty of Economics and Management, University of Sfax, Tunisia ' Higher Colleges of Technology, P.O. Box 25026, Abu Dhabi, United Arab Emirates

Abstract: Goal-oriented approaches in data warehouse development projects still face two main issues. First, analysts often lack domain knowledge required during goal decomposition. This may lead to identifying erroneous requirements that most likely propagate to the remaining project phases, potentially leading to the project failure. Second, the identification of the data warehouse content from requirements is done manually by the designers in an error-prone process. In this paper, we address these two issues. We propose an ontology that formalises and automates the reasoning about decision-making knowledge, which allows analysts to compensate their lack of domain knowledge during goal decomposition. In addition, to demonstrate the feasibility of our proposal we present a semi-automatic process that assists the construction of the ontology. Furthermore, the proposed ontology ensures the traceability between both decision-making and data warehouse knowledge. Thanks to this traceability, we propose a set of rules that automatically derive a data warehouse schema from requirements specification.

Keywords: decision support systems; data warehouse; data mart; requirements elicitation; multidimensional modelling; automatic reasoning; goal-oriented requirements engineering; ontology.

DOI: 10.1504/IJIDS.2021.116494

International Journal of Information and Decision Sciences, 2021 Vol.13 No.2, pp.143 - 165

Received: 23 Apr 2019
Accepted: 28 May 2019
Published online: 27 Jul 2021 *

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