DBScholar

Back to papers

The UDFBench Benchmark for General-purpose UDF Queries

Summary: Introduces UDFBench, the first benchmark centered on real-world UDF queries and their execution bottlenecks. Its composable workloads isolate or combine overheads, enabling cross-system evaluation of optimization and compilation techniques across five databases. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hd152136b2936edaf
Venue
VLDB
Year
2025
Pagerank
5.1396592e-05
Overall Rank
9,694 | 34.83%
DOI
10.14778/3746405.3746409

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{foufoulas_vldb25,
        title = {{The UDFBench Benchmark for General-purpose UDF Queries}},
        author = {Foufoulas, Yannis and Palaiologou, Theoni and Simitsis, Alkis},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {9},
        pages = {2804--2817},
        doi = {10.14778/3746405.3746409},
        url = {https://doi.org/10.14778/3746405.3746409},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 34 of 34 cited papers.

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

Rank Cited Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
125 Predicate Migration: Optimizing Queries with Expensive Predicates 1993 SIGMOD 0.00030470848
235 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00023697028
605 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015647561
689 Query Optimization in the Presence of Foreign Functions 1993 VLDB 0.00014752546
821 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.00013660347
896 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013209291
955 Flexible Database Generators 2005 VLDB 0.00012866364
1,786 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.6326265e-05
1,803 Tuplex: Data Science in Python at Native Code Speed 2021 SIGMOD 9.6068397e-05
1,952 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 9.3189525e-05
2,123 Tupleware: "Big" Data, Big Analytics, Small Clusters 2015 CIDR 9.0060385e-05
2,249 Evaluating End-to-End Optimization for Data Analytics Applications in Weld 2018 VLDB 8.7549752e-05
2,516 Optimization of Queries with User-defined Predicates 1996 VLDB 8.3610198e-05
2,705 Compiling PL/SQL Away 2020 CIDR 8.1111408e-05
3,101 On Optimizing Operator Fusion Plans for Large-Scale Machine Learning in SystemML 2018 VLDB 7.649219e-05
3,384 Putting Pandas in a Box 2021 CIDR 7.3550055e-05
3,642 User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases 2022 VLDB 7.1416697e-05
5,230 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 6.2189001e-05
5,348 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.1690434e-05
5,455 Evolution of a Compiling Query Engine 2021 VLDB 6.1239975e-05
5,551 Aero: Adaptive Query Processing of ML Queries 2025 SIGMOD 6.0872198e-05
5,719 Accelerating Python UDFs in Vectorized Query Execution 2022 CIDR 6.0187779e-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,212 YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases 2022 VLDB 5.8480745e-05
6,296 Declarative Sub-Operators for Universal Data Processing 2023 VLDB 5.8195258e-05
6,400 Functional-Style SQL UDFs With a Capital 'F' 2020 SIGMOD 5.7981078e-05
7,962 Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA 2023 VLDB 5.4167003e-05
7,983 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 5.4131297e-05
8,153 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3891786e-05
9,588 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 5.156809e-05
10,222 Towards Resource-adaptive Query Execution in Cloud Native Databases 2024 CIDR 5.0572221e-05
10,223 SQL Engines Excel at the Execution of Imperative Programs 2024 VLDB 5.0572221e-05
13,914 BabbleFlow - A Translator for Analytic Data Flow Programs 2014 SIGMOD -
Previous Page 1 / 1 Next

Semantically Similar Papers