Publicação
A method for requirements elicitation of a data warehouse : an example
| Resumo: | This paper presents a method with a combination of diverse approaches for requirement elicitation of a Data Warehouse (DW) schema model. This method integrates five approaches: goal-driven, user-driven, process driven, technology-driven, and data driven. This method includes two approaches not usually used in the DW field: process-driven and technology driven. The role of each approach is: goal-driven produces subjects (DW processes) and KPI’s (Key Performance Indicators) of main business fields; user-driven produces analytical requirements represented by measures and dimensions of each subject; process-driven propose improvements in business processes (by using and creating subject oriented enterprise data model) to satisfy KPI’s, measures and dimensions identified in the previous approaches; technology driven is an enabler or an obstacle to be considered in a DW; and data-driven is a combination of the results of previous approaches and results in a DW schema. By using a method with five approaches, a layered DW schema aligned with business and individual needs can be obtained. This will be illustrated by using examples. |
|---|---|
| Autores principais: | Sá, Jorge Vaz de Oliveira e |
| Assunto: | Requirement elicitation Data Warehouse Schema Model EPC ADAPT Data Warehouse Approaches |
| Ano: | 2014 |
| País: | Portugal |
| Tipo de documento: | comunicação em conferência |
| Tipo de acesso: | acesso restrito |
| Instituição associada: | Universidade do Minho |
| Idioma: | inglês |
| Origem: | RepositóriUM - Universidade do Minho |
| Resumo: | This paper presents a method with a combination of diverse approaches for requirement elicitation of a Data Warehouse (DW) schema model. This method integrates five approaches: goal-driven, user-driven, process driven, technology-driven, and data driven. This method includes two approaches not usually used in the DW field: process-driven and technology driven. The role of each approach is: goal-driven produces subjects (DW processes) and KPI’s (Key Performance Indicators) of main business fields; user-driven produces analytical requirements represented by measures and dimensions of each subject; process-driven propose improvements in business processes (by using and creating subject oriented enterprise data model) to satisfy KPI’s, measures and dimensions identified in the previous approaches; technology driven is an enabler or an obstacle to be considered in a DW; and data-driven is a combination of the results of previous approaches and results in a DW schema. By using a method with five approaches, a layered DW schema aligned with business and individual needs can be obtained. This will be illustrated by using examples. |
|---|