Advanced Database Systems

Overview This course is a comprehensive study of the internals of modern database management systems. It will cover the core concepts and fundamentals of the components that are used in both high-performance transaction processing systems (OLTP) and large-scale analytical systems (OLAP). The class will stress both efficiency and correctness of the implementation of these ideas. All class projects will be in the context of a real in-memory, multi-core database system. The course is appropriate for graduate students in software systems and for advanced undergraduates with dirty systems programming skills.

Beginner 0(0 Ratings) 0 Students enrolled English
Created by skill expert
Last updated Sat, 11-Jun-2022
+ View more
Course overview
Lecture Details

Slides PDF: http://15721.courses.cs.cmu.edu/spring2018/slides/01-intro.pdf
Notes PDF: http://15721.courses.cs.cmu.edu/spring2018/notes/01-intro.pdf
Reading List: http://15721.courses.cs.cmu.edu/spring2018/schedule.html#jan-17-2018

Andy Pavlo (http://www.cs.cmu.edu/~pavlo/)
15-721 Advanced Database Systems (Spring 2018)
Carnegie Mellon University

Curriculum for this course
25 Lessons 31:14:03 Hours
Lecture
25 Lessons 31:14:03 Hours
  • Course Information & History of Databases
    Preview 01:11:24
  • In-Memory Databases
    01:20:55
  • Query Compilation
    01:21:44
  • Optimistic Concurrency Control
    01:22:33
  • Multi-Version Concurrency Control Part I
    01:24:19
  • Multi-Version Concurrency Control Part II
    01:13:07
  • Index Locking & Latching
    01:01:22
  • OLTP Indexes Part I
    01:21:59
  • OLTP Indexes Part II
    01:04:31
  • Storage Models & Data Layout
    01:13:18
  • System Catalogs & Database Compression
    01:19:30
  • Logging Protocols
    01:18:19
  • Database Checkpoints
    01:16:01
  • Networking
    01:16:59
  • Optimizer Implementation Part I
    01:19:39
  • Optimizer Implementation Part II
    01:14:39
  • Cost Models
    01:12:54
  • Query Execution & Scheduling
    01:23:35
  • Parallel Hash Join Algorithms
    01:21:13
  • Parallel Sort-Merge Join Algorithms
    01:20:09
  • Vectorized Query Execution Part I
    01:17:24
  • Vectorized Query Execution Part II
    00:38:50
  • Larger-than-Memory Databases
    01:06:35
  • Databases on New Hardware
    01:12:42
  • Ashish Motivala [Snowflake]
    01:20:22
+ View more
Other related courses
01:51:15 Hours
Updated Tue, 17-May-2022
0 0 Free
18:07:04 Hours
Updated Tue, 17-May-2022
0 1 Free
01:43:29 Hours
0 1 Free
15:06:52 Hours
Updated Wed, 08-Jun-2022
0 0 Free
14:55:05 Hours
Updated Wed, 08-Jun-2022
0 0 Free
About instructor

skill expert

0 Reviews | 18 Students | 467 Courses
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Free
Includes: