Abstract

TAMAYO, Marysol  and  MORENO, Francisco Javier. Comparing the MOLAP the ROLAP storage models. Ing. Investig. [online]. 2006, vol.26, n.3, pp.135-142. ISSN 0120-5609.

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.

Keywords : data warehouse; OLAP; MOLAP; ROLAP.

        · abstract in Spanish     · text in Spanish     · Spanish ( pdf )