What is database partitioning in System Design?

Partitioning splits data into subsets so storage and workload can be distributed across nodes or boundaries. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.