PL/SQL Without the PL
Summary: Source-to-source compiler translates user-defined PL/SQL functions with arbitrary control flow into plain SQL via recursive CTEs. Eliminating PL/SQL–SQL context switches yields runtime savings; the demo supports interactive editing, live re-compilation, and visualization of intermediate representations. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Denis Hirn (University of Tübingen)
- 2. Torsten Grust (University of Tübingen)
BibTeX Citation
@inproceedings{hirn_sigmod20,
title = {{PL/SQL Without the PL}},
author = {Hirn, Denis and Grust, Torsten},
series = {{SIGMOD} '20},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3318464.3384678},
url = {https://dl.acm.org/doi/10.1145/3318464.3384678},
year = {2020}
}Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 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 |
| 5,792 | Snakes on a Plan: Compiling Python Functions into Plain SQL Queries | 2022 | SIGMOD | 5.9761316e-05 |
| 6,413 | Functional-Style SQL UDFs With a Capital 'F' | 2020 | SIGMOD | 5.7764365e-05 |
| 8,376 | Optimizing Nested Recursive Queries | 2024 | SIGMOD | 5.3279812e-05 |
| 8,701 | Adaptive Code Generation for Data-Intensive Analytics | 2021 | VLDB | 5.2714222e-05 |
| 9,672 | QURE: AI-Assisted and Automatically Verified UDF Inlining | 2025 | SIGMOD | 5.1267792e-05 |
| 10,260 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB | 5.0381136e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 2 of 2 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 896 | Froid: Optimization of Imperative Programs in a Relational Database | 2018 | VLDB | 0.00013164545 |
| 2,716 | Compiling PL/SQL Away | 2020 | CIDR | 8.0819509e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,282 | Rule-Based Translation of Relational Queries into Iterative Programs | 1986 | SIGMOD |
| 2 | 3,002 | Extracting Equivalent SQL from Imperative Code in Database Applications | 2016 | SIGMOD |
| 3 | 6,413 | Functional-Style SQL UDFs With a Capital 'F' | 2020 | SIGMOD |
| 4 | 14,591 | Supporting Procedural Constructs in SQL Compilers | 1996 | VLDB |
| 5 | 5,792 | Snakes on a Plan: Compiling Python Functions into Plain SQL Queries | 2022 | SIGMOD |
| 6 | 4,544 | Just-in-time compilation for SQL query processing | 2013 | VLDB |
| 7 | 10,260 | SQL Engines Excel at the Execution of Imperative Programs | 2024 | VLDB |
| 8 | 12,604 | Functions Are Data Too (Defunctionalization for PL/SQL) | 2013 | VLDB |
| 9 | 3,190 | One WITH RECURSIVE is Worth Many GOTOs | 2021 | SIGMOD |
| 10 | 2,716 | Compiling PL/SQL Away | 2020 | CIDR |