# Massively Parallel Processing (MPP)

> One query split across many machines. Each works on its own slice of the data.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** MPP Database, MPP Architecture

## Think of it like

It is like ten friends each counting one shelf of books. The whole room is counted much faster.

## Definition

Massively parallel processing splits one query across many machines that work at the same time. Each machine, called a node, holds its own slice of the data. Each node works on its slice, and a leader node adds the parts into one answer. More nodes means more work done at once. Most cloud data warehouses run queries this way.

## Example

A table has a billion rows spread over 20 nodes. A count runs on all 20 at once, and the leader adds up 20 small counts.

## Why it matters

It lets a warehouse scan huge tables in seconds. Adding nodes makes big queries faster.

## Common mistake

Spreading the data unevenly. If one node holds most of the rows, every query waits for that one node.

## Three principles

- **Split the data.** Each node holds a slice.
- **Work at once.** All nodes run at the same time.
- **Join the parts.** A leader adds up the answers.

## Related terms

- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Separation of Storage and Compute](https://learn.benibix.com/term/data/separation-of-storage-and-compute)
- [Data Shuffle](https://learn.benibix.com/term/data/data-shuffle)
- [Amazon Redshift](https://learn.benibix.com/term/data/amazon-redshift)
- [Distributed System](https://learn.benibix.com/term/development/distributed-system)
- [Horizontal Scaling](https://learn.benibix.com/term/development/horizontal-scaling)

![A highlighted leader at the top splits a query and sends it to four nodes. Each node holds its own slice of 250 rows out of 1,000 and returns a partial sum: 41, 37, 44 and 38. A note says all four work at once, so the leader returns 160 in a quarter of the time.](https://learn.benibix.com/diagrams/dat-mpp.svg)

---

Source: https://learn.benibix.com/term/data/massively-parallel-processing
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
