CMU Database Group Courses

Database Storage Models and Data Layout - Lecture 3

Explore advanced database storage models, data layouts, and optimization techniques for efficient data management and retrieval in modern systems.

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

Modern Analytical Database Systems - Lecture 2

Explore modern analytical database systems, covering distributed architectures, query execution, and OLAP commoditization in this advanced CMU lecture.

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

History of Databases - Lecture 1

Explore the evolution of database systems from early integrated data stores to modern NewSQL, covering key milestones and technological advancements in data management.

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

Snowflake Database Architecture Overview - Lecture 25

Explore Snowflake's cloud-based database architecture, including query execution, optimization, and workload management, with insights from industry experts.

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

CrateDB - Distributed SQL Database Built on Top of Lucene

Explore CrateDB's architecture, distributed SQL capabilities, and Lucene integration. Learn about its scalability, real-time analytics, and unique features for handling complex data structures.

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

Embedded Database Logic - Lecture 24

Explore embedded database logic concepts, including stored procedures, user-defined functions, and triggers. Learn implementation techniques and their impact on DBMS architecture.

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

Distributed Analytical Database Systems - Lecture 23

Explore distributed analytical database systems, focusing on OLAP architectures, query execution, and optimization techniques for large-scale data processing and analysis.

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

BigQuery: Google's Cloud Data Warehouse - Lecture 24

Explore Google BigQuery's architecture, query processing, and optimization techniques with insights from a leading database systems expert.

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

SplinterDB: A Key-Value Store for Modern Storage Devices - Lecture

Explore SplinterDB, a key-value store optimized for modern storage devices. Learn about its architecture, performance benefits, and comparison with other data structures.

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

Distributed Transactional Database Systems - Lecture 22

Explore distributed transactional database systems, covering coordination, commit protocols, fault tolerance, and replication strategies for robust and scalable data management.

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

TigerBeetle - Magical Memory Tour

Explore TigerBeetle's innovative approach to memory management in database systems, focusing on performance optimization and efficient resource utilization.

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

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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video