ConEx: a system for monitoring queries

ABSTRACT

We present a system, ConEx, for monitoring query execution in a relational database management system. ConEx offers a unified view of query execution, providing continuous visual feedback on the progress of the query, and the status of operators in the query evaluation plan. It incorporates novel techniques to dynamically estimate important parameters affecting query progress efficiently. We describe the design and features of ConEx, and discuss its technology.

REFERENCES

• 1: S. Chaudhuri, R. Kaushik, and R. Ramamurthy. When Can We Trust Progress Estimators for SQL Queries. SIGMOD, 2005.
• 2: S. Chaudhuri, V. Narassaya, and R. Ramamurthy. Estimating Progress of Execution for SQL Queries. SIGMOD, 2004.
• 3: G. Luo, J. Naughton, C. Ellman, and M. Watzke. Increasing the Accuracy and Coverage of SQL Progress Indicators. ICDE, 2004.
• 4: G. Luo, J. Naughton, C. Ellman, and M. Watzke. Toward a Progress Indicator for Database Queries. SIGMOD, 2004.
• 5: C. Mishra and N. Koudas. A lightweight online framework for query progress indicators. ICDE, 2007.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.5 INFORMATION INTERFACES AND PRESENTATION (I.7)
      H.5.2 User Interfaces (D.2.2, H.1.2, I.3.6)
          Subjects: Graphical user interfaces (GUI)

General Terms:
Design, Management

Keywords:
database adminstration, progress estimation, query monitoring