CMU Database Group Courses

Hash Tables in Database Systems - Lecture 7

Explore hash table implementations in database systems and their impact on query processing efficiency. Includes a flash talk on RelationalAI's innovative approach to data management.

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

Memory and Disk I/O Management - Lecture 6

Explore memory and disk I/O management in database systems, covering buffer pool organization, replacement policies, and optimizations for efficient data access and storage.

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

Row vs. Column Storage and Compression in Database Systems - Lecture 5

Explore row vs. column storage, compression techniques, and real-world database applications with insights from CMU's Andy Pavlo and StarTree's Xiang Fu.

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

Database Storage: Log-Structured Merge Trees and Tuples - Lecture 4

Explore log-structured merge trees and tuple storage in databases, covering advanced concepts for efficient data management and organization.

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

Database Storage: Files and Pages - Lecture 3

Explore database storage fundamentals, focusing on file organization and page layouts. Learn from CMU's Andy Pavlo and Neon's Heikki Linnakangas about crucial DBMS concepts.

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

Modern SQL - Lecture 2

Explore advanced SQL concepts and techniques for efficient database management and querying in modern systems.

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

Relational Model and Algebra - Lecture 1

Explore relational models and algebra in database systems. Learn fundamental concepts and operations for efficient data management and querying.

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

Course Overview and Logistics for Intro to Database Systems - Lecture 00

Explore database systems fundamentals with Carnegie Mellon's comprehensive introduction, covering key concepts and practical applications in modern data management.

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

B+Tree Indexes - Lecture 8

Explore B+Tree indexes in database systems, covering structure, operations, and optimizations for efficient data retrieval and management.

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

Hash Tables in Database Systems - Lecture 7

Explore hash table implementations, collision resolution strategies, and dynamic resizing techniques for efficient data storage and retrieval in database systems.

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

OtterTune: AI-Powered Database Optimization as a Service

Explore AI-powered database optimization with OtterTune, revolutionizing performance tuning through machine learning and automation.

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

Database Memory and Disk I/O Management - Lecture 6

Explore database memory and disk I/O management techniques, including buffer pools, page tables, and optimization strategies for efficient data access and performance.

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

Qdrant: Open Source Vector Search Engine and Vector Database

Explore Qdrant, an open-source vector search engine and database. Learn its architecture, capabilities, and applications in machine learning and information retrieval.

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

Storage Models and Database Compression - Lecture 5

Explore storage models and database compression techniques for efficient data management and improved system performance.

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

Database Storage Part 2 - Lecture 4

Explore advanced database storage concepts, including page layouts, tuple storage, and system catalogs in this comprehensive lecture on DBMS internals.

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