🗄️Massively Parallel Processing (MPP)
Also known as MPP Database, MPP Architecture
One query split across many machines. Each works on its own slice of the data.
Think of it like
It is like ten friends each counting one shelf of books. The whole room is counted much faster.
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.
Definition
Common mistake
Key takeaways
- 1Split the data. Each node holds a slice.
- 2Work at once. All nodes run at the same time.
- 3Join the parts. A leader adds up the answers.