Rewriting Procedures for Batched Bindings

Summary: Automatically rewrites repeated query/UDF calls and stored procedures into set-oriented batched bindings, addressing nested-call random I/O beyond query decorrelation. Demonstrated on Java/JDBC applications with substantial performance gains. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 9931
Venue: VLDB
Year: 2008
Pagerank: 0.0001143305
Overall Rank: 1,261 | 91.36%
DOI: 10.14778/1453856.1453975

Incoming Non-self Citations Over Time

Authors

1. Ravindra Guravannavar (Indian Institute of Technology Mumbai)
2. S Sudarshan (Indian Institute of Technology Mumbai)

BibTeX Citation

@article{guravannavar_vldb08,
        title = {{Rewriting Procedures for Batched Bindings}},
        author = {Guravannavar, Ravindra and Sudarshan, S},
        journal = {PVLDB},
        series = {{VLDB} '08},
        doi = {10.14778/1453856.1453975},
        url = {https://doi.org/10.14778/1453856.1453975},
        year = {2008}
}

Incoming Citations (Sorted by Pagerank)

Showing 22 of 22 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,892	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.5277793e-05
2,154	Leveraging Lock Contention to Improve OLTP Application Performance	2016	VLDB	9.0745745e-05
2,651	Magpie: Python at Speed and Scale using Cloud Backends	2021	CIDR	8.2918086e-05
2,684	Compiling PL/SQL Away	2020	CIDR	8.25952e-05
2,939	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD	7.9395908e-05
2,941	Automatic Partitioning of Database Applications	2012	VLDB	7.937125e-05
3,257	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	7.590651e-05
3,900	Sloth: Being Lazy is a Virtue (When Issuing Database Queries)	2014	SIGMOD	7.0361352e-05
3,992	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.9695338e-05
4,082	SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns	2020	SIGMOD	6.9164719e-05
5,759	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	6.0962298e-05
5,991	Iterative Query Processing based on Unified Optimization Techniques	2019	SIGMOD	6.0171458e-05
6,015	Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL	2024	CIDR	6.008272e-05
6,475	WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications	2024	SIGMOD	5.8687157e-05
6,714	Towards Unified Ad-hoc Data Processing	2014	SIGMOD	5.7959651e-05
7,040	Automatic Algorithm Transformation for Efficient Multi-Snapshot Analytics on Temporal Graphs	2017	VLDB	5.7196196e-05
8,738	Translation of Array-Based Loops to Distributed Data-Parallel Programs	2020	VLDB	5.3766157e-05
9,415	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.2742285e-05
10,040	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	5.1723558e-05
10,697	Query Decorrelation in the Fabric Data Warehouse	2025	SIGMOD	5.093636e-05
10,700	TXSQL: Lock Optimizations Towards High Contented Workloads	2025	SIGMOD	5.093636e-05
12,385	Keyword Search on Form Results	2011	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
95	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034607909
129	Optimization of Nested SQL Queries Revisited	1987	SIGMOD	0.0003068101
543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001682612
2,198	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	8.9680897e-05
2,505	A Transformation-Based Approach to Optimizing Loops in Database Programming Languages	1992	SIGMOD	8.4960641e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,913	An Approach to Optimize Data Processing in Business Processes	2007	VLDB
2	2,939	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD
3	13,010	Processing Object-Oriented Queries with Invertible Late Bound Functions	1995	VLDB
4	1,154	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD
5	7,137	Rule-Based Translation of Relational Queries into Iterative Programs	1986	SIGMOD
6	4,724	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD
7	1,892	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB
8	14,284	Procedures in Object-Oriented Query Languages	1995	VLDB
9	129	Optimization of Nested SQL Queries Revisited	1987	SIGMOD
10	6,015	Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL	2024	CIDR