🧭Online Analytical Processing (OLAP)
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
Common mistake
Key takeaways
- 1Big scans. Each query reads many rows.
- 2Few columns. Only the needed fields are read.
- 3Column by column. Data is stored by column for speed.