User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases

Summary: Introduces User-Defined Operators (UDOs) to tightly integrate custom algorithms into modern database query engines. Idiomatic code in common languages is plugged directly, avoiding data export, preserving ACID guarantees, and achieving performance competitive with specialized analytics tools. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: hbbc1a05929572b5f
Venue: VLDB
Year: 2022
Pagerank: 7.1383149e-05
Overall Rank: 3,645 | 75.51%
DOI: 10.14778/3510397.3510408
PDF: Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

1. Moritz Sichert (Technical University of Munich)
2. Thomas Neumann (Technical University of Munich)

BibTeX Citation

@article{sichert_vldb22,
        title = {{User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases}},
        author = {Sichert, Moritz and Neumann, Thomas},
        journal = {PVLDB},
        series = {{VLDB} '22},
        volume = {15},
        number = {5},
        pages = {1119--1131},
        doi = {10.14778/3510397.3510408},
        url = {https://doi.org/10.14778/3510397.3510408},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,074	Apache Arrow DataFusion: A Fast, Embeddable, Modular Analytic Query Engine	2024	SIGMOD	6.8175757e-05
6,301	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	5.8167709e-05
6,747	Mitigating the Impedance Mismatch between Prediction Query Execution and Database Engine	2025	SIGMOD	5.6883491e-05
7,988	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	5.4105672e-05
9,483	Query Compilation Without Regrets	2024	SIGMOD	5.1686727e-05
9,700	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	5.1372261e-05
10,229	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB	5.054828e-05
10,832	Decisionhouse: Prescriptive Analytics in the Data Stack	2026	VLDB	4.9769913e-05
10,842	ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling	2026	VLDB	4.9769913e-05
10,893	FlowLog: Efficient and Extensible Datalog via Incrementality	2026	VLDB	4.9769913e-05
10,971	GraphAlg Playground: An Online Platform for Learning and Experimenting with the GraphAlg Language	2026	VLDB	4.9769913e-05
11,142	Scalable Execution of Application Logic within Everest BusinessStore	2025	SIGMOD	4.9769913e-05
11,462	IcedTea: Efficient and Responsive Time-Travel Debugging in Dataflow Systems	2025	VLDB	4.9769913e-05
11,608	Hardware-Efficient Data Imputation through DBMS Extensibility	2024	VLDB	4.9769913e-05
11,803	To UDFs and Beyond: Demonstration of a Fully Decomposed Data Processor for General Data Wrangling Tasks	2023	VLDB	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
14	MonetDB/X100: Hyper-Pipelining Query Execution	2005	CIDR	0.00064013679
21	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00056835296
71	DuckDB: an Embeddable Analytical Database	2019	SIGMOD	0.00037724477
105	The MADlib Analytics Library or MAD Skills, the SQL	2012	VLDB	0.00033633007
215	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00024589307
373	Umbra: A Disk-Based System with In-Memory Performance	2020	CIDR	0.00019705706
1,285	SQL/MapReduce: A practical approach to self-describing, polymorphic, and parallelizable user-defined functions	2009	VLDB	0.0001119616
1,445	An Architecture for Compiling UDF-centric Workflows	2015	VLDB	0.00010628379
1,786	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.6281276e-05
2,251	Evaluating End-to-End Optimization for Data Analytics Applications in Weld	2018	VLDB	8.750953e-05
2,707	Compiling PL/SQL Away	2020	CIDR	8.1073034e-05
3,195	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	7.546228e-05
3,874	DBToaster: A SQL Compiler for High-Performance Delta Processing in Main-Memory Databases	2009	VLDB	6.9506516e-05
4,097	Distributed Deep Learning on Data Systems: A Comparative Analysis of Approaches	2021	VLDB	6.8064316e-05
7,388	Lachesis: Automatic Partitioning for UDF-Centric Analytics	2021	VLDB	5.5355684e-05
8,681	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB	5.288863e-05
9,296	ParaX: Boosting Deep Learning for Big Data Analytics on Many-Core CPUs	2021	VLDB	5.2000636e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,648	UDO: Universal Database Optimization using Reinforcement Learning	2021	VLDB
2	503	Towards a Unified Architecture for in-RDBMS Analytics	2012	SIGMOD
3	2,516	Optimization of Queries with User-defined Predicates	1996	VLDB
4	6,301	Declarative Sub-Operators for Universal Data Processing	2023	VLDB
5	9,704	Using SQL to Build New Aggregates and Extenders for Object-Relational Systems	2000	VLDB
6	5,016	User-Defined Aggregate Functions: Bridging Theory and Practice	2006	SIGMOD
7	9,700	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
8	9,986	One-pass Data Mining Algorithms in a DBMS with UDFs	2011	SIGMOD
9	4,728	User-Defined Table Operators: Enhancing Extensibility for ORDBMS	1999	VLDB
10	7,988	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB