Hybrid Online Analytical Processing

Why Trust Techopedia

What Does Hybrid Online Analytical Processing Mean?

Hybrid online analytical (HOLAP) is the combination of relational online analytical processing (ROLAP) and multidimensional online analytical processing (MOLAP). It supports both storage formats and therefore provides advantages from both processes. HOLAP was developed to put an end to the "which is better?" debate by combining the data capacity of a ROLAP and the processing capability of a MOLAP.

Advertisements

Techopedia Explains Hybrid Online Analytical Processing

Because hybrid OLAPs enable the use of various combinations of the two OLAPs, they basically store data in both a relational database and a multidimensional database. As a result, the decision to access one of the two databases depends solely on which is best suited for the desired processing type or application. This provides much more flexibility when handling data. For heavy data processing, the data is stored in a relational database, while for theoretical processing, the data is stored in a multidimensional database.

This approach is beneficial in the following situations:

  • If there are volumes of data that cannot be handled by one multidimensional database.
  • If there are instances of performance bottlenecks whenever data is being accessed from a server.
  • If there is a need to use existing summarized and arranged data sources.
Advertisements

Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.