A business-oriented approach to data warehouse development

• Autores: Ania Cravero Leal , José-Norberto Mazón López , Juan Trujillo Mondéjar
• Localización: Ingeniería e Investigación, ISSN-e 2248-8723, ISSN 0120-5609, Vol. 33, Nº. 1, 2013, págs. 59-65
• Idioma: inglés
• Títulos paralelos:
  • Enfoque orientado al negocio para el desarrollo del almacén de datos
• Enlaces
  • Texto completo (pdf)
• Dialnet Métricas: 2 Citas
• Resumen
  • español

    Varios trabajos indican que un porcentaje significativo de los almacenes de datos no cumplen con los objetivos del negocio o que son fracasos rotundos. Una de las razones consiste en que la ingeniería de requerimientos es pasada por alto en proyectos reales.En este trabajo el diseño del almacén de datos es abordado desde un punto de vista empresarial, en el que se da relevancia al análisis de la estrategia del negocio, la alineación entre los objetivos del almacén de datos y la estrategia de la empresa, un modelo de objetivos que permite obtener los requisitos de información y la derivación del modelo multidimensional del almacén. Proveemos un conjunto de directrices que permite a los desarrolladores diseñar un almacén de datos alineado a la estrategia del negocio. Se presenta un caso de estudio clásico.

  • English

    Several surveys have indicated that many data warehouses fail to meet business objectives or are outright failures. One reason for this is that requirement engineering is typically overlooked in real projects. This paper addresses data warehouse design from a business perspective by highlighting business strategy analysis, alignment between data warehouse objectives and a firm’s strategy, goal-orientated information requirements’ modelling and how an underlying multidimensional data warehouse model may be derived. A set of guidelines is provided allowing developers to design a data warehouse aligned with a prevailing business strategy. A classic case study is presented.

• Referencias bibliográficas
  • Andersson, B., Bergholtz, M., Edirisuriya, A., Ilayperuma, T., Johannesson, P., Zdravkovic, J., On the Alignment of Goal Models and Business...
  • Berkem., B., How to align IT with the changes using UML and according to BMM? Applying the "Goal Driven Development" Process on a...
  • Bleistein, S., Cox, K., Verner, J., Validating strategic alignment of organizational IT requirements using goal modeling and problem diagrams....
  • Cravero, A., Sepúlveda, S., A chronological study of paradigms for data warehouse design. Revista Ingeniería e Investigación, Vol.32, No.2,...
  • Cravero, A., Sepúlveda, S., Mazón, J.-N., Trujillo, J., 2010. Alineamiento de Objetivos de la Organización: una necesidad para el análisis...
  • Donzelli, P., A goal-driven and agent-based requirements engineering framework. Req. Eng., No.9, 2004, pp. 16-39.
  • Ellis-Braithwaite, R., Lock, R., Dawson, R., Haque, B., Modelling the Strategic Alignment of Software Requirements using Goal Graphs. arXiv...
  • Franch, X., Grau, G., Mayol, E., Quer, C., Ayala, C., Cares, C., Navarrete, F., Haya, M., Botella, P., Systematic Construction of I* Strategic...
  • Giorgini, P., Rizzi, S., Garzetti, M., Grand: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems,...
  • Golfarelli, M., From User Requirements to Conceptual Design in Data Warehouse Design-a Survey. DEIS - University of Bologna, 2010.
  • Gupta, V., Chauhan, A., Kumar, A., Taneja, S., 2011. UREM-A UML-Based Requirement Engineering Model for a Data Warehouse, Proceedings of the...
  • Kimball, R., Ross, M., The Data Warehouse Toolkit, second edition, John Wiley & Sons. 2002.
  • Luján-Mora S., T.J., Song I-Y., Multidimensional modeling with UML package diagrams. 21st Intl. Conference on Conceptual Modelling (ER2002),...
  • Mate, A., Trujillo, J., Franch, X., 2011. A modularization proposal for goal-oriented analysis of data warehouses using i-star, Conceptual...
  • Mazón, J., Trujillo, J., Lechtenbörger, J., Reconciling requirement driven data warehouses with data sources via multidimensional normal forms"....
  • Paim, F.R.S., Castro, J.B., DWARF: approach for requirements definition and management of data warehouse systems. Requirements Engineering....
  • Prakash, N., Singh, Y., Gosain, A., Information scenarios for data warehouse requirements elicitation. 23th Intl. Conference on Conceptual...
  • Mazón, J.N., Pardillo, J., Trujillo, J., A Model Driven Goal Oriented Requirement Engineering Approach for Data Warehouses. In: ER Workshops...
  • Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M., Designing Data Warehouses: From Business Requirement Analysis to Multidimensional Modeling....
  • Mette, A., Grønhaug, K., Vegard, T., Requirements Specifications for Data Warehouses. Journal NOKOBIT, Akademika forlag, ISBN 978-82-321-0185-6,...
  • OMG, The Business Motivation Model. version 1.1. http://www.omg.org/spec/BMM/, 2010.Sarkar, A., Data Warehouse Requirements Analysis Framework:...
  • Simonin, J., Bigaret, S., Gourmelen, J., 2012. A data warehouse logical design method based on the alignment with business processes, Research...
  • Singh, S., C. Woo, Investigating business-IT alignment through multidisciplinary goal concepts. Requirements Engineering, Vol.14, No.3, 2009,...
  • Sondhi, R., Total Strategy. Airworthy Publications International Limited, Great Britain., 1999.
  • Thevenet, L.-H., Salinesi, C., A. Etien, Gam, I., Lassoued, M., Experimenting a Modeling Approach for Designing Organization's Strategies,...
  • Yu, E., Modelling Strategic Relationships for Process Reengineering. PhD thesis, Computer Science Department, University of Toronto, Toronto...