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.1202393e-05
Overall Rank
9,729 | 34.79%
DOI
10.14778/3746405.3746409
PDF
Download (CC BY-NC-ND 4.0)

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.00061463175
125 Predicate Migration: Optimizing Queries with Expensive Predicates 1993 SIGMOD 0.00030398363
236 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00023639649
606 Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask 2018 VLDB 0.00015609823
691 Query Optimization in the Presence of Foreign Functions 1993 VLDB 0.00014701803
822 Query Execution Techniques for Caching Expensive Methods 1996 SIGMOD 0.00013616674
896 Froid: Optimization of Imperative Programs in a Relational Database 2018 VLDB 0.00013164545
958 Flexible Database Generators 2005 VLDB 0.00012834376
1,800 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.5999908e-05
1,812 Tuplex: Data Science in Python at Native Code Speed 2021 SIGMOD 9.5747668e-05
1,958 Quantifying TPC-H Choke Points and Their Optimizations 2020 VLDB 9.2894133e-05
2,139 Tupleware: "Big" Data, Big Analytics, Small Clusters 2015 CIDR 8.9729383e-05
2,258 Evaluating End-to-End Optimization for Data Analytics Applications in Weld 2018 VLDB 8.7387151e-05
2,521 Optimization of Queries with User-defined Predicates 1996 VLDB 8.3339593e-05
2,716 Compiling PL/SQL Away 2020 CIDR 8.0819509e-05
3,104 On Optimizing Operator Fusion Plans for Large-Scale Machine Learning in SystemML 2018 VLDB 7.6281929e-05
3,397 Putting Pandas in a Box 2021 CIDR 7.3273688e-05
3,654 User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases 2022 VLDB 7.1147757e-05
5,216 Aero: Adaptive Query Processing of ML Queries 2025 SIGMOD 6.2134335e-05
5,246 Babelfish: Efficient Execution of Polyglot Queries 2022 VLDB 6.1985833e-05
5,367 Adaptive and Robust Query Execution for Lakehouses at Scale 2024 VLDB 6.1462017e-05
5,475 Evolution of a Compiling Query Engine 2021 VLDB 6.1009218e-05
5,723 Accelerating Python UDFs in Vectorized Query Execution 2022 CIDR 5.9993122e-05
6,100 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.8699028e-05
6,218 YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases 2022 VLDB 5.8292066e-05
6,305 Declarative Sub-Operators for Universal Data Processing 2023 VLDB 5.8008469e-05
6,413 Functional-Style SQL UDFs With a Capital 'F' 2020 SIGMOD 5.7764365e-05
7,983 Excalibur: A Virtual Machine for Adaptive Fine-grained JIT-Compiled Query Execution based on VOILA 2023 VLDB 5.3962907e-05
8,002 Efficient Execution of User-Defined Functions in SQL Queries 2023 VLDB 5.3927693e-05
8,176 Predicate Pushdown for Data Science Pipelines 2023 SIGMOD 5.3688159e-05
8,635 The Key to Effective UDF Optimization: Before Inlining, First Perform Outlining 2025 VLDB 5.2832224e-05
10,259 Towards Resource-adaptive Query Execution in Cloud Native Databases 2024 CIDR 5.0381136e-05
10,260 SQL Engines Excel at the Execution of Imperative Programs 2024 VLDB 5.0381136e-05
13,959 BabbleFlow - A Translator for Analytic Data Flow Programs 2014 SIGMOD -
Previous Page 1 / 1 Next

Semantically Similar Papers