Events

Events

Quarantine DB Talk 2020: Query Optimization at Snowflake

Date

Mon Sep 21, 2020

Time

05:00pm EDT

Location

ZOOM

Speaker

Jiaqi Yan

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.

Zoom Link: https://cmu.zoom.us/j/562649242 (Password 264771)

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/