Database Systems

From PostgreSQL to DuckDB: Unusual Queries, their Performance, and Readability

Each year, Quassnoi publishes a blog post (https://explainextended.com/) in which a problem is presented and solved using SQL. The problems are usually quite challenging and require a deep understanding of SQL and the underlying database system. Also, for these problems, SQL is typically not the first choice of language to solve them. This thesis aims to port some of these problem solutions to DuckDB, investigate their performance, and compare the readability of the SQL queries.

Contact

Denis Hirn