Types of Olap

DOLAP: Desktop OLAP. Desktop On-Line Analytic Processing (DOLAP) is single-tier, desktop-based OLAP technology. It is able to download a relatively small hypercube from a central point, usually from data mart or data warehouse, and perform multidimensional analyses while disconnected from the source.

Hybrid online analytical processing (HOLAP) is a combination of relational OLAP and multidimensional OLAP (usually referred to simply as OLAP). HOLAP was developed to combine the greater data capacity of ROLAP with the superior processing capability of OLAP.

There are different types of OLAP systems. Major types of OLAP includes; ROLAP, MOLAP, HOLAP. Other OLAP types of OLAP systems are WOLAP, DOLAP and SOLAP.

Web OLAP which is OLAP system accessible via the web browser. WOLAP is a three-tiered architecture. It consists of three components: client, middleware, and a database server. WOLAP is a three-tiered architecture. It consists of three components: client, middleware, and a database server.

Multidimensional OLAP (MOLAP) uses array-based multidimensional storage engines for multidimensional views of data. With multidimensional data stores, the storage utilization may be low if the dataset is sparse.

There are different types of OLAP systems. Major types of OLAP includes; ROLAP, MOLAP, HOLAP. Other OLAP types of OLAP systems are WOLAP, DOLAP and SOLAP.

Relational OLAP (ROLAP) –Star Schema based. ROLAP products (for Relational OLAP) are credited with being able to directly access data stored in relational databases.

Web OLAP which is OLAP system accessible via the web browser. WOLAP is a three-tiered architecture. It consists of three components: client, middleware, and a database server.