Comparing the MOLAP the ROLAP storage models
Análisis del modelo de almacenamiento MOLAP frente al modelo de almacenamiento ROLAP
DOI:
https://doi.org/10.15446/ing.investig.v26n3.14764Keywords:
data warehouse, OLAP, MOLAP, ROLAP (en)data warehouse, OLAP, MOLAP, ROLAP (es)
Downloads
Data Warehouses (DWs), supported by OLAP. have played a key role in helping company decision-making during the last few years. DWs can be stored in ROLAP and/or MOLAP data storage systems. Data is stored in a relational database in ROLAP and in multidimensional matrices in MOLAP. This paper presents a comparative example, analysing the performance and advantages and disadvantages of ROLAP and MOLAP in a specific database management system (DBMS). An overview of DBMS is also given to see how these technologies are being incorporated.
En los últimos años los Data Warehouses (DW) en conjunto con OLAP se han constituido en elementos de ayuda en las organizaciones para la toma de decisiones. Con los tipos de almacenamiento de datos ROLAP y MOLAP se pueden crear los DW. El primero almacena los datos sobre una base de datos relacional. El tipo de almacenamiento MOLAP en matrices multidimensionales. En este artículo se presenta un ejemplo comparativo que permite analizar el rendimiento, las ventajas y desventajas entre estos dos tipos de almacenamiento en un sistema de gestión de base de datos (SGBD) específico. Adicionalmente se ofrece un panorama que permite observar cómo los SGBDs están incorporando hoy en día estas tecnologías dentro de sus principales funcionalidades.
References
Audifilm Grupo Brime., Oracle Express technology., Reporte técnico, 2003.
Chaudhuri, S. and Dayal, U., An overview of data warehousing and OLAP technology., SIGMOD Record, 1997. DOI: https://doi.org/10.1145/248603.248616
Date, C. J., Introducción a los sistemas de bases de datos., Prentice Hall, 2001.
Elmasri, R. and Navathe, S., Fundamentals of database systems., Addison Wesley, 2006.
Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Rei chart, D., Venkatrao, M., Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub-totals., Data Mining and Knowledge Discovery, 1997.
Gupta, A. and Mumick, I., Materialized views: techniques, implementations, and applications., The MIT Press, Massachusetts, 1999. DOI: https://doi.org/10.7551/mitpress/4472.001.0001
Hyperion., Hyperion Essbase OLAPServer., Reporte técnico, 2002.
Ibarra, M., Procesamiento analítico en línea., Universidad Nacional del Nordeste Corrientes Argentina, Reporte técnico, 2005.
Ibarzabal, J., Estrategia de reporting., Cedyc S.Coop., Sangroniz, 2003.
Inmon, W. H., Building the data warehouse., John Wiley & Sons, New York, 1996.
Kimball, R. and Ross, M., The data warehouse toolkit: the complete guide to dimensional modelling., John Wiley & Sons, New York, 2002.
Lehner, W., Albrecht, H. and Wedekind, H., Normal forms for multidimensional databases., Proc. 10th International Conference on Scientific and Statistical Database Management (SSDBM), 1998.
Microsoft Corporation., Servicios de ayuda a la toma de decisiones de Microsoft SQL Server 7.0., Reporte técnico, 2003.
Microsoft Corporation 2., MSDN Library: MDX Language., Reporte técnico, 2004.
Nader, J., Sistema de apoyo gerencial universitario., Tesis presentada al Instituto Tecnológico de Buenos Aires, para optar al grado de magíster en Ingeniería del Software, 2003.
NewTec Ediciones., SQL Server 7.0 y OLAP Server., Reporte técnico, Barcelona, 2002.
Oracle Corporation., Oracle materialized views and query rewrite., Informe Técnico Oracle Corporation, 2005.
How to Cite
APA
ACM
ACS
ABNT
Chicago
Harvard
IEEE
MLA
Turabian
Vancouver
Download Citation
License
Copyright (c) 2006 N Tamayo, Francisco Javier Moreno Arboleda
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.