Information About

Holap





VERTICAL PARTITIONING


In this mode HOLAP stores ''aggregations'' in MOLAP for fast query performance, and detailed data in ROLAP to optimize time of cube ''processing''.


HORIZONTAL PARTITIONING


In this mode HOLAP stores some slice of data, usually the more recent one (i.e. sliced by Time dimension) in MOLAP for fast query performance, and older data in ROLAP . Moreover, we can store some dices in MOLAP and others in ROLAP , leveraging the fact that in a large cuboid, there will be dense and sparse subregions Owen Kaser and Daniel Lemire, Attribute Value Reordering for Efficient Hybrid OLAP , Information Sciences, Volume 176, Issue 16, pages 2279-2438, 2006. .


PRODUCTS


Examples of commercial products which support HOLAP storage mode are Microsoft Analysis Services , MicroStrategy and SAP AG BI Accelerator.


FOOTNOTES