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.0923872e-05
Overall Rank: 6,375 | 55.66%
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,020	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.6040862e-05
8,618	Nexus: Correlation Discovery over Collections of Spatio-Temporal Tabular Data	2024	SIGMOD	4.4838259e-05
9,343	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	4.3546206e-05
9,762	QURE: AI-Assisted and Automatically Verified UDF Inlining	2025	SIGMOD	4.2856106e-05
9,763	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	4.2856106e-05
9,884	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	4.2635782e-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.1945683e-05
10,412	Query Decorrelation in the Fabric Data Warehouse	2025	SIGMOD	4.1945683e-05
10,416	Scalable Execution of Application Logic within Everest BusinessStore	2025	SIGMOD	4.1945683e-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.00036538405
639	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018791492
735	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00017452467
1,108	Froid: Optimization of Imperative Programs in a Relational Database	2018	VLDB	0.00013984276
1,456	Rewriting Procedures for Batched Bindings	2008	VLDB	0.00011899772
1,882	Tuplex: Data Science in Python at Native Code Speed	2021	SIGMOD	0.0001021625
2,237	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.2212748e-05
2,504	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6351917e-05
3,648	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	6.8831123e-05
4,648	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.0247446e-05
5,731	Babelfish: Efficient Execution of Polyglot Queries	2022	VLDB	5.3502065e-05
6,701	YeSQL: “You extend SQL” with Rich and Highly Performant User-Defined Functions in Relational Databases	2022	VLDB	4.9561066e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,884	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	4.2635782e-05
5,476	Containerized Execution of UDFs: An Experimental Evaluation	2022	VLDB	5.4866534e-05
6,645	Functional-Style SQL UDFs With a Capital 'F'	2020	SIGMOD	4.978205e-05
10,459	UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines	2025	SIGMOD	4.1945683e-05
6,189	Accelerating Python UDFs in Vectorized Query Execution	2022	CIDR	5.1647573e-05
1,456	Rewriting Procedures for Batched Bindings	2008	VLDB	0.00011899772
4,582	BlackMagic: Automatic Inlining of Scalar UDFs into SQL Queries with Froid	2019	VLDB	6.070187e-05
9,763	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	4.2856106e-05
8,583	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	4.4919445e-05
9,343	The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining	2025	VLDB	4.3546206e-05