F2023 #13 - Query Execution Part 2 (CMU Intro to Database Systems)

preview_player
Показать описание

15-445/645 Intro to Database Systems (Fall 2023)
Carnegie Mellon University
  1. CMU Database Group
  2. databases
  3. carnegie mellon university
Рекомендации по теме
F2023 #13 - 1:16:20

F2023 #13 - Query Execution Part 2 (CMU Intro to Database Systems)

F2023 #12 - 1:18:33

F2023 #12 - Query Execution Part 1 (CMU Intro to Database Systems)

13 - Query 1:12:52

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

08 - Vectorized 1:15:44

08 - Vectorized Query Execution with SIMD (CMU Advanced Databases / Spring 2023)

06 - Query 1:10:31

06 - Query Execution & Processing Models (CMU Advanced Databases / Spring 2023)

F2023 #14 - 1:18:54

F2023 #14 - Query Planning & Optimization (CMU Intro to Database Systems)

F2023 #05 - 1:23:25

F2023 #05 - Storage Models & Database Compression (CMU Intro to Database Systems)

F2023 #23 - 1:23:01

F2023 #23 - Distributed Data Warehouse OLAP Databases (CMU Intro to Database Systems)

12 - Query 1:21:40

12 - Query Execution 1 (CMU Intro to Database Systems / Fall 2022)

Under the Hood: 0:44:25

Under the Hood: How We're Modernizing Our Query Engine

02 - Modern 0:53:02

02 - Modern Analytical Database Systems (CMU Advanced Databases / Spring 2023)

Introducing Prestissimo, Presto's 0:34:38

Introducing Prestissimo, Presto's Next-Gen Query Execution Engine - Aditi Pandit, Ahana

12 - Query 1:18:18

12 - Query Execution II (CMU Intro to Database Systems / Fall 2021)

F2023 #11 - 1:15:15

F2023 #11 - Join Algorithms (CMU Intro to Database Systems)

14 - Query 1:23:12

14 - Query Planning & Optimization (CMU Intro to Database Systems / Fall 2022)

F2023 #03 - 1:19:11

F2023 #03 - Database Storage Part 1 (CMU Intro to Database Systems)

F2023 #07 - 1:18:46

F2023 #07 - Hash Tables (CMU Intro to Database Systems)

F2023 #20 - 1:24:05

F2023 #20 - Database Recovery (CMU Intro to Database Systems)

Lecture 12 Part 0:03:08

Lecture 12 Part 1 Intro

F2023 #10 - 1:05:24

F2023 #10 - Sorting & Aggregation Algorithms (CMU Intro to Database Systems)

HackTheBox - Health 0:51:17

HackTheBox - Health

Lance: A Modern 0:57:51

Lance: A Modern Columnar Data Format (Chang She)

20 - Databricks 1:07:58

20 - Databricks Photon / Spark SQL (CMU Advanced Databases / Spring 2023)

Velox: An Open-Source 0:22:17

Velox: An Open-Source Unified Execution Engine

Комментарии
Автор

Timestamps:
11:37 - Parallel/Distributed Data Platforms
20:06 - Process Model
21:24 - Process per worker
23:36 - Thread per worker
25:50 - Scheduling
31:05 - SQLOS
36:07 - Embedded DBMS
38:43 - Process Models
40:19 - Inter vs Intra Query Parallelism
42:23 - Inter-query Parallelism
43:49 - Intra-query Parallelism
46:40 - Intra-operator Parallelism
52:55 - Inter-operator Parallelism
1:00:22 - Bushy Parallelism
1:01:39 - I/O Parallelism
1:11:32 - Database partitioning

potapow
Автор

please put microphone on Jignesh. Whenever you move away from the camera, the audio quality drastically decreases.

jinsolkim