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

Поделиться
HTML-код
  • Опубликовано: 22 дек 2024

Комментарии • 105

  • @RhettTrickett
    @RhettTrickett 5 лет назад +95

    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.

    • @stabgan
      @stabgan 3 года назад +1

      This is so cool

    • @galaxy_mosaic3587
      @galaxy_mosaic3587 2 года назад

      is that what he was talking about at the very end where he said the most important thing to remember about databases? he was giving a history about Wu-Tang Clan? prof is funny

  • @marcoq7160
    @marcoq7160 4 года назад +185

    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

  • @averroez7830
    @averroez7830 4 года назад +57

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

    • @davidcmpeterson
      @davidcmpeterson 2 года назад +3

      Why was he in the bathtub???

    • @kicksomeup6998
      @kicksomeup6998 2 года назад +7

      @@davidcmpeterson Because the bathroom is a man's castle.

    • @markchen7905
      @markchen7905 Год назад +1

      @@kicksomeup6998 ya that 👍🏻

  • @santiagoley6403
    @santiagoley6403 4 года назад +23

    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.

  • @yangyi1732
    @yangyi1732 5 лет назад +144

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

    • @baiwfg2
      @baiwfg2 5 лет назад

      That's really vivid and homophonic.. Ha Ha Ha

  • @AAZinvicto
    @AAZinvicto 4 года назад +32

    starts at 18:20

  • @pfever
    @pfever 4 года назад +16

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

    • @pratekag
      @pratekag 4 года назад +4

      yes. thanks. I got confused.

  • @DJ-bo4pz
    @DJ-bo4pz 5 лет назад +22

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

  • @JohnSundberg
    @JohnSundberg 5 месяцев назад

    @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.

  • @ahmetensar9811
    @ahmetensar9811 4 года назад +31

    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.

    • @danielkurniadi8805
      @danielkurniadi8805 4 года назад +1

      I'm missing the story here. What pop culture he is referring to?

    • @zaynjarvis9443
      @zaynjarvis9443 4 года назад +4

      @@danielkurniadi8805 Wu-Tang clan

    • @sahinsarkar7293
      @sahinsarkar7293 3 года назад +1

      And why is this important? or was it a sarcasm and he just wanted to insert a random anecdote for some reason

    • @minhtruong495
      @minhtruong495 3 месяца назад

      @@sahinsarkar7293 He really likes the wu-tang clan and it's joke that he does references to it.
      He even had given students final exam to name all the members in the 36 chambers album in five minutes.

  • @swyxTV
    @swyxTV 5 лет назад +72

    dude is literally in his bathtub, mad respect

    • @420_gunna
      @420_gunna 4 года назад +1

      swyx in the bildin

    • @swyxTV
      @swyxTV 4 года назад

      @@420_gunna sup

  • @stabgan
    @stabgan 3 года назад +4

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

  • @ehabelbakry8603
    @ehabelbakry8603 Год назад +2

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

  • @boyanglyu66
    @boyanglyu66 Год назад

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

  • @coding3438
    @coding3438 3 года назад +1

    49:03 he must’ve meant cannot have duplicates?

  • @ChaidaIsmail
    @ChaidaIsmail 5 лет назад +81

    Is he, in the bathtub ?!!

  • @TheMC_watcher
    @TheMC_watcher 4 года назад +2

    @48:34 What is the difference between a Data Manipulation Language and a Query Language? I read in Silverschatz book Ch2.5 A query language is a language in which a user requests information from the database. For which they mention SQL to be a Query Language.

    • @杨徐辉
      @杨徐辉 2 года назад +1

      A data-manipulation language (DML) is a language that enables users to access or manipulate data as organized by the appropriate data mode. The types of access are: a. Retrieval of information stored in the database; b. Insertion of new information into the database; c. Deletion of information from the database; d. Modification of information stored in the database. A query is a statement requesting the retrieval of information. The portion of a DML that involves information retrieval is called a query language. Although technically incorrect, it is common practice to use the terms query language and data-manipulation language synonymously.

  • @JamesRouzier
    @JamesRouzier 5 лет назад +2

    He is back baby!

  • @parimi001
    @parimi001 4 года назад +3

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

  • @groundcrewz
    @groundcrewz 9 месяцев назад

    You guys are the best!

  • @randomperson1048
    @randomperson1048 2 года назад

    Great stuff brah, much love and appreciation

  • @Pedro-fd9tv
    @Pedro-fd9tv Год назад

    He says that the NULL value is a member of every domain. But what if i define a column as NOT NULL?

  • @abi-ut9up
    @abi-ut9up 4 года назад +3

    to get comfortable with lecture, what prerequisites we must have to get catch up?

  • @2en1th
    @2en1th 5 лет назад +3

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

  • @wlo2661
    @wlo2661 5 лет назад +6

    can you make your cam smaller because it take a lot of space and hide some content of the video thanks!

  • @vimalk78
    @vimalk78 3 года назад +3

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

  • @plsmaop
    @plsmaop 5 лет назад +2

    i luv the new intro theme

  • @jianghe6536
    @jianghe6536 4 года назад

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

  • @AshishNegi1618
    @AshishNegi1618 4 года назад +3

    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 ..

  • @omaressam3540
    @omaressam3540 Год назад

    What amazing explanation !! 😍😍😍

  • @zikewang6605
    @zikewang6605 3 года назад

    Would you please upload the lecture video of CMU 15-445/645 Fall 2020? Thank you !

  • @libinzhou1285
    @libinzhou1285 4 года назад +2

    I'm trying to use this video to fresh up my memory of elementary DBMS course but I'm so confused about what Andy said at the end

  • @mehakminda5530
    @mehakminda5530 Год назад

    Is intersection and natural join the same?

  • @kicksomeup6998
    @kicksomeup6998 2 года назад

    This professor is really amazing, especially when you consider that he's prolly sitting in his bathtub.

  • @monfera
    @monfera 5 лет назад

    Why are these the tradeoffs for the course? IMO the storage aspect is overemphasized (esp. that it's said to be disk based, which is getting historical) while some others are ignored for the time being (eg. a level of SQL compatibility)

    • @ahmedhusain8911
      @ahmedhusain8911 5 лет назад

      Disk based storage is still used very frequently due to the cost and capacity constraints on SSDs. The industry is a little slower than most others, so I don't think the material you learn here will be obsolete as soon as you might be thinking.

  • @p.z.8355
    @p.z.8355 3 года назад

    What is the Intro Track ?

  • @hossamkhaled7779
    @hossamkhaled7779 4 года назад +1

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

  • @McDeth187
    @McDeth187 4 года назад +1

    2020: Pay me for your bathtub videos!
    2109: LOL

  • @jillli1525
    @jillli1525 3 года назад

    Hi all, just wonder if I need the SQL knowledge and experience before this course?

    • @Roger11265
      @Roger11265 3 года назад

      Maybe just a little knowledge or experience is enough (hope it's not too late for u)

  • @AAZinvicto
    @AAZinvicto 4 года назад

    What is the difference between Natural Join and Inner Join?

    • @drevil7vs13
      @drevil7vs13 4 года назад +2

      It seems to me that from the relational algebra standpoint there is no such thing as _inner join_ or _natural join_ , just "join", which is a _natural join_ in SQL. In SQL, the difference is:
      (1) For inner join you have to specify the join condition, and it does not have to be the equality. In natural join, it is always equality, and it requires similar named columns in both tables.
      (2) Natural join outputs a join column only once, whereas inner join outputs this column twice - from each of the input tables. At least I know that Oracle Database does just that.

  • @omarelnaggar9940
    @omarelnaggar9940 2 года назад

    is this course good for someone who doesn't know anything about database ?

  • @duonghoanghuy8446
    @duonghoanghuy8446 2 года назад

    I don't get his last thing, can anyone explain it :)

    • @TheEighthAct
      @TheEighthAct Год назад

      He is explaining the original members of the music group Wu-Tang Clan which some of the previous examples mentioned.

  • @charles7483
    @charles7483 4 года назад +1

    do I need to learn this to get a data engineer job?

    • @obi3kenobi
      @obi3kenobi 3 года назад

      You probably need other courses he mentioned.

  • @sukantasaha5678
    @sukantasaha5678 3 года назад +3

    why is he in a bathtub? how has he not mentioned anything about sitting in a bathtub?

  • @am5790
    @am5790 4 года назад

    Need to change career path due to current circumstances and considering to work from home. What class should I enroll in since I have no tech oriented CV.

  • @scorerlabs1269
    @scorerlabs1269 4 года назад

    Mad Respect !

  • @HrHTeam
    @HrHTeam 2 года назад

    Who's Matt?

  • @jujijiju6929
    @jujijiju6929 3 года назад +5

    Is that a bathroom? Lmao 😂

  • @春华秋实-f8o
    @春华秋实-f8o 5 лет назад

    welcome back

  • @TheRohkan
    @TheRohkan 4 года назад

    EPIC!! - UnReAL ...

  • @RichardHumulock
    @RichardHumulock Год назад

    This. F&$%ing .RULES.

  • @ziweiliu6381
    @ziweiliu6381 5 лет назад

    awesome

  • @danieljohannbutcher9927
    @danieljohannbutcher9927 4 года назад +1

    The guy in the bathtub anyone is thinking about breaking bad ?

  • @hans7829
    @hans7829 4 года назад +3

    god!!!!????? is this guy in the .....bathroom??????? I dont even know CMU before this video but when i search it online....god....dont even know what should i say...crazy man......

  • @maybenew7293
    @maybenew7293 2 года назад

  • @byeogjiofficial
    @byeogjiofficial 3 года назад

    Thug Prof

  • @mohammadrizvi3326
    @mohammadrizvi3326 2 года назад

    11:49
    36:00

  • @lydiayuna9155
    @lydiayuna9155 2 года назад +4

    Is he sitting in a bathtub ?

  • @codewithovi997
    @codewithovi997 Год назад

    Excellent lecture. Our of curiosity, are you sitting in a bath tub ?

  • @mohamedghafoor3953
    @mohamedghafoor3953 4 года назад

    Boss.

  • @calvinlin6670
    @calvinlin6670 3 года назад

    Wu-Tang !!!

  • @raymondwalsh3138
    @raymondwalsh3138 2 года назад

    Am I trippin, or this guy teaching from a bathtub?

  • @grt05
    @grt05 5 лет назад

    wu tang

  • @TomerBenDavid
    @TomerBenDavid 4 года назад

    :)

  • @Sam-dh7fr
    @Sam-dh7fr Год назад +1

    Are you sitting in the bathroom? Wth is this?

  • @svenrobert84
    @svenrobert84 3 года назад +1

    this is Carnegie Mellon University, right? the 70k a year Carnegie Mellon University? And the teacher for one of the most important subjects in CS sits in a bathtub and drops lines like "your shitty C++ code...". not that the content of the lecture is no good just the looks of it are .... you know.

    • @andypavlo
      @andypavlo 3 года назад +12

      > not that the content of the lecture is no good just the looks of it are .... you know.
      No, I don't know. Please explain what you mean.

    • @__redacted__
      @__redacted__ 3 года назад +5

      If the purpose of paying institutions money is to gain knowledge to get a job, what kind of employer is going to make a hiring decision based on the fact the instructor isn't in a classroom? Like where do you put on a CV or resume or job application "took x course where instructor did not deliver content from an Ivory tower?"
      Its 2021, not 1901. Get off your privileged high horse and stop worrying about the optics and reputation of what _surrounds_ knowledge and worry more about the value of the knowledge itself.

  • @randomcat5262
    @randomcat5262 2 года назад

    @sing1609