IADIS International Journal on Computer Science and Information Systems

Published by IADIS (International Association for Development of the Information Society) • ISSN (Online): 1646-3692 • ISSN (Print): 1646-3692
100% Open Access
Double-Blind Peer Review
Crossref DOI Persistent IDs
Open Access Peer-Reviewed Case Studies & Applications

A Multi-driven Approach to Requirements Analysis of Data Warehouse Model: a Case Study

Jorge Oliveira e Sá *
Centro Algoritmi *
University of Minho *
Campus de Azurém *
Guimarães Researcher *
* Portugal Claus Kaldeich, Lecturer & Head of the Center for Strategic Intelligence, Innovation, R&D, Technical Trainers College, Riyadh, Kingdom of Saudi Arabia. Technical and Vocational Training Corporation (TVTC), Saudi Arabia and Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Germany João Álvaro Carvalho, Centro Algoritmi, University of Minho, Campus de Azurém, Guimarães, Portugal (Portugal)
* Portugal Claus Kaldeich, Lecturer & Head of the Center for Strategic Intelligence, Innovation, R&D, Technical Trainers College, Riyadh, Kingdom of Saudi Arabia. Technical and Vocational Training Corporation (TVTC), Saudi Arabia and Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Germany João Álvaro Carvalho, Centro Algoritmi, University of Minho, Campus de Azurém, Guimarães, Portugal (Portugal)
* Portugal Claus Kaldeich, Lecturer & Head of the Center for Strategic Intelligence, Innovation, R&D, Technical Trainers College, Riyadh, Kingdom of Saudi Arabia. Technical and Vocational Training Corporation (TVTC), Saudi Arabia and Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Germany João Álvaro Carvalho, Centro Algoritmi, University of Minho, Campus de Azurém, Guimarães, Portugal (Portugal)
* Portugal Claus Kaldeich, Lecturer & Head of the Center for Strategic Intelligence, Innovation, R&D, Technical Trainers College, Riyadh, Kingdom of Saudi Arabia. Technical and Vocational Training Corporation (TVTC), Saudi Arabia and Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Germany João Álvaro Carvalho, Centro Algoritmi, University of Minho, Campus de Azurém, Guimarães, Portugal (Portugal)
* Portugal Claus Kaldeich, Lecturer & Head of the Center for Strategic Intelligence, Innovation, R&D, Technical Trainers College, Riyadh, Kingdom of Saudi Arabia. Technical and Vocational Training Corporation (TVTC), Saudi Arabia and Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Germany João Álvaro Carvalho, Centro Algoritmi, University of Minho, Campus de Azurém, Guimarães, Portugal (Portugal)

Abstract

In this paper, a multi -driven approach to data modeling in data warehousing will be presented, which integrates three existing approaches normally used separately: goal -driven, user-driven and data -driven; and two approaches usually not used in data warehousing field: process-driven and technology-driven. Goal-driven approach produces subjects and KPI ’s (Key Performance Indicators) of main business fields. User-driven approach produces analytical requirements represented by measures and dimensions of each subject. Process -driven approach propose improvements in business processes (by using and creating subject oriented enterprise data model) to satisfy the KPI ’s, measures and dimensions identified in the previous approaches. Technology-driven approach is an enabler or an obstacle to be considered in a data warehouse model. Data -driven approach is a combination of the results of previous approaches and results in a data warehouse model. By using a multi-driven approach with five stages, a layered data warehouse model more a ligned with business and individual needs can be obtained . This will be illustrated by using examples of a case study.

Keywords

Requirement Analysis Data Warehouse Model Case Study.
Full-Text PDF Available

Read Complete Peer-Reviewed Manuscript

Includes full econometric models, data tables, policy recommendations, declarations, and citations.

Declarations & Ethics

Funding: This research received academic dissemination support through ESCAP / JournalsHub publishing programs.
Conflicts of Interest: The authors declare no competing financial or institutional interests.
Peer Review: Double-blind peer reviewed by international subject specialists.
License: Creative Commons Attribution 4.0 International (CC BY 4.0).
How to Cite This Article
APA / MLA / BibTeX
Sá, et al. (2013). A Multi-driven Approach to Requirements Analysis of Data Warehouse Model: a Case Study. IADIS International Journal on Computer Science and Information Systems, 8(1). https://doi.org/10.33965/ijcsis_2013_v8i1_03
Sá, et al. "A Multi-driven Approach to Requirements Analysis of Data Warehouse Model: a Case Study." IADIS International Journal on Computer Science and Information Systems, vol. 8, no. 1, 2013. https://doi.org/10.33965/ijcsis_2013_v8i1_03
Sá, et al. "A Multi-driven Approach to Requirements Analysis of Data Warehouse Model: a Case Study." IADIS International Journal on Computer Science and Information Systems 8, no. 1 (2013). https://doi.org/10.33965/ijcsis_2013_v8i1_03