01 - History of Databases (CMU Advanced Databases / Spring 2023)

15-721 Advanced Database Systems (Spring 2023)
Carnegie Mellon University

[bagaichi]

Watching Prof Pavlo's lectures is the best part of my day.

[sui-chan.wa.kyou.mo.chiisai]

Thanks Andy for open this course for everyone on Youtube!

[souryabhattacharya]

Here after watching Intro to DB systems fall 22!

Thanks for everything and you're an absolute legend Prof Pavlo!!

[jM_JSs]

I love that bipping is not always on time, and interestingly the subtitles avoid the bipped words 😀

Btw the content is super awesome, I have been working on dbs for around 6 years and I missed this kind of overview.

[johnvkew]

SQL2023 including Cypher is a testament that a declarative graph query language is needed in-addition to a relational query language.

It’s like me claiming I only eat turkey at Thanksgiving when I stuffed that turkey with a pig and a pigeon and a bunny.

The wholesale inclusion of a graph data model in the sql standard is kind of an admission that the relational and graph models are both quite useful in their own ways.

[system]

I love this part 😁

"Andy is not aware of a blockchain usecase that could not also be solved with a "traditional" OLTP DBMS and/or external policies (e.g., authentication)."

[cxjdwtt]

AFAIK ArangoDB is also a graph system (missing on the slide, or maybe hidden in the bottom-right)

[ProgrammingBrain]

Great video. MariaDB Xpand (formerly Clustrix) is a Distributed SQL database, btw. Growing in adoption.

[xcffee_]

Very wonderful first lesson!

My question about the blockchain databases would be how would you solve the problem of storing let's say people consent on your database in a way that you can prove to the customer that you didn't change or hinder the data?

We used a blockchain database as a checksum and trust provider while querying the data on a more standard DB

[TobiasFrei]

To my knowledge IDS has been used in industry for a long time. See Bull's GCOS with IDS/II.

[samuelswatson]

Does anyone know where I can find the "paper that came out last week" that shows that DuckDB outperforming Neo4j by a factor of 10 on graph workloads? I'm interesting in checking it out.

[bavideomaker]

What about the pure MOLAP’s and financial modeling databases like Essbase, Hyperion, TM1. Plus Cognos PowerPlay, SQL Server Analysis Services?

[morganbutrovich]

I found this to be a generally comprehensive and thorough talk. However, you neglected to mention the important historical event of Taylor Swift breaking Ticketmaster’s database on Nov 15, 2022. Not sure any history of databases lecture can be considered complete without this.

[xcffee_]

What about Elasticsearch? Isn't that much faster than a RDBS for its purpose?

[VeronicaSantos]

Where can I find "What Goes Around Comes Around... And Around..."?

[danielritter]

Brilliant as always! (SQL/PCG > SQL/PQG, “property graph queries”?)

[sorontar]

Where can I find this 2023 paper "what goes around comes around and around" ?

[vicsteiner]

Nice the classic supplier and parts example from C. J. Date’s books. Thanks for sharing! I do have a question that haunts me so I’ll share it and maybe someone can help me. I started reading E. F. Codd, that led me to reading C. J. Date, H. Darwen, D. McGoveran and F. Pascal. Those authors have a lot of criticism on SQL as not being a correct implementation of the relational data model (bags and not relations, NULL and 3V logic, bad support for integrity constraints, user defined type and type inheritance etc) but then I can not find a clear response to these criticism. Is that the case that the industry simply ignored it or are there answers to it? Are there other authors answering and or challenging these critics that you could share with me?

[souryabhattacharya]

Hey when's the next lecture coming out?

[yeargun]

my guy is (very) cool
ice cube2 if you will