OLAP vs OLAP Cube
People think OLAP means a cube. OLAP is the kind of work: big reads that add up many rows to answer questions. A cube is one old way to do that work, by adding up every total in advance. Most OLAP today runs in column-based warehouses with no cube at all.
Online Analytical Processing (OLAP)
Big queries that add up lots of rows. It is the work behind reports.
OLAP is the kind of work done to answer questions about lots of data. A query reads millions of rows but only a few columns. It adds up, counts and groups them, such as sales by month and region. These queries are fewer than OLTP ones, but each is much bigger. Systems built for OLAP usually store data column by column.
OLAP Cube
Totals worked out ahead of time, for each mix of a few fields.
An OLAP cube stores numbers worked out in advance for every mix of a few dimensions. A sales cube might have product, region and month as its sides. Each cell holds the total for one product, in one region, in one month. Questions are fast because the answers are already added up. Cubes were the main way to get fast answers before modern column-based warehouses.
In one line
- Online Analytical Processing (OLAP)
- Big queries that add up lots of rows. It is the work behind reports.
- OLAP Cube
- Totals worked out ahead of time, for each mix of a few fields.