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. Therefore, many MOLAP servers use two levels of data storage representation to handle dense and sparse datasets.
MOLAP tools process information with consistent response time regardless of level of summarizing or calculations selected.
MOLAP tools need to avoid many of the complexities of creating a relational database to store data for analysis.
MOLAP tools need fastest possible performance.
MOLAP server adopts two level of storage representation to handle dense and sparse data sets.
Denser sub-cubes are identified and stored as array structure.
Sparse sub-cubes employ compression technology.
MOLAP includes the following components −
|1||Information retrieval is fast.||Information retrieval is comparatively slow.|
|2||Uses sparse array to store data-sets.||Uses relational table.|
|3||MOLAP is best suited for inexperienced users, since it is very easy to use.||ROLAP is best suited for experienced users.|
|4||Maintains a separate database for data cubes.||It may not require space other than available in the Data warehouse.|
|5||DBMS facility is weak.||DBMS facility is strong.|