Skip to content
BENIBIX Learn

Online Analytical Processing (OLAP)

Data🧭 FoundationsData Workloads

Also known as OLAP, Analytical Database

Big queries that add up lots of rows. It is the work behind reports.

Think of it like

It is like adding up a whole year of till slips. You want to see which month sold the most.

Example

A manager asks for total sales by country for the last three years. The query scans 200 million rows and returns 40 numbers.

Why it matters

Reports and dashboards run on it. A system built for OLAP can answer in seconds what an app database takes hours on.

Definition

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.

Common mistake

Using it as an app's main database. It is slow at many tiny writes.

Key takeaways

  1. 1
    Big scans. Each query reads many rows.
  2. 2
    Few columns. Only the needed fields are read.
  3. 3
    Column by column. Data is stored by column for speed.

Compare

Learn it properly