CMU Database Group Courses

Google BigQuery and Dremel - Lecture 19

Explore Google BigQuery and Dremel's architecture, query processing, and performance optimizations in this advanced database systems lecture.

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

Query Optimizer Implementations - Part 2 - Lecture 17

Explore advanced query optimizer implementations, focusing on logical pre-optimization, physical operators, and transformation rules in database systems.

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

Query Optimizer Implementations - Part 1 - Lecture 16

Explore query optimizer implementations, focusing on design decisions, approaches, and techniques used in advanced database systems.

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

Database Networking - Lecture 15

Explore advanced database networking concepts, including distributed systems, network protocols, and optimizing data transfer in large-scale database environments.

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

Server-side Logic Execution and User-defined Functions - Lecture 14

Explore server-side logic execution and user-defined functions in advanced database systems, focusing on implementation techniques and performance optimization strategies.

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

Multi-Way and Worst-Case Optimal Join Algorithms - Lecture 13

Explore advanced multi-way join algorithms and worst-case optimal techniques for efficient query processing in database systems.

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

Parallel Sort-Merge Join Algorithms - Lecture 12

Explore parallel sort-merge join algorithms for advanced database systems, focusing on efficiency and scalability in large-scale data processing.

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

Parallel Hash Join Algorithms - Lecture 11

Explore parallel hash join algorithms for advanced database systems, focusing on efficiency and performance optimization techniques.

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

Query Vectorization vs. Compilation in Advanced Database Systems - Lecture 10

Explore query vectorization and compilation techniques in advanced database systems, comparing their performance and implications for system design.

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

Query Compilation and JIT Code Generation in Advanced Databases - Lecture 9

Explore query compilation and JIT code generation in advanced database systems, focusing on code specialization, holistic compilation, and performance optimization techniques.

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

Vectorized Query Execution with SIMD - Lecture 8

Explore advanced vectorized query execution techniques using SIMD for optimized database performance in this comprehensive lecture by Prof. Andy Pavlo.

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

Query Scheduling in Advanced Database Systems - Lecture 7

Explore query scheduling in advanced database systems, covering process models, memory access, partitioning, and execution strategies for optimal performance.

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

Query Execution and Processing Models - Lecture 6

Explore advanced database query execution and processing models, focusing on efficiency, pipelining, and parallelism in modern database systems.

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

Database Compression - Lecture 5

Explore advanced database compression techniques, their implementation, and impact on system performance in modern DBMS architectures.

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

Analytical Database Indexes - Lecture 4

Explore advanced analytical database indexing techniques for optimizing query performance in OLAP systems. Learn about bitmap, zone maps, and other specialized indexes.

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