Stage: Query Execution Time Prediction in Amazon Redshift

Ziniu Wu,Ryan Marcus,Zhengchun Liu,Parimarjan Negi,Vikram Nathan,Pascal Pfeil,Gaurav Saxena,Mohammad Rahman,Balakrishnan Narayanaswamy,Tim Kraska
2024-03-05
Abstract:Query performance (e.g., execution time) prediction is a critical component of modern DBMSes. As a pioneering cloud data warehouse, Amazon Redshift relies on an accurate execution time prediction for many downstream tasks, ranging from high-level optimizations, such as automatically creating materialized views, to low-level tasks on the critical path of query execution, such as admission, scheduling, and execution resource control. Unfortunately, many existing execution time prediction techniques, including those used in Redshift, suffer from cold start issues, inaccurate estimation, and are not robust against workload/data changes.
Databases
What problem does this paper attempt to address?