Supporting Time-Constrained SQL Queries in Oracle

Summary: Introduces time-constrained SQL with soft/hard deadlines and partial/approximate-result semantics. Extends Oracle’s optimizer to select deadline-aware plans, using truncation or sampling plus aggregate estimates and confidence intervals for predictable response times. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 9721
Venue: VLDB
Year: 2007
Pagerank: 6.0626421e-05
Overall Rank: 5,863 | 59.78%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Ying Hu (Oracle)
2. Seema Sundara (Oracle)
3. Jagannathan Srinivasan (Oracle)

BibTeX Citation

@article{hu_vldb07,
        title = {{Supporting Time-Constrained SQL Queries in Oracle}},
        author = {Hu, Ying and Sundara, Seema and Srinivasan, Jagannathan},
        journal = {PVLDB},
        series = {{VLDB} '07},
        pages = {1207--1218},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,663	Partial Results in Database Systems	2014	SIGMOD	8.2818137e-05
6,428	Data Warehouse Technology by Infobright	2009	SIGMOD	5.8807378e-05
8,961	Database Optimization for the Cloud: Where Costs, Partial Results, and Consumer Choice Meet	2015	CIDR	5.3438458e-05

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
9	Online Aggregation	1997	SIGMOD	0.00077458002
54	On Random Sampling over Joins	1999	SIGMOD	0.00040810225
136	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00030123303
178	Processing Aggregate Relational Queries with Hard Time Constraints	1989	SIGMOD	0.00026881845
380	On Saying "Enough Already!" in SQL	1997	SIGMOD	0.00019563191
509	Supporting Top-k Join Queries in Relational Databases	2003	VLDB	0.00017220967
553	Congressional Samples for Approximate Answering of Group-By Queries	2000	SIGMOD	0.00016590619
635	Evaluating Top-k Selection Queries	1999	VLDB	0.00015527042
859	An Efficient SQL-based RDF Querying Scheme	2005	VLDB	0.00013561886
909	Dynamic Sample Selection for Approximate Query Processing	2003	SIGMOD	0.00013291205
1,143	Toward a Progress Indicator for Database Queries	2004	SIGMOD	0.00011999403
1,544	Reducing the Braking Distance of an SQL Query Engine	1998	VLDB	0.00010410466
1,759	Rank-aware Query Optimization	2004	SIGMOD	9.8160244e-05
2,149	Probabilistic Optimization of Top N Queries	1999	VLDB	9.0821709e-05
2,270	When Can We Trust Progress Estimators for SQL Queries?	2005	SIGMOD	8.8310714e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	5,615	Efficient and Accurate Cost Models for Parallel Query Optimization	1996	PODS
2	4,473	Temporal Coalescing with Now, Granularity, and Incomplete Information	2003	SIGMOD
3	4,277	Adaptive Statistics in Oracle 12c	2017	VLDB
4	12,760	Online Estimation For Subset-Based SQL Queries	2005	VLDB
5	566	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD
6	13,187	An Analytical Method for Estimating and Interpreting Query Time	1987	VLDB
7	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB
8	434	Query Optimization for Parallel Execution	1992	SIGMOD
9	5,537	Uncertainty Aware Query Execution Time Prediction	2014	VLDB
10	178	Processing Aggregate Relational Queries with Hard Time Constraints	1989	SIGMOD