CMU Database Group Courses

Amazon Redshift Data Warehouse System - Lecture 22

1 rating

Explore Amazon Redshift's architecture, design principles, and performance optimizations for large-scale data warehousing in this advanced database systems lecture.

• YouTube
• 1 hour 4 minutes
• Self-Paced
• Free Video

ParadeDB - Postgres for Search and Analytics

Explore ParadeDB's integration of search and analytics capabilities into PostgreSQL, enhancing database functionality for modern applications.

• YouTube
• 59 minutes
• Self-Paced
• Free Video

Join Algorithms: Hash, Sort-Merge, Nested Loop Joins - Lecture 12

Learn efficient join algorithms including hash, sort-merge, and nested loop joins for database systems. Explore implementation techniques and performance considerations.

• YouTube
• 1 hour 14 minutes
• Self-Paced
• Free Video

DBSP: Incremental Computation on Streams and Its Applications to Databases

Explore DBSP, a technical approach that unifies incremental computation on streams and databases, presented by Mihai Budiu from feldera.

• YouTube
• 1 hour 18 minutes
• Self-Paced
• Free Video

IBM Starburst Query Rewriter and Optimizer - Lecture 3

Dive into query optimization techniques with IBM Starburst, exploring rewriting strategies and optimization methods for enhanced database performance and efficient query processing.

• YouTube
• 1 hour 14 minutes
• Self-Paced
• Free Video

Join Ordering: Bottom-up Dynamic Programming for Query Optimization - Lecture 7

Dive into advanced database query optimization techniques, focusing on bottom-up join ordering strategies and their implementation in modern database systems.

• YouTube
• 1 hour 9 minutes
• Self-Paced
• Free Video

Cascades Query Optimizer - Lecture 5

Dive into the fundamentals of database query optimization with the Cascades framework, exploring its architecture, implementation strategies, and role in improving database performance.

• YouTube
• 1 hour 27 minutes
• Self-Paced
• Free Video

Query Plan Transformations in Database Query Optimization - Lecture 6

Dive into advanced query plan transformation techniques and optimization strategies for database systems, exploring methods to enhance query performance and execution efficiency.

• YouTube
• 1 hour 21 minutes
• Self-Paced
• Free Video

Join Ordering: Top-Down and Transformational Query Optimization - Lecture 8

Dive into advanced database query optimization techniques, focusing on join ordering strategies and transformational approaches for improved database performance.

• YouTube
• 1 hour 10 minutes
• Self-Paced
• Free Video

TypeScript Stored Procedures for the Modern Age

Explore modern database development through TypeScript stored procedures, examining their evolution, benefits, and practical applications in contemporary software architecture.

• YouTube
• 1 hour 3 minutes
• Self-Paced
• Free Video

Search Parallelization: Bottom-up Approach in Query Optimization - Lecture 9

Dive into advanced database query optimization techniques, focusing on bottom-up search parallelization methods for enhanced system performance and efficiency.

• YouTube
• 1 hour
• Self-Paced
• Free Video

Towards Sanity in Query Languages

Explore the evolution and complexities of database query languages with leading experts Viktor Leis and Thomas Neumann as they discuss modern approaches and solutions for efficient data management.

• YouTube
• 1 hour 3 minutes
• Self-Paced
• Free Video

Search Parallelization: Top-Down in Database Query Optimization - Lecture 10

Dive into advanced query optimization techniques focusing on top-down search parallelization methods for database systems, exploring strategies to enhance query processing performance.

• YouTube
• 1 hour 12 minutes
• Self-Paced
• Free Video

EXODUS and Volcano Query Optimizer Generators - Lecture 4

Delve into query optimization fundamentals with EXODUS and Volcano generators, exploring advanced database system design and optimization techniques for enhanced query processing performance.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Free Video

Optimistic Concurrency Control in Database Systems - Lecture 18

Delve into optimistic concurrency control mechanisms and timestamp ordering protocols in database systems, featuring a special segment on Weaviate vector database implementation.

• YouTube
• 1 hour 21 minutes
• Self-Paced
• Free Video