Cisco CloudCenter: Get the Hybrid IT Advantage

Hybrid Online Analytical Processing (HOLAP)

Definition - What does Hybrid Online Analytical Processing (HOLAP) 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.

Techopedia explains Hybrid Online Analytical Processing (HOLAP)

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.
Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.