MOLAP Multidimensional Online Analytical processing

In MOLAP data is stored in form of multidimensional cubes and not in relational databases.

Advantage

Excellent query performance as the cubes have all calculations pre-generated during creation of the cube.

Disadvantages

It can handle only a limited amount of data. Since all calculations have been pre-generated, the cube cannot be created from a large amount of data.

It requires huge investment as cube technology is proprietary and the knowledge base may not exist in the organization.

ROLAP Relational Online Analytical processing

The data is stored in relational databases.

Advantages

It can handle a large amount of data and

It provides all the functionalities of the relational database.

Disadvantages

It is slow.

The limitations of the SQL apply to the ROLAP too.

HOLAP Hybrid Online Analytical processing

HOLAP is a combination of the above two models. It combines the advantages in the following manner:

For summarized information it makes use of the cube.

For drill down operations, it uses ROLAP.