Speaker:

Jiaqi Yan

Date:

Mon Sep 21, 2020 @ 05:00pm EDT

Date:

Mon Sep 21, 2020

Time:

05:00pm EDT

Location:

https://cmu.zoom.us/j/562649242?pwd=djhicnFKWHdJM1o0MlFvYzg3SzB5Zz09Zoom

Title:

Query Optimization at Snowflake

System:

Snowflake

Video:

YouTube

---

Talk Info:

In this talk, I will give an introduction to Snowflake’s query optimizer. I will talk about the main features of Snowflake’s optimizer, explain the main philosophy behind the design decisions, and delve into some unique aspects of the implementation. I will also later expand into our infrastructures to facilitate optimizer development and discuss the opportunities and challenges for implementing and rolling out query optimizations for cloud-based databases.

This talk is part of the Quarantine Database Tech Talk Seminar Series.

Bio:

Jiaqi Yan is a software engineer at Snowflake Computing. His main work spans Snowflake's query engine, serverless features, and engineering infrastructure. He currently leads development of performance improvements for Snowflake's query compiler and optimizer. Before joining Snowflake, Jiaqi was a software engineer at Oracle.

More Info: https://db.cs.cmu.edu/seminar2020/

---