CMU Database Group Courses

Concurrency Control Theory - Lecture 15

Explore concurrency control theory in database systems, covering transaction management, isolation levels, and conflict resolution techniques.

• YouTube
• 1 hour 24 minutes
• On-Demand
• Free Video

Query Planning and Optimization - Lecture 14

Explore query planning and optimization techniques for database systems, enhancing performance and efficiency in data retrieval and processing.

• YouTube
• 1 hour 23 minutes
• On-Demand
• Free Video

Neon: Serverless PostgreSQL - Separation of Storage and Compute

Explore Neon's serverless PostgreSQL architecture, focusing on storage-compute separation, write-ahead logging, and innovative storage engine design for enhanced database management.

• YouTube
• 59 minutes
• On-Demand
• Free Video

Litestream: Making Single-Node Deployments Cool Again

Explore Litestream's approach to single-node deployments, SQLite's architecture, and database replication strategies for efficient and cost-effective data management.

• YouTube
• 53 minutes
• On-Demand
• Free Video

Parallel Query Execution - Lecture 13

Explore parallel query execution techniques in database systems, enhancing performance and scalability for efficient data processing and retrieval.

• YouTube
• 1 hour 4 minutes
• On-Demand
• Free Video

Query Execution 1 - CMU Intro to Database Systems - Lecture 12

Explore query execution in database systems, covering processing models, access methods, and expression evaluation techniques for efficient data retrieval and manipulation.

• YouTube
• 1 hour 22 minutes
• On-Demand
• Free Video

Join Algorithms - Lecture 11

Explore join algorithms in database systems, covering nested loop joins, sort-merge joins, and hash joins. Learn optimization techniques for efficient query execution.

• YouTube
• 1 hour 24 minutes
• On-Demand
• Free Video

Odyssey - PostgreSQL Connection Proxy

Explore PostgreSQL connection proxy Odyssey, its features, and how it enhances database performance and scalability in this comprehensive seminar.

• YouTube
• 1 hour 8 minutes
• On-Demand
• Free Video

Introduction to Database Systems - Course Overview and Logistics

Explore CMU's Intro to Database Systems course, covering key concepts, logistics, and expectations for a comprehensive understanding of database fundamentals.

• YouTube
• 19 minutes
• On-Demand
• Free Video

Sorting and Aggregation Algorithms in Database Systems - Lecture 11

Explore sorting and aggregation algorithms in database systems, featuring insights on dbt from Drew Banin. Gain practical knowledge on efficient data processing techniques.

• YouTube
• 1 hour 18 minutes
• On-Demand
• Free Video

Accelerating Apache Spark Workloads with Apache DataFusion Comet

Explore Apache DataFusion Comet's potential to enhance Apache Spark performance, optimizing data processing workflows and improving efficiency in large-scale analytics.

• YouTube
• 46 minutes
• On-Demand
• Free Video

Index Concurrency Control - Lecture 10

Explore index concurrency control techniques in database systems, covering locking protocols and optimizations for efficient multi-threaded access to B+tree indexes.

• YouTube
• 1 hour 17 minutes
• On-Demand
• Free Video

Vector Indexes, Inverted Indexes, Filters, and Tries - Lecture 9

Explore advanced indexing techniques including vector indexes, inverted indexes, filters, and tries for efficient database querying and optimization.

• YouTube
• 1 hour 21 minutes
• On-Demand
• Free Video

Apache Arrow DataFusion - A Fast, Embeddable, Modular Analytic Query Engine

Explore Apache Arrow DataFusion's fast, embeddable, and modular analytic query engine capabilities with insights from expert Andrew Lamb.

• YouTube
• 1 hour 7 minutes
• On-Demand
• Free Video

Tree Indexes: B+Trees - Lecture 8

Explore B+Tree structures and their implementation in database systems, focusing on efficient data organization and retrieval techniques.

• YouTube
• 1 hour 22 minutes
• On-Demand
• Free Video