CMU Database Group Courses

Amazon Redshift Data Warehouse System - Lecture 22

1 review

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
• On-Demand
• 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
• 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

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