Published

2013-01-01

A business-oriented approach to data warehouse development

Enfoque orientado al negocio para el desarrollo del almacén de datos

Keywords:

Data warehouse, business-orientated, alignment. (en)
almacén de datos, orientado al negocio, alineamiento (es)

Downloads

Authors

  • Ania Cravero Leal Universidad de La Frontera
  • Jose Norberto Mazón Universidad de Alicante
  • Juan Trujillo Universidad de Alicante

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-oriented 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.

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.

Downloads

Download data is not yet available.

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.

License

Copyright (c) 2013 Ania Cravero Leal, Jose Norberto Mazón, Juan Trujillo

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

The authors or holders of the copyright for each article hereby confer exclusive, limited and free authorization on the Universidad Nacional de Colombia's journal Ingeniería e Investigación concerning the aforementioned article which, once it has been evaluated and approved, will be submitted for publication, in line with the following items:

1.    The version which has been corrected according to the evaluators' suggestions will be remitted and it will be made clear whether the aforementioned article is an unedited document regarding which the rights to be authorized are held and total responsibility will be assumed by the authors for the content of the work being submitted to Ingeniería e Investigación, the Universidad Nacional de Colombia and third-parties;

2.    The authorization conferred on the journal will come into force from the date on which it is included in the respective volume and issue of Ingeniería e Investigación in the Open Journal Systems and on the journal's main page (https://revistas.unal.edu.co/index.php/ingeinv), as well as in different databases and indices in which the publication is indexed;

3.    The authors authorize the Universidad Nacional de Colombia's journal Ingeniería e Investigación to publish the document in whatever required format (printed, digital, electronic or whatsoever known or yet to be discovered form) and authorize Ingeniería e Investigación to include the work in any indices and/or search engines deemed necessary for promoting its diffusion;

4.    The authors accept that such authorization is given free of charge and they, therefore, waive any right to receive remuneration from the publication, distribution, public communication and any use whatsoever referred to in the terms of this authorization.