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.926918e-05
Overall Rank: 5,983 | 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,717	Partial Results in Database Systems	2014	SIGMOD	8.0980367e-05
6,546	Data Warehouse Technology by Infobright	2009	SIGMOD	5.751485e-05
9,125	Database Optimization for the Cloud: Where Costs, Partial Results, and Consumer Choice Meet	2015	CIDR	5.2239819e-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.00076195956
57	On Random Sampling over Joins	1999	SIGMOD	0.00040108301
138	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00029627449
181	Processing Aggregate Relational Queries with Hard Time Constraints	1989	SIGMOD	0.00026389403
396	On Saying "Enough Already!" in SQL	1997	SIGMOD	0.00019162218
524	Supporting Top-k Join Queries in Relational Databases	2003	VLDB	0.00016909926
564	Congressional Samples for Approximate Answering of Group-By Queries	2000	SIGMOD	0.00016296665
643	Evaluating Top-k Selection Queries	1999	VLDB	0.00015217076
882	An Efficient SQL-based RDF Querying Scheme	2005	VLDB	0.0001327793
931	Dynamic Sample Selection for Approximate Query Processing	2003	SIGMOD	0.00013011667
1,159	Toward a Progress Indicator for Database Queries	2004	SIGMOD	0.00011771949
1,574	Reducing the Braking Distance of an SQL Query Engine	1998	VLDB	0.00010194928
1,773	Rank-aware Query Optimization	2004	SIGMOD	9.6719067e-05
2,181	Probabilistic Optimization of Top N Queries	1999	VLDB	8.9082736e-05
2,318	When Can We Trust Progress Estimators for SQL Queries?	2005	SIGMOD	8.6464837e-05

Semantically Similar Papers

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