Database Research Group

WSI – Database Systems Research Group

Optimization of PL/pgSQL Translations Using Batching


Our compilation approach compiles PL/SQL UDFs to plain SQL queries. We use trampolined style to compile arbitrarily nested iterative control flow in PL/SQL into SQL's recursive common table expressions.

Batched execution of function invocations as well as using multiple recursive anchors potentially improves performance of these translations. After manually compiling several examples, an experimental run-time evaluation should clarify in which cases batching improves performance.


MSc

Contact: Denis Hirn

Assigned to: Marcus Huber