Abstract | ||
---|---|---|
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. |
Year | DOI | Venue |
---|---|---|
2005 | 10.1109/ICDE.2005.79 | ICDE |
Keywords | Field | DocType |
certain case,non-trivial progress indicator,non-trivial estimate,long-running sql query,sql progress indicators,precise estimate,proposed technique,wider class,sql query,progress indicator,initial implementation,rdbms,testing,pipelines,relational databases,cost function,sql | Data mining,PL/SQL,Stored procedure,Computer science,Data Transformation Services,Data definition language,Query by Example,Spatial query,Null (SQL),SQL/PSM,Database | Conference |
ISSN | ISBN | Citations |
1084-4627 | 0-7695-2285-8 | 32 |
PageRank | References | Authors |
2.67 | 12 | 4 |
Name | Order | Citations | PageRank |
---|---|---|---|
Gang Luo | 1 | 741 | 44.73 |
Jeffrey F. Naughton | 2 | 8363 | 1913.71 |
Curt J. Ellmann | 3 | 279 | 24.78 |
Michael W. Watzke | 4 | 114 | 8.27 |