Publicação
Support of operational processes in the Data Warehouse: the gap between theory and practice
| Resumo: | Data Warehouses have been traditionally accepted as a subject-oriented, integrated, non-volatile, time-variant collection of data in support of management's decisions. They support the process of top and middle management decision-making and the organization's strategic planning processes. Their use to support operational data requirements as well has been somehow controversial by being either supported or criticized by different authors. This thesis focuses on the identification, for a Data Warehouse containing some level of operational activities, of the reasons that may be driving this kind of activities into the Data Warehouse. The thesis is made up of two parts. The first part departed from a literature review of Data Warehouse concepts, its characteristics, its usage and its role into organizations to the general opinion concerning the support of operational activities in Data Warehouse environments. The second part describes a single case study used to search for evidences of operational support in a Data Warehouse environment and to identify possible reasons that may be forcing the Data Warehouse to support operational activities. The research findings show that, for the specific case of the organization studied, there is evidence of the support of operational activities in the organization's Data Warehouse and some evidence was collected concerning the reasons that motivate the localization of these activities. Finally, we will discuss findings and opportunities for further research. |
|---|---|
| Autores principais: | Carvalho, Ana Margarida de Almeida Bastos |
| Assunto: | Data Mart Data Warehouse Data Warehousing Operational Data Store Operational and Analytical Requests |
| Ano: | 2007 |
| País: | Portugal |
| Tipo de documento: | dissertação de mestrado |
| Tipo de acesso: | acesso restrito |
| Instituição associada: | Universidade de Lisboa |
| Idioma: | inglês |
| Origem: | Repositório da Universidade de Lisboa |
| Resumo: | Data Warehouses have been traditionally accepted as a subject-oriented, integrated, non-volatile, time-variant collection of data in support of management's decisions. They support the process of top and middle management decision-making and the organization's strategic planning processes. Their use to support operational data requirements as well has been somehow controversial by being either supported or criticized by different authors. This thesis focuses on the identification, for a Data Warehouse containing some level of operational activities, of the reasons that may be driving this kind of activities into the Data Warehouse. The thesis is made up of two parts. The first part departed from a literature review of Data Warehouse concepts, its characteristics, its usage and its role into organizations to the general opinion concerning the support of operational activities in Data Warehouse environments. The second part describes a single case study used to search for evidences of operational support in a Data Warehouse environment and to identify possible reasons that may be forcing the Data Warehouse to support operational activities. The research findings show that, for the specific case of the organization studied, there is evidence of the support of operational activities in the organization's Data Warehouse and some evidence was collected concerning the reasons that motivate the localization of these activities. Finally, we will discuss findings and opportunities for further research. |
|---|