Denis Hirn

Research Assistant

Universität Tübingen, WSI
Lehrstuhl für Datenbanksysteme
Sand 13
72076 Tübingen
Room B312

+49 7071 29-75485
+49 7071 29-5958

denis.hirn@uni-tuebingen.de
0000-0001-7040-1780

Teaching Assistance

Summer 2024:DB2
Summer 2024:Selected Fun Problems of the ACM Programming Contest (Proseminar)
Summer 2024:Team Project: The Construction of an SASL-Compiler
Winter 2023/24:What Makes the Duck Quack?
Summer 2023:Functional Programming
Summer 2023:Selected Fun Problems of the ACM Programming Contest (Proseminar)
Winter 2022/23:Info 1 (Praktische Informatik 1: Deklarative Programmierung)
Winter 2022/23:SQL is a Programming Language
Summer 2022:DB2
Summer 2022:Teamprojekt: The Construction of an SASL-Compiler
Winter 2021/22:DB1
Winter 2021/22:Functional Programming
Winter 2021/22:Selected Fun Problems of the ACM Programming Contest (Proseminar)
Summer 2021:Informatik 2
Summer 2021:Teamprojekt: The Construction of an SASL-Compiler
Winter 2020/21:Informatik 1
Winter 2020/21:SQL is a Programming Language
Summer 2020:DB 2
Summer 2020:SQL is a Programming Language
Summer 2020:Teamprojekt: The Construction of an SASL-Compiler
Winter 2019/20:Functional Programming
Winter 2019/20:Selected Fun Problems of the ACM Programming Contest (Proseminar)
Winter 2018/19:Informatik 1
Winter 2018/19:Selected Fun Problems of the ACM Programming Contest (Proseminar)
Summer 2018:Teamprojekt: The Construction of an SASL-Compiler

Research Supervisor

2024:Nico FadenBringing ORDINALITY to DuckDB
2024:Björn BambergDuckDB: Improved Support for List Functions
2023:Adrian MüllerExtending WITH RECURSIVE With Multiple Working Tables
2023:Alexander GötzFrom PL/pgSQL to C: What Are the Optimizations?
2022:Phil ElgertCreating a Website with a Static Site Generator
2022:Marcus HuberOptimization of PL/pgSQL Translations Using Batching
2022:Tim FischerByePy: Compilation of Python to SQL
2021:Jonatan BraunExtend SQLite3 with Support for LATERAL Join
2021:Tobias BurghardtFrom Recursion To Iteration: Compiling SQL UDFs with Continuations

Short Biography

  • since May 2018: Research Assistant at the Database Systems Chair
  • Oct 2013 - Sept 2019: Student of Computer Science at University of Tübingen

Recent Publications

Dear User-Defined Functions, Inlining isn't working out so great for us. Let's try batching to make our relationship work. Sincerely, SQL

Kai Franz ☠ • Sam Arch ☠ • Denis HirnTorsten Grust • Todd C. Mowry ☠ • Andy Pavlo ☠

(☠ Carnegie Mellon University)

Proceedings of the 14th Conference on Innovative Data Systems Research (CIDR 2024), Chaminade, CA, USA, January 2024.

Data is Data and Control Should be Data, Too—Compiling Iterative Table-valued PL/SQL UDFs into Recursive SQL Code

Denis Hirn

VLDB 2023 PhD Workshop, co-located with the 49th International Conference on Very Large Data Bases (VLDB 2023), August 28, 2023, Vancouver, Canada

A Fix for the Fixation on Fixpoints

Denis HirnTorsten Grust

Proceedings of the 13th Conference on Innovative Data Systems Research (CIDR 2023), Amsterdam, The Netherlands, January 2023.

Snakes on a Plan — Compiling Python Functions into Plain SQL Queries

Denis HirnTorsten GrustTim Fischer

Proceedings of the 41st ACM SIGMOD Int’l Conference on Management of Data (SIGMOD 2022), Philadelphia, PA, USA, June 2022. doi:10.1145/3514221.3520175

BibTeX Citation
@inproceedings{snakes-on-a-plan,
  author    = {Fischer, Tim and Hirn, Denis and Grust, Torsten},
  title     = {Snakes on a Plan: Compiling Python Functions into Plain SQL Queries},
  year      = {2022},
  isbn      = {9781450392495},
  publisher = {Association for Computing Machinery},
  address   = {New York, NY, USA},
  url       = {https://doi.org/10.1145/3514221.3520175},
  doi       = {10.1145/3514221.3520175},
  booktitle = {Proceedings of the 2022 International Conference on Management of Data},
  pages     = {2389–2392},
  numpages  = {4},
  keywords  = {SQL, compilation, python, recursion, user-defined functions},
  location  = {Philadelphia, PA, USA},
  series    = {SIGMOD '22}
}

Functional Programming on Top of SQL Engines

Tobias Burghardt • Denis HirnTorsten Grust

Proceedings of the 24th International Symposium on Practical Aspects of Declarative Languages (PADL 2022), Philadelphia, PA, USA, January 2022. https://doi.org/10.1007/978-3-030-94479-7_5.

One WITH RECURSIVE Is Worth Many GOTOs

Denis HirnTorsten Grust

Proceedings of the 40th ACM SIGMOD Int’l Conference on Management of Data (SIGMOD 2021), Xi’an, Shaanxi, China, June 2021.

PL/SQL Without the PL

Denis HirnTorsten Grust

Proceedings of the 39th ACM SIGMOD Int’l Conference on Management of Data (SIGMOD 2020), Portland, Oregon, USA, June 2020.

Compiling PL/SQL Away

Denis HirnTorsten GrustChristian Duta

Proceedings of the 10th Conference on Innovative Data Systems Research (CIDR 2020), Amsterdam, The Netherlands, January 2020.

PgCuckoo — Laying Plan Eggs Into PostgreSQL's Nest

Denis HirnTorsten Grust

Proceedings of the 38th ACM SIGMOD Int’l Conference on the Management of Data (SIGMOD 2019), Amsterdam, The Netherlands, June 2019.

PgCuckoo – Injecting Physical Plans into PostgreSQL

Denis Hirn

Proceedings of the 18th Conference on Database Systems for Business, Technology, and Web (BTW 2019), Rostock, Germany, March 2019.

More Publications