YoVDO

Modern Analytical Database Systems - Lecture 2

Offered By: CMU Database Group via YouTube

Tags

OLAP Courses Cloud Computing Courses Data Warehousing Courses Distributed Systems Courses Database Architecture Courses Columnar Storage Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore modern analytical database systems in this comprehensive lecture from Carnegie Mellon University's Advanced Database Systems course. Delve into distributed query execution, system architectures, and the push vs. pull debate. Examine shared disk implementations, object stores, and the commoditization of OLAP. Investigate system catalogs, query optimizers, file formats, and execution engines. Gain valuable insights from Prof. Andy Pavlo as he covers key concepts and trends in analytical database design and implementation. Access accompanying slides for a deeper understanding of the material presented in this 53-minute video.

Syllabus

Intro
COURSE OUTLINE
DISTRIBUTED QUERY EXECUTION
DISTRIBUTED SYSTEM ARCHITECTURE
PUSH VS. PULL
SHARED DISK
OBJECT STORES
OBSERVATION
OLAP COMMODITIZATION
SYSTEM CATALOGS
QUERY OPTIMIZERS
FILE FORMATS
EXECUTION ENGINES
CONCLUSION
NEXT CLASS


Taught by

CMU Database Group

Related Courses

Scaling Postgres for Time Series Data with Citus
Microsoft via YouTube The Parquet Format and Performance Optimization Opportunities
Databricks via YouTube Powering Interactive Data Applications at Scale
Strange Loop Conference via YouTube Zedstore - Compressed Columnar Storage for Postgres
Linux Foundation via YouTube TiFlash - Make TiKV 10x Faster and HTAP-able
CNCF [Cloud Native Computing Foundation] via YouTube