Increasing the Accuracy and Coverage of SQL Progress Indicators

	This Article
	Subscribers, please Login Purchase article: $19 PDF IEEE Xplore Subscribers RSS feed
	Share
	Email this Article to a friend
	Bibliographic References
	ASCII Text BibTex RefWorks Procite/RefMan/Endnote
	Add to:
	Digg Furl Spurl Blink Simpy Google Del.icio.us Y!MyWeb
	Search
	Similar Articles Articles by Gang Luo Articles by Jeffrey F. Naughton Articles by Curt J. Ellmann Articles by Michael W. Watzke

21st International Conference on Data Engineering (ICDE'05)

Tokyo, Japan

April 05-April 08

ISBN: 0-7695-2285-8

	ASCII Text	x
	Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, Michael W. Watzke, "Increasing the Accuracy and Coverage of SQL Progress Indicators," Data Engineering, International Conference on, pp. 853-864, 21st International Conference on Data Engineering (ICDE'05), 2005.

	BibTex	x
	@article{ 10.1109/ICDE.2005.79, author = {Gang Luo and Jeffrey F. Naughton and Curt J. Ellmann and Michael W. Watzke}, title = {Increasing the Accuracy and Coverage of SQL Progress Indicators}, journal ={Data Engineering, International Conference on}, volume = {0}, year = {2005}, issn = {1084-4627}, pages = {853-864}, doi = {http://doi.ieeecomputersociety.org/10.1109/ICDE.2005.79}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, }

	RefWorks Procite/RefMan/Endnote	x
	TY - CONF JO - Data Engineering, International Conference on TI - Increasing the Accuracy and Coverage of SQL Progress Indicators SN - 1084-4627 SP853 EP864 A1 - Gang Luo, A1 - Jeffrey F. Naughton, A1 - Curt J. Ellmann, A1 - Michael W. Watzke, PY - 2005 KW - null VL - 0 JA - Data Engineering, International Conference on ER -

Gang Luo, IBM T.J. Watson Research Center

Jeffrey F. Naughton, University of Wisconsin-Madison

Curt J. Ellmann, University of Wisconsin-Madison

Michael W. Watzke, NCR

DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ICDE.2005.79

Recently, progress indicators have been proposed for long-running SQL queries in RDBMSs. Although the proposed techniques work well for a subset of SQL queries, they are preliminary in the sense that (1) they cannot provide non-trivial estimates for some SQL queries, and (2) the provided estimates can be rather imprecise in certain cases. In this paper, we consider the problem of supporting non-trivial progress indicators for a wider class of SQL queries with more precise estimates. We present a set of techniques in achieving this goal. We report an initial implementation of these techniques in PostgreSQL.

Citation:

Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, Michael W. Watzke, "Increasing the Accuracy and Coverage of SQL Progress Indicators," icde, pp.853-864, 21st International Conference on Data Engineering (ICDE'05), 2005

Peer Review Notice | Give Us Feedback

Usage of this product signifies your acceptance of the Terms of Use.