Partitioning Strategies

Was this section helpful?

References

Database System Concepts, Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, 2021 (McGraw-Hill Education) - A fundamental textbook for understanding database systems, including physical data organization, indexing, and query optimization techniques that underpin partitioning.
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, Ralph Kimball, Margy Ross, 2013 (Wiley) - A classic resource for data warehouse design, offering practical guidance on structuring data for analytical queries, often involving physical optimizations like partitioning for large fact tables.
Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems, Martin Kleppmann, 2017 (O'Reilly Media) - Offers a broad perspective on modern data systems, covering storage, indexing, and distributed data processing, which helps in understanding the context of the 'small file problem' and large-scale data organization.
Partitioned tables introduction, Google Cloud, 2024 - Official documentation detailing partitioning strategies in Google BigQuery, including time-unit, integer-range, and ingestion-time partitioning, with considerations for optimizing query performance and managing data volume.