ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

Online Analytical Processing Cube (OLAP Cube)

Definition - What does Online Analytical Processing Cube (OLAP Cube) mean?

An online analytical processing cube (OLAP cube) is a multidimensional array of data that serves as a database optimized for OLAP applications and data warehousing. It is a way of storing relevant data in a multidimensional form to make it appear more logical when used to generate reports and facilitate more efficient analytics.

Techopedia explains Online Analytical Processing Cube (OLAP Cube)

An OLAP cube stores and categorizes data as dimensions and is considered in terms of "measures." Picture a Cartesian plane with three axes (x, y and z), and each axis notch signifies a given measure, with each axis being a data category. These cubes are pre-summarized across each dimension, which vastly improves query time in relational databases.

Microsoft's multidimensional expressions (MDX) language is used to interact with and command OLAP cubes.

Unlike traditional databases, which are designed according to system requirements, OLAP cubes are developed with business logic for business intelligence (BI) and, thus, are optimized for analytical processes with the ability to report on multiple records simultaneously.

Advantages to OLAP cubes include the following:

  • May have more than three dimensions - virtually infinite - resulting in a hypercube, which allows in-depth data analysis
  • Enables multifaceted data analysis of complex and large volumes of data in response to complex business queries

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
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.