There are three main types of OLAP, which include:
MOLAP: As the abbreviation for Multi-dimensional Online Analytical Processing, MOLAP contains data that is precomputed and fabricated from existing cubes. A MOLAP system will have a database server from which to collect data, a MOLAP server that hosts the data cubes, and a front-end tool where users see the answers to their queries presented.
ROLAP: Relational Online Analytical Processing is a type of analytical processing where the data storage is done in a relational database management system (RDBMS). There it is arranged in columns and rows. As a user, you’ll see the data represented in multi-dimensional form when the ROLAP engine creates data cubes dynamically to answer your question.
HOLAP: Hybrid Online Analytical Processing is designed to solve the limitations of ROLAP and MOLAP by combining their attributes. Your database will be divided into two parts — relational storage and specialized storage — and then integrated to address issues with scalability and performance.