Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL

Summary: Empirical comparison of UDF inlining vs batching on enterprise and open-source DBMSs using a UDF-centric workload; inlining helps simple UDFs but batching outperforms by up to 93.4× on complex UDFs since it makes optimizer decorrelation easier. Propose a hybrid strategy to pick batching or inlining per UDF to maximize performance. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 504
Venue: CIDR
Year: 2024
Pagerank: 5.0874998e-05
Overall Rank: 6,374 | 55.71%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,003	The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions	2024	VLDB	4.6049527e-05
8,616	Nexus: Correlation Discovery over Collections of Spatio-Temporal Tabular Data	2024	SIGMOD	4.4795277e-05
9,348	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	4.3504473e-05
9,764	QURE: AI-Assisted and Automatically Verified UDF Inlining	2025	SIGMOD	4.2815042e-05
9,765	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	4.2815042e-05
9,883	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	4.2594931e-05
10,217	This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch!	2026	SIGMOD	4.1905499e-05
10,423	Query Decorrelation in the Fabric Data Warehouse	2025	SIGMOD	4.1905499e-05
10,426	Scalable Execution of Application Logic within Everest BusinessStore	2025	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
185	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00036529607
640	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018780632
729	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00017448059
1,107	Froid: Optimization of Imperative Programs in a Relational Database	2018	VLDB	0.0001397627
1,457	Rewriting Procedures for Batched Bindings	2008	VLDB	0.00011891025
1,884	Tuplex: Data Science in Python at Native Code Speed	2021	SIGMOD	0.00010206514
2,242	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.2124242e-05
2,503	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6306662e-05
3,649	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	6.8764882e-05
4,645	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.0190618e-05
5,741	Babelfish: Efficient Execution of Polyglot Queries	2022	VLDB	5.3450701e-05
6,703	YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases	2022	VLDB	4.9514593e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,883	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	4.2594931e-05
5,486	Containerized Execution of UDFs: An Experimental Evaluation	2022	VLDB	5.481452e-05
6,646	Functional-Style SQL UDFs With a Capital 'F'	2020	SIGMOD	4.9734285e-05
10,469	UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines	2025	SIGMOD	4.1905499e-05
6,191	Accelerating Python UDFs in Vectorized Query Execution	2022	CIDR	5.1598046e-05
1,457	Rewriting Procedures for Batched Bindings	2008	VLDB	0.00011891025
4,571	BlackMagic: Automatic Inlining of Scalar UDFs into SQL Queries with Froid	2019	VLDB	6.0693276e-05
9,765	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	4.2815042e-05
8,580	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	4.4876382e-05
9,348	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	4.3504473e-05