Data architecture - Concept
Partitioning
Dividing data into smaller sections so it can be stored or processed more efficiently
What's it for?
Splits large data into smaller sections so it can be stored and processed more efficiently.
For example…
A sales table is partitioned by month so a query for August only scans the August section instead of years of data
A distributed system partitions customer records by region so the workload can be spread across several machines.