Choose Index below for a list of all words and phrases defined in this glossary.

Hybrid Online Analytical Processing (HOLAP or Hybrid OLAP)

index | Index

Hybrid Online Analytical Processing (HOLAP or Hybrid OLAP) - definition(s)

hybrid online analytical processing (HOLAP or Hybrid OLAP) - Hybrid online analytical processing (HOLAP) is a combination of relational OLAP (ROLAP) and multidimensional OLAP (usually referred to simply as OLAP). HOLAP was developed to combine the greater data capacity of ROLAP with the superior processing capability of OLAP.

HOLAP can use varying combinations of ROLAP and OLAP technology. Typically it stores data in a both a relational database (RDB) and a multidimensional database (MDDB) and uses whichever one is best suited to the type of processing desired. The databases are used to store data in the most functional way. For data-heavy processing, the data is more efficiently stored in a RDB, while for speculative processing, the data is more effectively stored in an MDDB.

HOLAP users can choose to store the results of queries to the MDDB to save the effort of looking for the same data over and over which saves time. Although this technique - called "materializing cells" - improves performance, it takes a toll on storage. The user has to strike a balance between performance and storage demand to get the most out of HOLAP. Nevertheless, because it offers the best features of both OLAP and ROLAP, HOLAP is increasingly preferred.

Related glossary terms: Universal Data Access (UDA), geographic information system (GIS), DSTP (Data Space Transfer Protocol), multidimensional online analytical processing (MOLAP), FileMaker (FMP), meta, data mining, pivot table, data warehouse / database warehouse, data preprocessing

[Category=Data Management ]

Source:, 15 August 2013 09:46:09, External

Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: