Title:
|
A MULTI-DRIVEN APPROACH TO REQUIREMENTS ANALYSIS OF DATA WAREHOUSE SCHEMA: A CASE STUDY |
Author(s):
|
Jorge Oliveira e Sá, João Álvaro Carvalho, Claus Kaldeich |
ISBN:
|
978-989-8533-14-2 |
Editors:
|
Hans Weghorn and Pedro Isaías |
Year:
|
2012 |
Edition:
|
Single |
Keywords:
|
Requirement Analysis, Data Warehouse Design, Case Study. |
Type:
|
Full Paper |
First Page:
|
42 |
Last Page:
|
50 |
Language:
|
English |
Cover:
|
|
Full Contents:
|
click to dowload
|
Paper Abstract:
|
In this paper, we present a multi-driven approach to data modeling in data warehousing 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 KPIs (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 schema) to satisfy the KPIs, measures and dimensions identified in the previous approaches. Technology-driven approach is an enabler or an obstacle to be considered when we model a data warehouse data model. Data-driven approach is a combination of the results of previous approaches and results in a data model of a data warehouse. By using a multi-driven approach with five stages, we can get a layered data warehouse model more aligned with organizational and individual needs. This will be illustrated by using examples of our case study |
|
|
|
|