A business-oriented approach to data warehouse development

  1. Cravero Leal, Ania
  2. Mazón, Jose Norberto
  3. Trujillo, Juan
Journal:
Ingeniería e Investigación

ISSN: 0120-5609

Year of publication: 2013

Volume: 33

Issue: 1

Pages: 59-65

Type: Article

DIALNET GOOGLE SCHOLAR lock_openDialnet editor

More publications in: Ingeniería e Investigación

Abstract

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.

Bibliographic References

  • Andersson, B., Bergholtz, M., Edirisuriya, A., Ilayperuma, T., Johannesson, P., Zdravkovic, J., On the Alignment of Goal Models and Business Models. A Celebration of the REA'07 Enterprise Model, Geerts, G., University of Delaware. Department of Accounting, 2007.
  • Berkem., B., How to align IT with the changes using UML and according to BMM? Applying the "Goal Driven Development" Process on a case study using UML 2 and the BMM. Journal of Object Technology. Chair of Software Engineering., Vol.5, No.2, 2006.
  • Bleistein, S., Cox, K., Verner, J., Validating strategic alignment of organizational IT requirements using goal modeling and problem diagrams. The Journal of Systems and Software, Vol.79, 2006, pp. 362-378.
  • Cravero, A., Sepúlveda, S., A chronological study of paradigms for data warehouse design. Revista Ingeniería e Investigación, Vol.32, No.2, 2012, pp. 58-62.
  • 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 de requisitos en almacenes de datos, Congreso Iberoamericano de Software Engineering. CIBSE2010, pp. 10-15.
  • 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 preprint arXiv:1211.6258, 2012.
  • Franch, X., Grau, G., Mayol, E., Quer, C., Ayala, C., Cares, C., Navarrete, F., Haya, M., Botella, P., Systematic Construction of I* Strategic Dependency Models for Socio-technical Systems. International Journal of Software Engineering and Knowledge Engineering. Vol.17, No.1, 2007, pp. 79-106.
  • Giorgini, P., Rizzi, S., Garzetti, M., Grand: A goal-oriented approach to requirement analysis in data warehouses. Decision Support Systems, Vol.45, 2008, pp. 4 - 21.
  • 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 5th National Conference; INDIACom-201, Computing For Nation Development, New Delhi, India.
  • 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), Springer-Verlag, Vol.2503 of LNCS, 2002, pp. 199-213.
  • Mate, A., Trujillo, J., Franch, X., 2011. A modularization proposal for goal-oriented analysis of data warehouses using i-star, Conceptual Modeling-ER 2011. Springer, pp. 421-428.
  • Mazón, J., Trujillo, J., Lechtenbörger, J., Reconciling requirement driven data warehouses with data sources via multidimensional normal forms". Data and Know, Eng., Vol.63, No.3, 2007a, pp. 725-751.
  • Paim, F.R.S., Castro, J.B., DWARF: approach for requirements definition and management of data warehouse systems. Requirements Engineering. Conference,. 2003. Proceedings. 11th IEEE International. RE'03, 2003, pp. 75-84.
  • Prakash, N., Singh, Y., Gosain, A., Information scenarios for data warehouse requirements elicitation. 23th Intl. Conference on Conceptual Modelling (ER2004). Vol.3288, 2004, pp. 205-216.
  • Mazón, J.N., Pardillo, J., Trujillo, J., A Model Driven Goal Oriented Requirement Engineering Approach for Data Warehouses. In: ER Workshops (RIGiM), 2007b.
  • Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M., Designing Data Warehouses: From Business Requirement Analysis to Multidimensional Modeling. REBNITA, 2005, pp. 44-53.
  • Mette, A., Grønhaug, K., Vegard, T., Requirements Specifications for Data Warehouses. Journal NOKOBIT, Akademika forlag, ISBN 978-82-321-0185-6, 2012.
  • OMG, The Business Motivation Model. version 1.1. http://www.omg.org/spec/BMM/, 2010.Sarkar, A., Data Warehouse Requirements Analysis Framework: Business-Object Based Approach. (IJACSA) International Journal of Advanced Computer Science and Applications, Vol.3, No.1, 2012, pp. 25-34.
  • Simonin, J., Bigaret, S., Gourmelen, J., 2012. A data warehouse logical design method based on the alignment with business processes, Research Challenges in Information Science (RCIS), 2012 Sixth International Conference. IEEE, pp. 1-12.
  • Singh, S., C. Woo, Investigating business-IT alignment through multidisciplinary goal concepts. Requirements Engineering, Vol.14, No.3, 2009, pp. 177-207.
  • 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, in the Context of Strategic Alignment. Return to Published Papers, 2006.
  • Yu, E., Modelling Strategic Relationships for Process Reengineering. PhD thesis, Computer Science Department, University of Toronto, Toronto (Canada). Phd thesis, also appears as Technical Report DKBS-TR-94-6, December 1994., 1995.
Data source: Dialnet