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)
Incoming Non-self Citations Over Time
Authors
- 1. Kai Franz (Carnegie Mellon University)
- 2. Samuel Arch (Carnegie Mellon University)
- 3. Denis Hirn (University of Tübingen)
- 4. Torsten Grust (University of Tübingen)
- 5. Todd C. Mowry (Carnegie Mellon University)
- 6. Andrew Pavlo (Carnegie Mellon University)
BibTeX Citation
@inproceedings{franz_cidr24,
address = {Amsterdam, Netherlands},
series = {{CIDR} '24},
title = {{Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL}},
booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
author = {Franz, Kai and Arch, Samuel and Hirn, Denis and Grust, Torsten and Mowry, Todd C. and Pavlo, Andrew},
year = {2024}
}Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
Previous
Page 1 / 1
Next
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.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,040 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB |
| 2 | 6,553 | Containerized Execution of UDFs: An Experimental Evaluation | 2022 | VLDB |
| 3 | 6,328 | Functional-Style SQL UDFs With a Capital 'F' | 2020 | SIGMOD |
| 4 | 10,740 | UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines | 2025 | SIGMOD |
| 5 | 5,791 | Accelerating Python UDFs in Vectorized Query Execution | 2022 | CIDR |
| 6 | 1,261 | Rewriting Procedures for Batched Bindings | 2008 | VLDB |
| 7 | 4,180 | BlackMagic: Automatic Inlining of Scalar UDFs into SQL Queries with Froid | 2019 | VLDB |
| 8 | 9,917 | The UDFBench Benchmark for General-purpose UDF Queries | 2025 | VLDB |
| 9 | 8,096 | Efficient Execution of User-Defined Functions in SQL Queries | 2023 | VLDB |
| 10 | 9,415 | The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining | 2025 | VLDB |