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. [0]
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. [2] Beyond the specifics of SQL, many other topics are touched on also including: machine learning in the database, a critique 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
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
My Favorite Murder with Karen Kilgariff and Georgia Hardstark
My Favorite Murder is a true crime comedy podcast hosted by Karen Kilgariff and Georgia Hardstark. Each week, Karen and Georgia share compelling true crimes and hometown stories from friends and listeners. Since MFM launched in January of 2016, Karen and Georgia have shared their lifelong interest in true crime and have covered stories of infamous serial killers like the Night Stalker, mysterious cold cases, captivating cults, incredible survivor stories and important events from history like the Tulsa race massacre of 1921. My Favorite Murder is part of the Exactly Right podcast network that provides a platform for bold, creative voices to bring to life provocative, entertaining and relatable stories for audiences everywhere. The Exactly Right roster of podcasts covers a variety of topics including historic true crime, comedic interviews and news, science, pop culture and more. Podcasts on the network include Buried Bones with Kate Winkler Dawson and Paul Holes, That's Messed Up: An SVU Podcast, This Podcast Will Kill You, Bananas and more.