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

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.