Andy Pavlo (www.cs.cmu.edu...) Slides: 15445.courses.... Notes 15445.courses.... 15-445/645 Intro to Database Systems (Fall 2022) Carnegie Mellon University 15445.courses....
Пікірлер: 107
@nandeng266 Жыл бұрын
This class has become the actual ramp-up tutorials in many database teams to train new hires. Kudos, Andy!
@Ajax222able8 ай бұрын
i am from 2024. companies who hire untrained people are no more
@parrampampam7 ай бұрын
GP didn't say they hire untrained people, just that they train their new hires @@Ajax222able
@Onedeag-qw3yc5 ай бұрын
@@Ajax222able lmfao too true
@abdulrahmanXSO254 ай бұрын
@@Ajax222able LOL
@bolinsun95652 жыл бұрын
I was so thrilled when I discovered that all the lectures and projects would be public... Thanks Prof. Pavlo for making such a great course public!
@srikkulk Жыл бұрын
PXWVR5 this courseID is invalid is what gradescope is saying.
@haibararara2754 Жыл бұрын
@@srikkulk choose CMU instead of your own school
@mostafamohammed5684 Жыл бұрын
@@haibararara2754 Thank you a lot♥
@Yopperpo2 жыл бұрын
Thank you for all the work you and your group does to record, edit, and upload this class every semester.
@3042640426 Жыл бұрын
Thank you so much. I don't have a CS degree, but I have self-learned and now I am a developer who needs to pick up fundamental CS knowledge. You have just saved my life. Thank you.
@alang.20549 ай бұрын
Everyone is self learned, even if you have a CS degree the knowledge isn't magically injected into your brain
@NostraDavid22 ай бұрын
Fun fact: E. F. "Ted" Codd, aka the Coddfather, invented the Relational Model (relations, tuples, domains; primary key, foreign key), but also the first query language for his model (ALPHA), the term "data model" and the term OLAP. He was also highly critical of SQL (calling it Fatally Flawed back in 1985) because it broke a bunch of consistency, which STILL hasn't really been fixed (like allowing duplicate rows, and returning anything thats not a relation (like a single row, a column or a single scalar/cell value). I've read all the publicly available letters he wrote BTW. Good stuff. Even his criticisms on the Entity-Relation Model from the 1976 (?) by Peter Chen, IIRC.
@robertcannon3190 Жыл бұрын
That kid walking out because of the blockchain assertion is insane...
@johnw.8782 Жыл бұрын
I'm surprised you're the only one to comment on that. Talk about entitled douchery.
@errelin132610 ай бұрын
This class is amazing. The course at my Univ is to spend one lecture on SQL and then they throw it away and focus on EER or other database theories. 3 or 4 weeks later, suddenly they come back and start looking at relational algebra. I dont like it. I even got the wrong impression that relation algebra was invented later than SQL ... It's always good to introduce closely related concepts together, like this class does, unless it is absolutely necessary to break them apart. Thank you Andy. Awesome content!
@gameunit3935 Жыл бұрын
im very lucky i found this course.. I have been struggling to find a good course like this on the internet.. thank you very much..! you have no idea how this helps to college dropouts like myself..
@sanyamchaudhary2 жыл бұрын
thank you for the great class! you are a great teacher! Congrats to everyone involved in producing the course!
@abtiwary10 ай бұрын
Thank you so much for making this content available to those of us who can't attend your excellent classes in person! This is awesome material!
@NostraDavid22 ай бұрын
Yes, in the Relational Model there are no duplicates within any single relation, and if you join two relations the result is a new relation which as any other relation does not contain duplicate rows. That's why there is no popular RDBMS in existence, since Postgres, DB2, Oracle, etc all allow duplicate rows and thus are not truly relational.
@Max-my6rk2 жыл бұрын
First! King is back!🎉
@michaelxu11682 жыл бұрын
Actually attending this course for Alex Chi🥰🥰🥰~ Take me away~
@TeaLeavesProgramming2 жыл бұрын
What was the deal with the blockchain kook who interrupted and went on a rant and then stormed out at around 25 minutes in? Was that a student, or just some random person?
@Paul-fn2wb2 жыл бұрын
I strongly suspect it was DJ Drop Tables.
@itallstartedwhen2 жыл бұрын
Whoever he was, he was definitely on something extremely strong 🍀🍀🍀🍀🍀🍀
@jeanshawn Жыл бұрын
LMFAO
@and1play5 Жыл бұрын
You're right, a blockchain is ultimately just a system - it's the distributed ledger mechanism that provides certain properties like immutability, decentralization, and consensus. But in order to actually store and transact data on the blockchain, you need a few additional components: 1. A data model - This defines the structure and relationships of the data you want to store on the blockchain. For Bitcoin, the data model defines transactions, blocks, addresses, etc. For Ethereum, the data model includes accounts, smart contracts, tokens, etc. The data model determines how data elements relate to each other and the rules around transacting with the data. 2. A format for representing the data - Things like JSON, XML, CSV, etc. The format determines how the data elements defined in the data model are encoded into strings that can be stored on the blockchain. 3. APIs and interfaces - These provide a way for users and applications to read and write data to the blockchain. For example, Bitcoin has APIs to create transactions, get wallet balances, etc. Ethereum has APIs for deploying and executing smart contracts. 4. Consensus rules - The consensus algorithm, like proof-of-work or proof-of-stake, maintains agreement between nodes about the state of the data and ensures only valid transactions/data are recorded on the blockchain. 5. Node software - The blockchain client software that implements the data model, formats, APIs, consensus rules, and runs on the nodes that maintain the network. For Bitcoin, this is reference implementations like Bitcoin Core. For Ethereum, it's clients like Geth and Parity. So you're right that a blockchain alone is just a distributed ledger mechanism. All of these additional components - the data model, formats, interfaces, rules, and node software - build on top of the blockchain and are needed to actually implement a usable ledger system, whether it's for recording transactions, smart contracts, identity data, or anything else. The blockchain provides the foundation, but you need to construct a lot on top of it!
@coffle18 күн бұрын
LLM response lol
@bestinference10 ай бұрын
Not related CMU student or anything, just learning. Thank you, sir. Thank you so much.
@jamesjian8868 Жыл бұрын
a DJ?! This is a badass professor. so fxxking cool.
@BULLSHXTYT2 жыл бұрын
I am not sure but the audio does not seem to be great.
@andypavlo2 жыл бұрын
The recording software picked up the wrong mic and its noise suppression filter heavily compressed the audio. I will fix in the next class.
@howardzhang66552 жыл бұрын
@@andypavlo thanks!!
@mailoisback4 ай бұрын
How would you guys recommend studying this? Watch only the lectures or also read the textbook that they recommend and in which order? Thanks!
@sorontar1 Жыл бұрын
39:00 i think the difference becomes important in replication. Given many-many relationship realised on array column, one would need to violate fk constraint. With itermediate table, one can copy records row by row.
@and1play5 Жыл бұрын
teacher is right, blockchain is not a data model, ethereum uses rocksDB
@egemensentin4 ай бұрын
I've used and coded for IMS, and it still has utility where it's used - definitely not "crap from that time". It is highly probable that the system that keeps the professor's checking account uses IMS rather than an RDBMS, and that is due to unmatched reliability of these systems.
@NostraDavid22 ай бұрын
>unmatched reliability Citation needed. Yeah, it better be reliable after 58-some years existence, but is it really unmatched against DB2 or Oracle?
@shuyanli4279 Жыл бұрын
Can start the lecture from 5:30
@georgeyu2233 Жыл бұрын
Thank you for the great class! Thank you Andy! Thank you CMU!
@TheRavidj Жыл бұрын
The lecture starts at 10:58
@ahmadkelany Жыл бұрын
@07:49 for people outside CMU wanting to do the assignments.
@ben22582 жыл бұрын
Just a heads up, the playlist this video is part of (CMU Intro to Database Systems (15-445/645 - Fall 2021)) should probably say 2022 instead of 2021.
@ShadKhan2 жыл бұрын
Thanks professor for making these available publicly. Really appreciate this. Is there any way to reduce the size of class recording so that the slides are not cut off from the video.
@Paul-fn2wb2 жыл бұрын
It's great to see Andy on the video! You can always download slides from the course site, if there's something important you can't see on the video. Well, maybe it would be alright to cut the classroom video at the top a bit, as there's not much useful stuff going on there.
@andypavlo2 жыл бұрын
I will see if I can tweak the webcam resolution. The slides are here: 15445.courses.cs.cmu.edu/fall2022/slides/01-introduction.pdf
@ShadKhan2 жыл бұрын
I just downloaded the slides and that works too. Thanks for the suggestion.
@CM_CM_ Жыл бұрын
To those in the comments who might be more knowledgable - is this course still useful for those who do not know C++ - I know some SQL and I'm learning python but C++ looks a little too advanced for me to get into - can these database systems be written in another language or is c++ the most commonly used in industry? I think understanding the algorithms and tables/index types would be useful but I don't know enough about DE to understanding if it would be relevant without the C++ background.
@verdantblast Жыл бұрын
You can spend a few days learning some basic modern C++(note: Modern C++, which has some “smart pointer” things) and then see if you can complete . The following is my personal opinion, which may be incorrect: this course is about "implementation", you need to dity your hands for better understanding, and, dbs is a system, not some piecemeal algorithms, it's a combination of algorithms, data structures, and some OS concepts(concurrent, storage...). So you may need a basic project to assist you in grasping such a huge system. This course offers us the ”bustub“, it is written in c++, so c++ knowledge is required.
@NostraDavid22 ай бұрын
As long as the language you use is Turing Complete (which both cpp and Python are), then you can program anything in either language. The Python version is likely to be slower, but that's fine if you just want to learn.
@parkma40172 жыл бұрын
Great! Think you for the great class!
@crc31725 ай бұрын
Is this really the normal speed? LOL
@badrphone23933 ай бұрын
isn't sql would do a linear scan when searching for a tuple ?
@Ahmad_Al-Deeb8 ай бұрын
46:00 It's confusing how in SQL, SELECT do selection for attributes, While SELECT definition in in Relational Algebra is to do selection for tuples instead.
@NostraDavid22 ай бұрын
SQL is confusing, period.
@mohamedadel-tw8sf Жыл бұрын
whats the prerequisites for this course ?
@youssifsoliman21746 ай бұрын
I only know some sql basics, will I be able to go through this course or will be a bit hard to understand ? Do i need to be familiar with c++ ?
@picanteverde11 ай бұрын
🙏thank you! Just thank you
@kosmonautofficial2965 ай бұрын
I’m a startup and I want to use IMS 😎
@yw419 Жыл бұрын
I like how some guy just iniststed that blockchain should be a data model :)
@gackerman99 Жыл бұрын
can't believe CMU has to deal with hallucinating crypto fanatics. I guess bad ideas can take hold of otherwise intelligent people, but it's hard to understand how
@nickfrase2406 Жыл бұрын
because they think they can have millions in their 20s
@PKAnon2 жыл бұрын
24:50 LMAO
@chantata Жыл бұрын
thank you for sharing class!
@mohsenabdelbaset Жыл бұрын
thanks Andy, that is a great jop
@yrysf7777 ай бұрын
what is name of the song at the end ?
@MarkHarrison-rp2tq10 ай бұрын
@9:45 you don't wanna go to Warner Hall!
@nanunsaram Жыл бұрын
Thank you so much!!
@bagaichi5750 Жыл бұрын
New intro is 🔥
@allencheri9286 Жыл бұрын
pretty good, thanks~
@astromilitary-doctrine Жыл бұрын
They show the intro every video 😊.
@exoneuromancer1672 Жыл бұрын
THIS IS GREAT
@daileo32158 күн бұрын
The blockchain guy is hilarious. I certify him as blockchain evangelist.
@sherrywang4233 Жыл бұрын
omg it's in the same room this semester too
@Mohamed-Ali7473 ай бұрын
thanks
@danishmehmood6110 Жыл бұрын
bro whats that intro music ,i need it
@HSN.LTD0824 Жыл бұрын
If you can't pick him, change the Playback speed to 0.75. Thank me later 😉
@rachidfakhfakh1361 Жыл бұрын
Now can follow, but then I feel like I am with 25% less mental capable than the average class 😅
what‘s wrong with the blockchain, why those student like mentioning it for several times?
@NostraDavid22 ай бұрын
Oh gods, SQL's natural join compares the NAMES of the columns? That's awful and another point of evidence why SQL Relational Model. It's why Codd hammered on the idea of using shared Domains to join on, not shared column names. SQL, what a joke! 😂
@stan-15 Жыл бұрын
man, what an intro😂
@tarunthakur713 Жыл бұрын
the intro though....
@mudassartehseen80174 ай бұрын
black rook goes e8
@kokoinmars6 ай бұрын
Blockchain is literally the future though... Later in the lecture 27:30 .. hearing that did he influence Gensler in some way?
@AngeloComedy3 ай бұрын
it really isn't
@kokoinmars2 ай бұрын
@@AngeloComedy It kind of is because some of us don't like the US but like the international financial system that the USD provides.
@AngeloComedy2 ай бұрын
@@kokoinmars read karl marx
@yicain7562 жыл бұрын
yo!
@saharlogmari1622 Жыл бұрын
Get stoned
@Paul-fn2wb2 жыл бұрын
BCMSs (blockchain management systems) is the next generation of DBMSs that will fix all the problems of our era.
@hdrkn5247 Жыл бұрын
okay, where can I learn more about that?
@yutoobe123 Жыл бұрын
It's Web Scale! kzbin.info/www/bejne/mGOpXnd_qb2nkNU
@juan-tj1xf Жыл бұрын
100 Respect BlockChain guy :)
@AngeloComedy3 ай бұрын
apes together strong
@Algoritmik Жыл бұрын
This is a course misses nothing, but should be missing the mask.
@meryplays8952 Жыл бұрын
Yeap. I cannot hear him and masks give bad impression.
@raphaeldwain7834 Жыл бұрын
What's the bad impression? 😂
@NostraDavid22 ай бұрын
@@raphaeldwain7834oh no, he didn't want his students to be possibly infected! 😂