May 3, 2010

ROLAP, MOLAP and HOLAP


There are three different types of OLAP technology:

ROLAP stands for Relational-OLAP as it stores all the data in relational database. When we run the MDX queries it retrieves the data from the relational database using a corresponding SQL query. This makes the query processing to be slow but it does provide faster processing time.

MOLAP stands for Multidimensional-OLAP as it stores all the data in the multidimensional data structure of the Analysis Services. It has slow processing time but provides better query performance than ROLAP. MOLAP storage mode is most widely used as OLAP is meant to provide the faster query performance.

HOLAP stands for Hybrid-OLAP as it uses a combination of both the ROLAP and MOLAP. It stores only the indexes and aggregations in the multidimensional form while the rest of the data is stored in the relational database.

5 comments:

Ordinary Psycho said...

hey i'm doin a project on intelligetn heart disease prediction system using datamining concepts...i donno how much of sample data i shud collect for the system,..cud u guide me

Stunts Heaven said...

cool

benslin kard said...

Data warehousing is used to view day-to-day operations, but its primary function is often strategic planning based on long-term data overviews.

Website said...

Nice posting,thanks for sharing the nice information.And you have done a incredible work in this blog and this blog provide the good information and i definitely bookmark this blog.

scrape attraction data

sathya said...

There are many interesting information included and i can easily understand all given information.I post something on my blog to post something, or wait to post something worth saying. Keep update more information....


Data warehousing Training in Chennai