01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)

15-445/645 Intro to Database Systems (Fall 2019)
Carnegie Mellon University

[RhettTrickett]

The outro track for this video is Shaolin Brew by Wu-Tang Clan. After trying to hunt down this unfamiliar track on the frequently mentioned 36 Chambers and Shazam without success, I ended up finding it was released on the St. Ides Mixtape in 1994, which is also referenced in this video at 21:14. Nice touch.

[marcoq]

2:10 Today's agenda
2:35 Wait list
3:48 Course overview
5:26 Course outline
6:45 Course logistics
8:09 Textbook
9:24 Course rubric
10:03 Homeworks
11:02 Projects
12:55 BusTub
14:50 Late policy
15:40 Plagiarism warning
16:45 Database research

Actual content:
18:12 Databases
19:30 Database example (digital music store)
20:05 Flat file strawman (CSV)
22:37 Flat files: data integrity
24:32 Flat files: implementation [problems]
26:20 Flat files: durability
27:14 Database management system
30:00 Early DBMSs
32:49 Relational model (Edgar F. Codd)
36:48 Data models
37:48 Data model
40:08 Relational model
43:13 Relational model: primary keys
44:58 Relational model: foreign keys
46:36 Data manipulation languages (DML
48:40 Relational algebra
50:00 Relational algebra: select σ
51:50 Relational algebra: projection Π
53:07 Relational algebra: union ∪ (UNION ALL)
54:09 Relational algebra: intersection ∩
54:49 Relational algebra: difference − (EXCEPT)
55:21 Relational algebra: product × (CROSS JOIN)
56:16 Relational algebra: natural join ⋈
57:55 Relational algebra: extra operators (rename ρ, assignment R←S, duplicate elimination δ, aggregation γ, sorting τ, division R÷S)
58:46 Observation: relational algebra still defines the high-level steps of how to compute a query
1:02:03 Relational model: queries
1:04:02 Conclusion
1:05:18 One last thing

[averroez]

Prof. Andy most humble teacher out there, he is literally recording from the bathtub. Respect!

[yangyi]

Recording in the bathtub is the perfect punchline for the name BusTub

[santiagoley]

This guy is a really good teacher. Db was one of my least favorite classes during CS, but at the end of this lecture I'm looking forward to the next video.

[DJ-bopz]

DAMN!!!! I wish I had a professor like him in my college. He is just freaking awesome

[ahmetensar]

The most important thing you need to understand about databases throughout this, through the rest of your life is the following: when you look back at the 36 Chambers, understand who were the original 9 involved in it. You have the RZA, the GZA, Inspectah Deck, Ghostface Killah, Masta Killa, U-God, Method Man, Ol' Dirty Bastard, Raekwon. But, the other important thing too is Cappadonna was in jail at the time, so he was actually an original member of the clan. But because he was in jail, he couldn't be on the 36 Chambers. So, that's the most important thing you need to understand throughout this entire semester.

[pfever]

57:28 I think the professor meant to say "the reason why Natural Join is different than the Intersection" not than difference...?

[swyxTV]

dude is literally in his bathtub, mad respect

[stabgan]

This is my favourite course after David J Malan's Cs50 and I have taken 70+ courses till now

[ehabelbakry]

اللهم صل على محمد وعلى ال محمد كما صليت على ابراهيم وعلى ال ابراهيم انك حميد مجيد اللهم بارك على محمد وعلى ال محمد كما باركت على ابراهيم وعلى ال ابراهيم انك حميد مجيد
😍😍😍😍

[boyanglyu]

I was just a freshman by the time this lecture happened. Time passed so fast

[JohnSundberg]

@49:12 I think a set MUST have unique values, as stated in the video "CANNOT have duplicate values", however - I have seen many tables of data with duplicate data.

[enth]

is it possible to access to the c++ self-assessment/exam that he was talking about?

[parimi]

Amazing way to teach. It’s a good revision for me.

[jianghe]

Great! I could almost fall in love with DBMS now...

[vimalk]

is he... is he lecturing from the bathroom?

[hossamkhaled]

is any different between videos from 2018 and this videos and what i can see 2018 or 2019? Thanks

[randomperson]

Great stuff brah, much love and appreciation

[AshishNegi]

I want to do the course assignments and homework. I see that piazza is for CMU students. I understand that.
Is there any interest in community backed discussion forum ? for questions and help during working on assignments ..