Google Spanner's SQL Evolution
Campbell Fraser was a developer and development lead in Microsoft SQL Server Query Optimizer for 13 years. For the last 6 years he has been a developer, technical lead and manager in Spanner's SQL Engine and is currently the technical lead for the SQL Query Optimizer.
No video of the event yet, sorry!
Spanner is a globally-distributed data management system that backs hundreds of mission-critical services at Google. Spanner is built on ideas from both the systems and database communities. The first Spanner paper published at OSDI 2012 focused on the systems aspects such as scalability, automatic sharding, fault tolerance, consistent replication, external consistency, and wide-area distribution. A subsequent paper in SIGMOD 2017 highlighted the database DNA of Spanner. This presentation builds on that second paper; we describe distributed SQL query execution in the presence of resharding, query restarts upon transient failures, range extraction that drives query routing and index seeks, and the improved blockwise columnar storage format. We touch upon the common SQL dialect shared with other systems at Google.
- 2019 September 20 11:00 PDT
- 20 min
- Silicon Valley 2019
- Distributed SQL