Loading Events

CIS Seminar: “Learned Query Optimization”

February 8, 2022 at 8:00 AM - 5:00 PM
Details
Date: February 8, 2022
Time: 8:00 AM - 5:00 PM
  • Event Tags:
  • Organizer
    Computer and Information Science
    Phone: 215-898-8560
    Venue
    Wu and Chen Auditorium (Room 101), Levine Hall 3330 Walnut Street
    Philadelphia
    PA 19104
    Google Map

    Query optimizers are an important part of modern database management systems, responsible for transforming the user’s declarative query into an executable plan. Because the space of executable plans is so large, traditional query optimizers narrow the search space using complex hand-crafted heuristics, which must be manually tuned on a per-application basis for maximum performance. Both the maintenance of these heuristics and their manual tuning require significant human effort. In this talk, I will present two new approaches to query optimization that employ machine learning to entirely remove — or at least significantly lessen — the need for such heuristics. These learned approaches outperform traditional heuristics with a small amount of training overhead, while also automatically adapting to changes in the user’s workload or even hardware. Finally, this talk will highlight the opportunities for applying similar learning techniques to systems more broadly.