24 - Justin Levandoski (Google BigQuery) (CMU Intro to Database Systems / Fall 2021)

Justin Levandoski (justinlevandosk...)
15-445/645 Intro to Database Systems (Fall 2021)
Carnegie Mellon University
15445.courses....

[@CppExpedition]

Impressive the throughput of content Justin inserts into his talk! - very smooth, quite impressive! - Happy to have learn about BigQuery

[@justadataguy]

Introduction (0:00 - 1:58) Why move to cloud databases (0:30 - 1:00) Benefits of cloud databases (1:00 - 1:58) BigQuery (1:58 - 25:22) What is BigQuery (1:58 - 3:00) BigQuery architecture (3:00 - 21:14) Separation of compute and storage (3:00 - 5:20) Architectural design principles (5:20 - 17:40) BigQuery embedded BI engine (17:40 - 21:14) BigQuery data ingestion (21:14 - 25:22) Aurora (25:22 - 47:54) Aurora architecture (25:22 - 42:22) Storage and recovery (25:22 - 38:20) Handling transactions (38:20 - 42:22) Comparison with other systems (42:22 - 47:54) Conclusion and Q&A (47:54 - 1:10:40) Answering audience questions (47:54 - 1:08:40) Closing remarks (1:08:40 - 1:10:40)

[@Matar86]

Great talk