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.00011210489
Overall Rank: 1,276 | 91.45%
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,800	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.5999908e-05
2,189	Leveraging Lock Contention to Improve OLTP Application Performance	2016	VLDB	8.8866479e-05
2,219	Magpie: Python at Speed and Scale using Cloud Backends	2021	CIDR	8.8186113e-05
2,716	Compiling PL/SQL Away	2020	CIDR	8.0819509e-05
2,969	Automatic Partitioning of Database Applications	2012	VLDB	7.7868967e-05
3,002	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD	7.7473824e-05
3,190	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	7.5364422e-05
3,938	Sloth: Being Lazy is a Virtue (When Issuing Database Queries)	2014	SIGMOD	6.8968843e-05
4,078	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.8028789e-05
4,166	SQLCheck: Automated Detection and Diagnosis of SQL Anti-Patterns	2020	SIGMOD	6.7549236e-05
5,889	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	5.940403e-05
6,100	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.8699028e-05
6,104	Iterative Query Processing based on Unified Optimization Techniques	2019	SIGMOD	5.8688901e-05
6,586	WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications	2024	SIGMOD	5.7237124e-05
6,862	Towards Unified Ad-hoc Data Processing	2014	SIGMOD	5.6458401e-05
7,177	Automatic Algorithm Transformation for Efficient Multi-Snapshot Analytics on Temporal Graphs	2017	VLDB	5.5772803e-05
8,635	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	5.2832224e-05
8,928	Translation of Array-Based Loops to Distributed Data-Parallel Programs	2020	VLDB	5.2361195e-05
10,260	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	5.0381136e-05
11,199	Query Decorrelation in the Fabric Data Warehouse	2025	SIGMOD	4.9605343e-05
11,202	TXSQL: Lock Optimizations Towards High Contented Workloads	2025	SIGMOD	4.9605343e-05
12,725	Keyword Search on Form Results	2011	VLDB	4.9605343e-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
99	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034024478
133	Optimization of Nested SQL Queries Revisited	1987	SIGMOD	0.0003015194
554	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00016487919
2,163	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	8.9189753e-05
2,555	A Transformation-Based Approach to Optimizing Loops in Database Programming Languages	1992	SIGMOD	8.2817782e-05

Semantically Similar Papers

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