Comparing the MOLAP the ROLAP storage models Marysol

Abstract

Data Warehouses (DWs), supported by OLAP, have played a key role in helping company decision-making du- ring 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