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

Program Committees

Teaching Assistance

Winter 2024/25:Informatik 1
Winter 2024/25:SQL is a Programming Language
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:Matthis NoelBachelor ThesisExecution Visualized: Shareable Plan Visualization for DuckDB based on PEV2
2024:Robert StahlBachelor ThesisExtend JSON Path Expressions in DuckDB
2024:Ann-Kathrin ClaessensMaster ThesisFrom PostgreSQL to DuckDB: Unusual Queries, their Performance, and Readability
2024:Xenia WetzelStudent Research ProjectPL/pgSQL Frontend for Flummi
2024:Nico FadenBachelor ThesisBringing ORDINALITY to DuckDB
2024:Björn BambergMaster ThesisDuckDB: Improved Support for List Functions
2023:Adrian MüllerMaster ThesisExtending WITH RECURSIVE With Multiple Working Tables
2023:Alexander GötzBachelor ThesisFrom PL/pgSQL to C: What Are the Optimizations?
2023:Romain CarlStudent Research ProjectEXCLUDE for window functions and range as table in-out function in DuckDB
2022:Phil ElgertMaster ThesisCreating a Website with a Static Site Generator
2022:Marcus HuberMaster ThesisOptimization of PL/pgSQL Translations Using Batching
2022:Tim FischerMaster ThesisByePy: Compilation of Python to SQL
2021:Jonatan BraunMaster ThesisExtend SQLite3 with Support for LATERAL Join
2021:Tobias BurghardtMaster ThesisFrom 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

A Reproducible Tutorial on Reproducibility in Database Systems Research

Tim FischerDenis Hirn • Gökhan Kul

VLDB 2024, 50th International Conference on Very Large Data Bases (VLDB 2024), August 26, 2024, Guangzhou, China

SQL Engines Excel at the Execution of Imperative Programs

Tim FischerDenis HirnTorsten Grust

VLDB 2025, 51th International Conference on Very Large Data Bases (VLDB 2025), September 1, 2025, London, United Kingdom (to be published)

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.

More Publications