CMU Database Group Courses

Introduction to Distributed Databases - Lecture 21

Explore distributed database systems, their architectures, and key concepts for scalable data management across multiple nodes.

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

Database Recovery with ARIES - Lecture 20

Learn database recovery techniques using ARIES algorithm, covering logging, checkpointing, and crash recovery processes for robust and reliable database systems.

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

Gaia: Direct Database Access without Database APIs

Explore direct database access techniques without APIs, enhancing efficiency and flexibility in data management systems.

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

Database Logging and Shadow Paging - Lecture 19

Explore database logging and shadow paging techniques for ensuring data durability and recovery in database systems. Learn implementation strategies and trade-offs.

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

Multi-Version Concurrency Control (MVCC) - Lecture 18

Explore multi-version concurrency control in database systems, covering implementation techniques, trade-offs, and optimizations for efficient transaction management.

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

RisingWave: Reinventing Stream Processing in the Cloud Era

Explore cloud-era stream processing innovations, focusing on state management, failure recovery, and elastic scaling. Learn about tiered storage and challenging problems in the field.

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

Timestamp-Ordering Concurrency Control - Lecture 17

Explore timestamp-ordering concurrency control in database systems, covering key concepts and implementation strategies for efficient transaction management.

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

Two-Phase Locking in Databases - Lecture 16

Explore two-phase locking in databases, covering concepts, implementation, and optimization techniques for concurrent transaction management in database systems.

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

Architecture Insight of OceanBase: A Distributed SQL Database - CMU Database Seminar

Explore OceanBase's distributed SQL database architecture, covering design goals, replication, transactions, HTAP challenges, and performance benchmarks. Gain insights into its implementation for mission-critical systems.

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

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