The Basics: OLAP, MOLAP, ROLAP, HOLAP – Lot’s of letters but what do they mean?

As part of the ‘basic’ series, we now come to the world of OLAP and the various concepts, technologies and tools in it. In my previous post on OLTP and OLAP, we saw the difference (conceptually) between what comprises an OLTP system and what would be considered as an OLAP system.

Having understood the fundamental concept of OLAP, lets go down the rabbit hole and see what other wonders we find. To jumpstart the process I’ll throw at you the 3 acronyms you are bound to hear when OLAP pops up and that is MOLAP, ROLAP and HOLAP. They are the three stooges of OLAP.

Continue reading