CMU Database Systems - 13 Query Optimization (Fall 2017)
14
CMU Database Systems - 14 Parallel Execution (Fall 2017)
15
CMU Database Systems - 15 Embedded Database Logic (Fall 2017)
16
CMU Database Systems - 16 Concurrency Control Theory (Fall 2017)
17
CMU Database Systems - 17 Two-Phase Locking (Fall 2017)
18
CMU Database Systems - 18 Index Concurrency Control (Fall 2017)
19
CMU Database Systems - 19 Timestamp Ordering Concurrency Control (Fall 2017)
20
CMU Database Systems - 20 Multi-Version Concurrency Control (Fall 2017)
21
CMU Database Systems - 21 Logging Schemes (Fall 2017)
22
CMU Database Systems - 22 Database Recovery (Fall 2017)
23
CMU Database Systems - 23 Distributed OLTP Systems (Fall 2017)
24
CMU Database Systems - 24 Distributed OLAP Systems (Fall 2017)
25
CMU Database Systems - 25 Barry Morris [NuoDB] (Fall 2017)
Description:
Dive into the world of database systems with this comprehensive lecture series from Carnegie Mellon University's Fall 2017 course. Learn about relational data models, SQL, database storage, query processing, concurrency control, and distributed systems. Explore topics ranging from basic concepts to advanced techniques, including functional dependencies, normal forms, buffer pools, hash tables, query optimization, and recovery schemes. Gain insights into both online transaction processing (OLTP) and online analytical processing (OLAP) systems. The series concludes with a guest lecture by Barry Morris from NuoDB, offering real-world perspectives on database technologies.