Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Learned Query Optimization in PrestoDB

Presto Foundation via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Watch a technical conference talk exploring AutoSteer, a machine learning-based query optimization solution developed through Intel and Meta's collaboration. Dive into how AutoSteer builds upon the Bandit optimizer (Bao) to enhance query performance in disaggregated SQL systems, particularly PrestoDB. Learn about the implementation details through both generic and custom connectors, examining experimental results from public benchmarks and Meta's production workload that demonstrated up to 40% performance improvements over PrestoDB's native query optimizer. Discover the visual frontend features of this open-source tool and understand how a new optimizer heuristic was contributed to Meta's operations. The 37-minute presentation delivers valuable insights for database administrators and developers interested in advanced query optimization techniques.

Syllabus

Learned Query Optimization in PrestoDB - Nesime Tatbul, Dave Cohen, Ryan Marcus & Christoph Anneser

Taught by

Presto Foundation

Reviews

Start your review of Learned Query Optimization in PrestoDB

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.