Adaptive progress indicator for long running SQL queries
Mario Miličević, Krunoslav Žubrinić, Ivona Zakarija · 2008
Percent-done progress indicators are a technique for graphically showing how much of a long task has been completed. In the database environment such information is especially important during the long-running query execution. The proposed method constructs (during the learning phase) adaptive progress indicator model analyzing influence of averaged system state (represented with attributes describing CPU, memory and disk subsystem activity) on the query response time. Experimental evaluation shows that adaptive progress indicators can enhance users' experience and productivity.