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
14110
Venue
VLDB
Year
2025
Pagerank
5.1955087e-05
Overall Rank
9,917 | 31.97%
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 1 of 1 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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
132 Predicate Migration: Optimizing Queries with Expensive Predicates 1993 SIGMOD 0.00030378624
226 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00024027277
649 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015320656
677 Query Optimization in the Presence of Foreign Functions 1993 VLDB 0.00015065909
801 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.00013909408
894 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013367658
938 Flexible Database Generators 2005 VLDB 0.00013089351
1,768 Tuplex: Data Science in Python at Native Code Speed 2021 SIGMOD 9.8041636e-05
1,892 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.5277793e-05
2,094 Tupleware: "Big" Data, Big Analytics, Small Clusters 2015 CIDR 9.1819738e-05
2,202 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 8.9639459e-05
2,316 Evaluating End-to-End Optimization for Data Analytics Applications in Weld 2018 VLDB 8.7596739e-05
2,465 Optimization of Queries with User-defined Predicates 1996 VLDB 8.5428786e-05
2,684 Compiling PL/SQL Away 2020 CIDR 8.25952e-05
3,205 On Optimizing Operator Fusion Plans for Large-Scale Machine Learning in SystemML 2018 VLDB 7.6386536e-05
4,273 User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases 2022 VLDB 6.7909197e-05
4,292 Putting Pandas in a Box 2021 CIDR 6.7784325e-05
5,301 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 6.2750553e-05
5,376 Evolution of a Compiling Query Engine 2021 VLDB 6.2415397e-05
5,791 Accelerating Python UDFs in Vectorized Query Execution 2022 CIDR 6.0873094e-05
5,983 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.0206841e-05
6,015 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 6.008272e-05
6,253 Declarative Sub-Operators for Universal Data Processing 2023 VLDB 5.940599e-05
6,314 YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases 2022 VLDB 5.9157364e-05
6,328 Functional-Style SQL UDFs With a Capital 'F' 2020 SIGMOD 5.9113895e-05
7,066 Aero: Adaptive Query Processing of ML Queries 2025 SIGMOD 5.712204e-05
8,096 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 5.4875738e-05
8,368 Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA 2023 VLDB 5.4419148e-05
8,465 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.4194578e-05
9,415 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 5.2742285e-05
10,039 Towards Resource-adaptive Query Execution in Cloud Native Databases 2024 CIDR 5.1723558e-05
10,040 SQL Engines Excel at the Execution of Imperative Programs 2024 VLDB 5.1723558e-05
13,601 BabbleFlow - A Translator for Analytic Data Flow Programs 2014 SIGMOD -
Previous Page 1 / 1 Next

Semantically Similar Papers