Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Query Execution and Processing Models - Lecture 6

CMU Database Group via YouTube

Overview

Coursera Plus Monthly Sale: All Certificates & Courses 40% Off!
Explore advanced database concepts in this lecture on query execution and processing models from Carnegie Mellon University's Advanced Database Systems course. Delve into topics such as reducing instruction count, query language pipelines, the X100 system, materialization models, and parallel query execution. Learn about push-based approaches, inter-quarter parallelism, and parallelization within a single query. Gain insights from Professor Andy Pavlo's expertise as he covers database system engineering, dependencies, and potential pitfalls in query execution. Access accompanying slides for a comprehensive understanding of these advanced database topics.

Syllabus

Introduction
Database System Engineering
Reducing Instruction Count
Query Language
Pipelines
Agenda
X100
Crash Course
Dependencies
When it goes wrong
Simple query
Postgres
Pipeline Model
Materialization Model
Top to Bottom
PushBased Approach
Parallel Query Execution
InterQuarter parallelism
Parallelization within a single query

Taught by

CMU Database Group

Reviews

Start your review of Query Execution and Processing Models - Lecture 6

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.