Compiling PL/SQL Away

Summary: Compile arbitrary PL/SQL functions, including loops and branching, into equivalent SQL subqueries (iteration → SQL recursion) to remove PL/SQL↔SQL context switches. Embedding function logic into the enclosing query enables global optimization and yields substantial cross-RDBMS speedups, challenging the "PL/SQL is slow" belief. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: haa8317c1709a3a95
Venue: CIDR
Year: 2020
Pagerank: 8.0819509e-05
Overall Rank: 2,716 | 81.80%
DOI: -
PDF: Download (CC BY 3.0)

Incoming Non-self Citations Over Time

Authors

1. Christian Duta (University of Tübingen)
2. Denis Hirn (University of Tübingen)
3. Torsten Grust (University of Tübingen)

BibTeX Citation

@inproceedings{duta_cidr20,
        address = {Amsterdam, Netherlands},
        series = {{CIDR} '20},
        title = {{Compiling PL/SQL Away}},
        booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
        author = {Duta, Christian and Hirn, Denis and Grust, Torsten},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 19 of 19 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,800	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.5999908e-05
3,190	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD	7.5364422e-05
3,654	User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases	2022	VLDB	7.1147757e-05
4,078	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.8028789e-05
5,246	Babelfish: Efficient Execution of Polyglot Queries	2022	VLDB	6.1985833e-05
5,723	Accelerating Python UDFs in Vectorized Query Execution	2022	CIDR	5.9993122e-05
5,792	Snakes on a Plan: Compiling Python Functions into Plain SQL Queries	2022	SIGMOD	5.9761316e-05
5,919	PL/SQL Without the PL	2020	SIGMOD	5.9306506e-05
6,218	YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases	2022	VLDB	5.8292066e-05
6,413	Functional-Style SQL UDFs With a Capital 'F'	2020	SIGMOD	5.7764365e-05
6,586	WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications	2024	SIGMOD	5.7237124e-05
7,471	A Fix for the Fixation on Fixpoints	2023	CIDR	5.503108e-05
8,002	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB	5.3927693e-05
8,230	Architecting a Query Compiler for Spatial Workloads	2020	SIGMOD	5.3577081e-05
8,701	Adaptive Code Generation for Data-Intensive Analytics	2021	VLDB	5.2714222e-05
8,849	Boosting Efficiency of External Pipelines by Blurring Application Boundaries	2022	CIDR	5.2492156e-05
9,729	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB	5.1202393e-05
11,847	To UDFs and Beyond: Demonstration of a Fully Decomposed Data Processor for General Data Wrangling Tasks	2023	VLDB	4.9605343e-05
11,982	Accelerating Complex Analytics using Speculation	2021	CIDR	4.9605343e-05

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
554	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00016487919
896	Froid: Optimization of Imperative Programs in a Relational Database	2018	VLDB	0.00013164545
1,276	Rewriting Procedures for Batched Bindings	2008	VLDB	0.00011210489
12,604	Functions Are Data Too (Defunctionalization for PL/SQL)	2013	VLDB	4.9605343e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	291	Optimization of Dynamic Query Evaluation Plans	1994	SIGMOD
2	14,591	Supporting Procedural Constructs in SQL Compilers	1996	VLDB
3	12,062	Low-Latency Compilation of SQL Queries to Machine Code	2021	VLDB
4	10,260	SQL Engines Excel at the Execution of Imperative Programs	2024	VLDB
5	6,413	Functional-Style SQL UDFs With a Capital 'F'	2020	SIGMOD
6	5,792	Snakes on a Plan: Compiling Python Functions into Plain SQL Queries	2022	SIGMOD
7	12,604	Functions Are Data Too (Defunctionalization for PL/SQL)	2013	VLDB
8	4,544	Just-in-time compilation for SQL query processing	2013	VLDB
9	3,190	One WITH RECURSIVE is Worth Many GOTOs	2021	SIGMOD
10	5,919	PL/SQL Without the PL	2020	SIGMOD