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
- SIGMOD 2024 (Availability and Reproducibility Committee),
- SIGMOD 2023 (Availability and Reproducibility Committee),
- SIGMOD 2022 (Availability Committee)
Teaching Assistance
Research Supervisor
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
How DuckDB is USING KEY to Unlock Recursive Query Performance
Björn Bamberg • Denis Hirn • Torsten Grust
Proceedings of the 2025 ACM SIGMOD International Conference on Management of Data (SIGMOD'25), June 22–27, 2025, Berlin, Germany. (to be published)
A Reproducible Tutorial on Reproducibility in Database Systems Research
Tim Fischer • Denis 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 Fischer • Denis Hirn • Torsten Grust
PVLDB, Volume 17, No. 13: 4696 - 4708, 2024. doi:10.14778/3704965.3704976
BibTeX Citation
@article{10.14778/3704965.3704976,
author = {Fischer, Tim and Hirn, Denis and Grust, Torsten},
title = {SQL Engines Excel at the Execution of Imperative Programs},
year = {2025},
issue_date = {September 2024},
publisher = {VLDB Endowment},
volume = {17},
number = {13},
issn = {2150-8097},
url = {https://doi.org/10.14778/3704965.3704976},
doi = {10.14778/3704965.3704976},
journal = {Proc. VLDB Endow.},
month = feb,
pages = {4696–4708},
numpages = {13}
}
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 Hirn • Torsten 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
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
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 Hirn • Torsten Grust • Tim 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 Hirn • Torsten 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
Proceedings of the 40th ACM SIGMOD Int’l Conference on Management of Data (SIGMOD 2021), Xi’an, Shaanxi, China, June 2021.