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: h63f732a99a355017
Venue: VLDB
Year: 2008
Pagerank: 0.00011247334
Overall Rank: 1,274 | 91.44%
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,786	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.6326265e-05
2,180	Leveraging Lock Contention to Improve OLTP Application Performance	2016	VLDB	8.9119622e-05
2,207	Magpie: Python at Speed and Scale using Cloud Backends	2021	CIDR	8.8487039e-05
2,705	Compiling PL/SQL Away	2020	CIDR	8.1111408e-05
2,954	Automatic Partitioning of Database Applications	2012	VLDB	7.8126137e-05
2,993	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD	7.7721951e-05
3,194	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	7.5498012e-05
3,923	Sloth: Being Lazy is a Virtue (When Issuing Database Queries)	2014	SIGMOD	6.9224617e-05
4,061	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.824809e-05
4,149	SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns	2020	SIGMOD	6.7796171e-05
5,876	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	5.9628805e-05
6,085	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	5.892166e-05
6,088	Iterative Query Processing based on Unified Optimization Techniques	2019	SIGMOD	5.8908778e-05
6,575	WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications	2024	SIGMOD	5.7453775e-05
6,840	Towards Unified Ad-hoc Data Processing	2014	SIGMOD	5.6669233e-05
7,174	Automatic Algorithm Transformation for Efficient Multi-Snapshot Analytics on Temporal Graphs	2017	VLDB	5.5937773e-05
8,900	Translation of Array-Based Loops to Distributed Data-Parallel Programs	2020	VLDB	5.2559789e-05
9,588	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.156809e-05
10,223	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	5.0572221e-05
11,131	Query Decorrelation in the Fabric Data Warehouse	2025	SIGMOD	4.9793485e-05
11,134	TXSQL: Lock Optimizations Towards High Contented Workloads	2025	SIGMOD	4.9793485e-05
12,676	Keyword Search on Form Results	2011	VLDB	4.9793485e-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
97	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034124569
132	Optimization of Nested SQL Queries Revisited	1987	SIGMOD	0.00030241193
552	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001653835
2,154	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	8.9474855e-05
2,549	A Transformation-Based Approach to Optimizing Loops in Database Programming Languages	1992	SIGMOD	8.3124291e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,995	An Approach to Optimize Data Processing in Business Processes	2007	VLDB
2	2,993	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD
3	13,300	Processing Object-Oriented Queries with Invertible Late Bound Functions	1995	VLDB
4	1,131	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD
5	7,261	Rule-Based Translation of Relational Queries into Iterative Programs	1986	SIGMOD
6	4,821	Processing Queries Against Database Procedures: A Performance Analysis	1988	SIGMOD
7	1,786	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB
8	14,595	Procedures in Object-Oriented Query Languages	1995	VLDB
9	132	Optimization of Nested SQL Queries Revisited	1987	SIGMOD
10	6,085	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