<https db cs cmu edu papers 2024 whatgoesaround sigmodrec202 Kedro #resources

Join Slack Communities

<https://db.cs.cmu.edu/papers/2024/whatgoesaround-...

# resources

Nok Lam Chan

07/10/2024, 12:33 PM

https://db.cs.cmu.edu/papers/2024/whatgoesaround-sigmodrec2024.pdf An overview of current database landscape

Juan Luis

07/10/2024, 12:35 PM

Many systems that started out rejecting the RM with much fanfare (think NoSQL) now expose a SQL-like interface for RM databases. Such systems are now on a path to convergence with RDBMSs.

Nok Lam Chan

07/10/2024, 12:42 PM

Do not ignore the out-of-box experience. One of the salient selling points of many non-relational DBMSs is a better “out-of-box” experience than RDBMSs. Most SQL systems require one first to create a database and then define their tables before they can load data. This is why data scientists use Python notebooks to analyze data files quickly. Every DBMS should, therefore, make it easy to perform in situ processing of local and cloudstorage files. DuckDB’s rising popularity is partly due to its ability to do this well.

💯 1

Juan Luis

07/10/2024, 12:46 PM

from the summary, looks like the only DB type that will not be displaced by RDBMSs are indeed Array workloads for scientific data. good to see that SQL:2023 added so many interesting features, wondering when those will be adopted by e.g. PostgreSQL

Juan Luis

07/10/2024, 12:46 PM

thanks for sharing @Nok Lam Chan!

🥳 1

Nok Lam Chan

07/10/2024, 12:47 PM

^Andy (one of the author) has THE BEST online database courses on Youtube

👀 1

Juan Luis

07/10/2024, 12:53 PM

also