Various types of OLAP

Explain various types of the OLAP?

E

Expert

Verified

a) ROLAP or Relational OLAP - Users generally see their data organized within the cubes and dimensions  however, the data is really stored within the RDBMS. The performance is generally slow. A storage mode that uses tables in the relational database in order to store the multidimensional structures.

b) MOLAP or multidimensional OLAP – In this the data is organized in the cubes and dimensions however the data is really stored within the MDBMS. In this performance of the Query is fast.

c) HOLAP or Hybrid OLAP - It is combination of the ROLAP and HOLAP. Like HOLOs. In this, one will find the data queries on the aggregated data as well as the detailed data.

   Related Questions in Biology

©TutorsGlobe All rights reserved 2022-2023.