Multi-query SQL Progress Indicators

Recently, progress indicators have been proposed for SQL queries in RDBMSs. All previously proposed progress indicators consider each query in isolation, ignoring the impact simultaneously running queries have on each other's performance. In this paper, we explore a multi-query progress indicator, which explicitly considers concurrently running queries and even queries predicted to arrive in the future when producing its estimates. We demonstrate that multi-query progress indicators can provide more accurate estimates than single-query progress indicators. Moreover, we extend the use of progress indicators beyond being a GUI tool and show how to apply multi-query progress indicators to workload management. We report on an initial implementation of a multi-query progress indicator in PostgreSQL and experiments with its use both for estimating remaining query execution time and for workload management.

• Type: Conference
• Year: 2006
• Where: EDBT
• Authors: Gang Luo, Jeffrey F. Naughton, Philip S. Yu
• Keywords: Database, EDBT 2006, Multi-query Progress Indicator, Progress Indicator, Single-query Progress Indicators