13 - Query Execution II (CMU Databases Systems / Fall 2019)

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

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

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

    in 36:55, I am confused. Select * from A where A.value > 99; You first step1 is bring table A from disk to memory then do the filter operation. I don't think parallelism here.

  • @shuheikitagawa8472
    @shuheikitagawa8472 4 года назад +5

    Finally, I can hear hit it again.

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

    We can have Coroutine per DBMS Worker I guess.

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

    For distributed systems, the query planning is usually the same?
    the gather, repartition and distribute looks like map and shuffle from spark

    • @andypavlo
      @andypavlo 5 лет назад +15

      Because it is the same. This terminology comes from the early distributed databases from the 1980s + 1990s, well *before* Spark was invented. See these papers:
      dl.acm.org/citation.cfm?id=1559865
      people.eecs.berkeley.edu/~brewer/cs262/5-dewittgray92.pdf

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

    I hope they did well on the exam.

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

    'coroutine' tech should be mentioned in this part?

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

    Teradata is massively parallel processing database. Any specific reason for not mentioning Teradata anywhere in your classes? I dint see even a single instance so far as such.

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

      lol.. he mentions it in next lecture.. around 3:20 ruclips.net/video/28hSVkOs6x8/видео.html

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

    Why that guy has so many questions????

    • @HarshKapadia
      @HarshKapadia 4 года назад +8

      Why not!?

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

      because he has a fully functioning brain

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

      Some of his questions are really stupid. His classmates all have well functioning brain and they don't ask so many stupid questions every single class.

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

      就你个中国人事儿多,偷学老外课程,话还贼多