The following reading materials provide a solid introduction to SQL databases:
- Database Systems — MIT OpenCourseWare
- Readings in Database Systems — Joseph M. Hellerstein, Michael Stonebraker · 2005
- Correctness of Query Execution Strategies in Distributed Databases — Stefano Ceri, Giuseppe Pelagatti · 1983
- Query Evaluation Techniques for Large Databases — Getz Graefe · 1993
- Volcano — An Extensible and Parallel Query Evaluation System — Getz Graefe · 1994
- MonetDB/X100: Hyper-Pipelining Query Execution — Peter Boncz, Marcin Zukowski, Niels Nes · 2005
- Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age — Viktor Leis, Peter Boncz, et al. · 2014
- How Good Are Query Optimizers, Really? — Viktor Leis, Andrey Gubichev, et al. · 2015
- Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries — Shumo Chu et al. · 2018
- Push-Based Execution in DuckDB — Mark Raasveldt · 2021
- Citus: Distributed PostgreSQL for Data-Intensive Applications — Umur Cubukcu, Ozgun Erdogan, et al. · 2021
- Querying Parquet with Precision using DuckDB — Hannes Mühleisen, Mark Raasveldt · 2021
- TCUDB: Accelerating Database with Tensor Processors — Yu-Ching Hu, Yuliang Li, et al. · 2021
- Join Order Optimization with (Almost) No Statistics — Tom Ebergen · 2022
- Query Processing on Tensor Computation Runtimes — Dong He, Supun C Nakandala, et al. · 2022
- WeTune: Automatic Discovery and Verification of Query Rewrite Rules — Zhaoguo Wang Zhaoguo Wang, Zhou Zhou, et al. · 2022
Many thanks to Sam Ansmink for having contributed the original list of reference materials.