Title: Towards a Framework Embedding Formalisms for Data Warehouse Specification and Design

Issue Number: Vol. 7, No. 4
Year of Publication: Dec - 2017
Page Numbers: 200-214
Authors: Isaac N. Mbala, John A. van der Poll
Journal Name: International Journal of Digital Information and Wireless Communications (IJDIWC)
- Hong Kong
DOI:  http://dx.doi.org/10.17781/P002381


The Data Warehousing use implies the establishment of Data Warehouse and business intelligence systems. A Data Warehouse is a subject oriented, integrated, time variant and nonvolatile data collection which helps decision makers with strategic information. Many researches have proved that most of data warehouse projects miss to meet the business purposes and business requirements because of the carelessness of the significance of entire requirements elicitation and subsequent specification stages. Most of the time, the requirements performed in the course of these definition stages are inadequate or inconsistent, steering to erroneous specifications. In this paper we introduce the challenge of data warehousing projects failure and propose a framework that would facilitate the formalisms for requirements elicitation for data warehouse systems design. Our approach leans towards a hybrid-driven technique for requirements analysis for data warehouse systems. We propose some formalisms for requirements elicitation, followed by formal specification in Z.