ROLAP (Relational Online Analytical PROCESSING) : ROLAP does not have the high latency disadvantage of MOLAP. With ROLAP, the data and AGGREGATIONS are stored in relational FORMAT. This means that there will be zero latency between the relational source database and the cube.

Disadvantage of this mode is the performance, this type gives the poorest query performance because no objects benefit from multi dimensional storage.

Advantages:

• Since the data is kept in the relational database instead of on the OLAP server, you can view the data in almost REAL TIME.
• Also, since the data is kept in the relational database, it allows for much larger amounts of data, which can mean better scalability.
• Low latency.

ROLAP (Relational Online Analytical Processing) : ROLAP does not have the high latency disadvantage of MOLAP. With ROLAP, the data and aggregations are stored in relational format. This means that there will be zero latency between the relational source database and the cube.

Disadvantage of this mode is the performance, this type gives the poorest query performance because no objects benefit from multi dimensional storage.

Advantages: