Comparing the MOLAP the ROLAP storage models
Marysol Tamayo, Francisco Javier Moreno Arboleda · Ingeniería e Investigación · 2006
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.