Process / pipelineDatabase Scalability & Distribution
Database Partitioning
Database partitioning is a technique for dividing large tables across multiple physical storage units or servers to improve performance and scalability. Developed in the context of distributed databases, partitioning allows individual queries to access smaller subsets of data, reducing I/O and enabling horizontal scaling as data grows.
Open in MethodMindSoonVideoSoon
Read the full method
Members only
Sign inSign in with a free account to read this section.
Sources
- Stonebraker, M., & Schloss, G. A. (1986). Distributed INGRES to homogeneous and heterogeneous computer systems. Proceedings of the ACM SIGMOD International Conference on Management of Data, 64-77. DOI: 10.1145/16856.16860 ↗
- Johnson, B. (2000). Distributed systems and databases (2nd ed.). New York: Morgan Kaufmann. link ↗
- Garcia-Molina, H., Ullman, J. D., & Widom, J. (2009). Database Systems: The Complete Book (2nd ed.). Pearson Education. link ↗