Title
CMCD: A data warehouse modeling framework based on goals and business process models
Abstract
The decision making process is mainly data driven, which makes Data Warehousing play a crucial role in providing a reliable and efficient tool to meet analytical needs and provide end users and decision makers with useful insights. However, several surveys show that a significant percentage of Data Warehouse (DW) projects fail to meet their business goals. Indeed, it is mainly due to the lack of any formal relationship between the Contextual Requirements analysis and the DW conceptual modeling phase. This work is a first step towards the development of a CMCD framework (from Contextual Model to Conceptual Design) that consists of a unified approach to automatically extract the DW multidimensional model from Goal modeling frameworks and Business Process Diagrams. In order to illustrate the feasibility of our approach, we implemented it within a case study related to the development and implementation of a DW to monitor and assess good local governance in Moroccan local municipality offices.
Year
DOI
Venue
2017
10.1109/AFRCON.2017.8095605
2017 IEEE AFRICON
Keywords
Field
DocType
Data warehouse,Goals models,Business process,Requirements analysis,Multidimensional modeling
Data warehouse,Artifact-centric business process model,Data modeling,Business process,Conceptual model,Computer science,Process modeling,Knowledge management,Goal modeling,Business process modeling
Conference
ISSN
Citations 
PageRank 
2153-0025
0
0.34
References 
Authors
7
3
Name
Order
Citations
PageRank
Houda Chakiri100.68
El Mohajir Mohammed263.80
Nasser Assem301.01