Our guest is Prof. Viktor Leis, a Full Professor in the Computer Science Department at the Technical University of Munich. His research revolves around designing high-performance data management systems and includes core database systems topics such as query processing, query optimization, transaction processing, index structures, and storage.
In this episode we discussed a paper that Viktor recently co-authored with Thomas Neumann, titled “A Critique of Modern SQL And A Proposal Towards A Simple and Expressive Query Language”, for CIDR 2024. Beyond the specifics of SQL, many other topics are touched on also including: machine learning in the database, the state of PostgreSQL, and the potential for massive performance gains in the world of practical database systems.
Notes:
[0] https://www.cs.cit.tum.de/dis/team/prof-dr-viktor-leis/
[1] https://www.cidrdb.org/cidr2024/papers/p48-neumann.pdf
[2] https://github.com/neumannt/saneql/
[3] https://www.cs.cit.tum.de/dis/research/leanstore/
[4] https://www.dbos.dev/blog/announcing-dbos
[5] https://db.cs.cmu.edu/courses/
Addendum
This JUXT Cast episode is also available as a podcast across all your favourite platforms.
Happy listening!