A Methodology for Data Warehouse Development
Abstract
A data warehouse project is a great and complex task whose success is closely related to the understanding of the several steps that compose the development process of such environments. In this job we show a methodology for data warehouse design whose main objective is a proposition of lines of direction that guide the designer during the whole process. The main advantages of this proposal in relation of others available in literature are its applicability, completeness and the ability to use a development tool during the whole process. A case study is used to show the methodology and to facilitate its understanding.
Keywords:
Data warehouse, Development methodology, IBM DB2, Database
References
Kelly, S., The Data Warehouse Toolkit, John Wiley & Sons Inc., 1997.
Dill, Sergio Luis. Uma Metodologia para Desenvolvimento de DW e Estudo de Caso, Dissertação de Mestrado, UFSC, Florianópolis, 2002.
Golfarelli, M. and Rizzi, S. “A methodological framework for DW Design”. DOLAP 98 Washington, D.C., USA.
Herdem, O. (2000) “A Design Methodology for DWs”. Oldemburg Research and Development Institute for Computer Science Tools and Systems (OFFIS). Oldenburg, Germany.
Moody, D. L. and Kortnik, M. A.R. “From Enterprise Models to Dimensional Models: A Methodology for DW and Data mart Design”. (DMDW2000).
Ballard, C.; Herreman D. and Schau D.;et al. Data Modeling Techniques for Data Warehousing. IBM – ITSO redbooks, 1998.
Bohnlein, M. and Ende A. Deriving Initial DW Structures from the Conceptual Data Models of the Underlying Operational Information Systems. Ulbrich-vom. Kansas City Mo USA, 1999.
Sapia, C., Blaskhka, M., Hofling, G. and Dinter, B. Extending the E/R Model for the Multidimensional Paradigm. Proc of International Workshop on DW and Data Mining, November 1998.
Kimball, R., Data Warehouse Toolkit, Makron Books, 1998.
Hayes, S and Gunning, P. “Tunning Up for OLTP and data warehousing. DB2 Magazine.Vol 7 Num 3”, 2002.
Dill, Sergio Luis. Uma Metodologia para Desenvolvimento de DW e Estudo de Caso, Dissertação de Mestrado, UFSC, Florianópolis, 2002.
Golfarelli, M. and Rizzi, S. “A methodological framework for DW Design”. DOLAP 98 Washington, D.C., USA.
Herdem, O. (2000) “A Design Methodology for DWs”. Oldemburg Research and Development Institute for Computer Science Tools and Systems (OFFIS). Oldenburg, Germany.
Moody, D. L. and Kortnik, M. A.R. “From Enterprise Models to Dimensional Models: A Methodology for DW and Data mart Design”. (DMDW2000).
Ballard, C.; Herreman D. and Schau D.;et al. Data Modeling Techniques for Data Warehousing. IBM – ITSO redbooks, 1998.
Bohnlein, M. and Ende A. Deriving Initial DW Structures from the Conceptual Data Models of the Underlying Operational Information Systems. Ulbrich-vom. Kansas City Mo USA, 1999.
Sapia, C., Blaskhka, M., Hofling, G. and Dinter, B. Extending the E/R Model for the Multidimensional Paradigm. Proc of International Workshop on DW and Data Mining, November 1998.
Kimball, R., Data Warehouse Toolkit, Makron Books, 1998.
Hayes, S and Gunning, P. “Tunning Up for OLTP and data warehousing. DB2 Magazine.Vol 7 Num 3”, 2002.
Published
2005-10-26
How to Cite
DILL, Sergio Luis; DE ABREU, Aline França; PADOIN, Edson Luis; KELM, Martinho Luis.
A Methodology for Data Warehouse Development. In: BRAZILIAN SYMPOSIUM ON INFORMATION SYSTEMS (SBSI), 2. , 2005, Florianópolis.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2005
.
p. 135-142.
DOI: https://doi.org/10.5753/sbsi.2005.14977.
