Information About

Molap
  CATEGORIES ABOUT MOLAP
   
olap
   
APPAREL
BABY
BEAUTY
BOOKS
CAR TOYS
CELL PHONES
DVD'S
ELECTRONICS
GOURMET FOOD
GROCERIES
HEALTH & PERSONAL
HOME & GARDEN
JEWELRY
MUSIC
MUSIC INSTRUMENTS
OFFICE PRODUCTS
SOFTWARE
SPORTING GOODS
TOOLS & HARDWARE
TOYS
VIDEO GAMES
SHOPPING HOME
MORE SHOPPING...



Please review the discussion page before making changes to the advantages or disadvantages. Thank you.
-->

MOLAP stands for Multidimensional '''O'''n'''l'''ine '''A'''nalytical '''P'''rocessing.

MOLAP is an alternative to the ROLAP (Relational OLAP ) technology. While both ROLAP and MOLAP analytic tools are designed to allow analysis of data through the use of a Multidimensional Data Model , MOLAP differs significantly in that it requires the pre-computation and storage of information in the cube - the operation known as ''processing''. MOLAP stores this data in an optimized multi-dimensional array storage, rather than in a Relational Database (i.e. in ROLAP )


MOLAP VS. ROLAP



Advantages


  • Fast query performance due to optimized storage, multidimensional indexing and caching.


  • Smaller on-disk size of data compared to data stored in Relational Database due to compression techniques.


  • Automated computation of higher level aggregates of the data.


  • It is very compact for low dimension data sets.


  • Array model provides natural indexing



Disadvantages


  • The processing step (data load) can be quite lengthy, especially on large data volumes. This is usually remedied by doing only incremental processing, i.e., processing only the data which has changed (usually new data) instead of reprocessing the entire data set.


  • MOLAP tools traditionally have difficulty querying models with dimensions with very high Cardinality (i.e., millions of members).


  • Certain MOLAP tools (e.g., Essbase ) have difficulty updating and querying models with more than ten Dimensions . This limit differs depending on the complexity and Cardinality of the dimensions in question. It also depends on the number of facts or measures stored. Other MOLAP tools (e.g., Microsoft Analysis Services ) can handle hundreds of dimensions.



TRENDS


Most commercial OLAP tools now use a "Hybrid OLAP" ( HOLAP ) approach, which allows the model designer to decide which portion of the data will be stored in MOLAP and which portion in ROLAP .


PRODUCTS


Examples of commercial products that use MOLAP are Microsoft Analysis Services , Essbase and TM1 . There is also an open source MOLAP server - Palo .


EXTERNAL LINKS

  • http://www.gnulamp.com/molap.html