Published

2012-05-01

A chronological study of paradigms for data warehouse design

Estudio cronológico de paradigmas para el diseño de almacenes de datos

Keywords:

Data warehouse, paradigm, chronological study (en)
almacén de datos, paradigma, estudio cronológico (es)

Downloads

Authors

  • Ania Cravero Leal Universidad de la Frontera
  • Samuel Sepúlveda Cuevas Universidad de la Frontera

Data warehouses must homogenise and integrate data from an organisation's areas to extract relevant knowledge for orientating decision-making. This is not an easy task, which is why several approaches have been developed which can be classified according to how information is obtained: supply-driven, demand and a hybrid of the first two. This study offers a conceptual framework and a chronological study of the approaches adopted according to the paradigm used, providing a comprehensive context for better understanding the current state of data warehouses and their evolution.

Los almacenes de datos deben homogeneizar e integrar la información de las diversas áreas de una organización con el fin de extraer conocimiento relevante para la toma de decisiones. Su desarrollo no es tarea fácil, por lo cual se han desarrollado varios enfoques que se pueden clasificar de acuerdo con la forma como se obtienen los requisitos de información: impulsados por la oferta, por la demanda, e híbridos. Este estudio ofrece un marco conceptual y un estudio cronológico de los estos enfoques conforme al paradigma utilizado, lo que proporciona un amplio marco para comprender de mejor manera el estado actual en el área de los almacenes de datos, así como su evolución.

Downloads

Download data is not yet available.

References

Abril, D., Pérez, J., Estado actual de las tecnologías de bodega de datos y OLAP aplicadas a bases de datos espaciales. Ingeniería e Investigación., Vol.27, Nº.1, 2007, pp. 1-12.

Anwer, S., Ikram, N., Goal Oriented Requirement Engineering: A Critical Study of Techniques. APSEC '06 Proceedings of the XIII Asia Pacific Software Engineering Conference., 2006.

Böhnlein, M., Ulbrich-vom, A., Business Process Oriented Development of Data Warehouse Structures. Proceedings of Data Warehousing., Physica Verlag., 2000.

Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A., Paraboschi, F., Designing Data Marts for Data Warehouses. ACM Trans-actions on Software Engineering and Methodology., Vol.10, Nº.4, 2001, pp. 452-483.

Bresciani, P., Giorgini, P., Giunchiglia, F., lopoulos, J.M.-. Perini, A., Tropos: An agent-oriented software development methodology. Journal of Autonomous Agents and Multi-Agent Systems, Vol.8, Nº.3, 2004, pp. 203-236.

BRG, The Business Motivation Model. Business Governance in a Volatile World. http://www.BusinessRulesGroup.org, 2007.

Bubenko, J.A., Extending the Scope of Information Modeling. Proc. 4th Int. Workshop on the Deductive Approach to Information Systems and Databases, Lloret-Costa Brava, Catalonia., 1993, pp. 73-98.

Cabibbo, L., Torlone, R., A Logical Approach to Multidimensional Databases. In H. Schek, F. Saltor, I. Ramos, G. Alonso (Eds.). Proceedings of 6th International Conference on Extending Data-base Technology., Vol.1377, 1998, pp. 183-197.

Cabibbo, L., Torlone, R., Querying multidimensional databases. Journal Database Programming Languages., 1999, pp. 319-335.

Codd, E., Codd, S., Salley, C., Providing OLAP to user-analysts: An IT mandate., E. F. Codd and Associates. Vol.32, 1993.

Cravero, A., Mazón, J.-N., Trujillo, J., Guia de diseño del Almacén de Datos para mejorar el alineamiento de objetivos mediante BMM. Jornadas de Ingeniería de Software y Bases de Datos. JISBD'10. Valencia, España, 2010.

Frolick, M., Winter, K., Critical Factors for Data Warehouse Failure. Business Intelligence Journal http://www.tdwi.org/research/display.aspx?ID=6592, Vol.8, Nº.1, 2003, pp. 61-71.

Giorgini, P., Rizzi, S., Garzetti, M., Goal oriented requirement analysis for data warehouse design. DOLAP'05, Bremen, Germany, nov., Vol.45, 2005, pp. 47-56.

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., Maio, D., Rizzi, S., Conceptual Design of Data Ware-houses from E/R Schemes. System Sciences., 1998.

Golfarelli, M., Rizzi, S., A methodological framework for data ware-house design. Proceedings DOLAP'98., 1998, pp. 3-9.

Inmon, W., Building the Data Warehouse. (2nd ed.). New York etc.: John Wiley & Sons, 1996.

Jacobson, I., Modeling with use Cases-Formalizing use-case modelling. Journal of Object-Oriented Programming., 1995.

Kavakli, E., Goal Oriented Requirements Engineering: A Unifying Framework. Requirements Engineering., Vol.6, Nº.4, 2002, pp. 237-251.

Kimball, R., Reeves, L., Thornthwaite, W., Ross, M., The Data Ware-house Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. John Wiley & Sons, Inc., 1998.

Kimball, R., Ross, M., The Data Warehouse Toolkit, second edition, John Wiley & Sons. 2002.

List, B., Bruckner, R.M., Machaczek, K., Schiefer, J., A Comparison of Data Warehouse Development Methodologies Case Study of the Process Warehouse. In A. Hameurlain, R. Cicchetti, R. Traunmüller (Eds.) Proceedings of 13th International Conference on Database and Expert Systems Applications. Lecture Notes in Computer Science. Aix-en-Provence., Vol.2453, 2002, pp. 203-215.

Mazón, J.N., Pardillo, J., Trujillo, J., A Model Driven Goal Oriented Requirement Engineering Approach for Data Warehouses. Advances in Conceptual Modeling - Foundations and Applications, Springer, 2007, pp. 255-264.

Mazón, J.N., Trujillo, J., Serrano, M., Piattini, M., Designing Data Warehouses: From Business Requirement Analysis to Multidimensional Modeling. REBNITA'05, 2005, pp. 44-53.

Moody, D.-L., From ER Models to Dimensional Models: Bridging the Gap between OLTP and OLAP Design. Journal of Business Intelligence., The Data Warehouse Institute, Vol.8, 2003, pp. 7-24.

Moody, D.L., Kortink, M., From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design. In M. A. Jeusfeld, H. Shu, M. Staudt, G. Vossen (Eds.). Proceedings of 2nd International Workshop on Design and Management of Data Warehouses; pp. Stockholm, Sweden: CEURWS. org., 2000, pp. 6.

Mylopoulos, Goal-Oriented Requirements Engineering Part II. Proceedings of the 14th IEEE International Requirements Engineering Conference., IEEE Computer Society, 2006, pp. 4.

Phipps, C., Davis, K.C., Automating Data Warehouse Conceptual Schema Design and Evaluation. Proceedings of 4th International Workshop on Design and Management of Data Warehouses., Vol.58, 2002, pp. 23-32.

Prakash, N., Gosain, A., An approach to engineering the requirements of data warehouses. Requirements Engineering., Springer, Vol.13, Nº.1, 2008, pp. 49-72.

Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J., Research in Data Warehouse Modeling and Design: Dead or Alive? Proceedings of the 9th ACM international workshop on Data warehousing and OLAP. Arlington, Virginia, USA, ACM, 2006, pp. 3-10.

Romero, O., Abello, A., A survey of Multidimensional Modeling Methodologies. International Journal of Data Warehousing & Mining., Citeseer, Vol.5, Nº.2, 2009, pp. 1-23.

Romero, O., Abelló, A., Multidimensional Design by Examples. Proceedings of 8th International Conference on Data Ware-housing and Knowledge Discovery., Springer, 2006, pp. 85-94.

Silva-Paim, F.-R., F.B. Castro, J., DWARF: An Approach for requirements Definition and Management of Data Warehouse Systems. RE'03, 2003.

Vrdoljak, B., Banek, M., Rizzi, S., Designing Web Warehouses from XML Schemas. Proceedings of 5th International Conference on data Warehousing and Knowledge Discovery., Springer, Vol.2737, 2003, pp. 89-98

Vrdoljak, B., Banek, M., Skokie, Z., Integrating XML sources into a data warehouse. Data Engineering Issues in E-Commerce., 2006, pp. 133-142.

Weir, R., Peng, T., Kerridge, J., Best practice for implementing a data warehouse: A review for strategic alignment. School of Computing, Napier University, 10 Colinton Road, Edinburgh EH10 5DT UK., 2003.

Winter, R., Strauch, B., A method for demand driven information requirements analysis in data warehousing projects., Proceedings of the 36th Annual Hawaii International Conference on. System Sciences, 2003, pp. 9-14.

Wixom, B., Watson, H., An Empirical Investigation of the Factors Affecting Data Warehousing Success. MIS Quarterly., JSTOR, Vol.25, Nº.1, 2001, pp. 17-41.

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.

Yu, E., Mylopoulos, J., From E-R to A-R - Modelling Strategic Actor Relationships for Business Process Reengineering. Entity-Relationship Approach (ER'94) -- Business Modelling and Re-Engineering, Lecture Notes in Computer Science no. 881 Springer-Verlag, 1994, pp. 548-565.

Yu, E., Mylopoulos, J., Why Goal Oriented Requirements Engineering? Proc. 4th Int. Workshop on Requirements Engineering for Software Quality, Foundations of Software, Quality - REFSQ., Pisa, Presses Universitaires de Namur., 1998, pp. 15-22.

License

Copyright (c) 2012 Ania Cravero Leal, Samuel Sepúlveda Cuevas

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.