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: h2d553d3bbb7d7017
Venue: VLDB
Year: 2007
Pagerank: 5.9045522e-05
Overall Rank: 5,994 | 59.83%
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,730	Partial Results in Database Systems	2014	SIGMOD	8.0676725e-05
6,556	Data Warehouse Technology by Infobright	2009	SIGMOD	5.7299985e-05
9,157	Database Optimization for the Cloud: Where Costs, Partial Results, and Consumer Choice Meet	2015	CIDR	5.2042524e-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.00076079812
57	On Random Sampling over Joins	1999	SIGMOD	0.0003999751
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029532435
183	Processing Aggregate Relational Queries with Hard Time Constraints	1989	SIGMOD	0.00026316699
398	On Saying "Enough Already!" in SQL	1997	SIGMOD	0.00019117739
505	Supporting Top-k Join Queries in Relational Databases	2003	VLDB	0.00017162373
564	Congressional Samples for Approximate Answering of Group-By Queries	2000	SIGMOD	0.00016251304
647	Evaluating Top-k Selection Queries	1999	VLDB	0.00015165562
883	An Efficient SQL-based RDF Querying Scheme	2005	VLDB	0.00013231297
935	Dynamic Sample Selection for Approximate Query Processing	2003	SIGMOD	0.00012968914
1,159	Toward a Progress Indicator for Database Queries	2004	SIGMOD	0.00011739527
1,569	Reducing the Braking Distance of an SQL Query Engine	1998	VLDB	0.00010177494
1,712	Rank-aware Query Optimization	2004	SIGMOD	9.7961248e-05
2,193	Probabilistic Optimization of Top N Queries	1999	VLDB	8.8828694e-05
2,329	When Can We Trust Progress Estimators for SQL Queries?	2005	SIGMOD	8.6188984e-05

Semantically Similar Papers

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