Introduction to Database Systems

Overview This course,15-445/645 Intro to Database Systems, is on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexing (order preserving trees, hash tables), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed). Case studies on open-source and commercial database systems will be used to illustrate these techniques and trade-offs.

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: https://15445.courses.cs.cmu.edu/fall2018/slides/01-introduction.pdf
Prof. Andy Pavlo (http://www.cs.cmu.edu/~pavlo/)
15-445/645 Intro to Database Systems (Fall 2018)
Carnegie Mellon University

https://15445.courses.cs.cmu.edu/fall2018

Curriculum for this course
26 Lessons 30:36:45 Hours
CMU Database Systems
26 Lessons 30:36:45 Hours
  • Course introduction & Relational Data Model
    Preview 01:07:29
  • Advanced SQL
    01:20:54
  • Database Storage I
    01:13:06
  • Database Storage II
    01:12:31
  • Buffer Pools
    01:10:32
  • Hash Tables
    01:21:11
  • Tree Indexes Part I
    01:17:17
  • Tree Indexes Part II
    01:17:23
  • Query Processing
    00:52:13
  • Sorting & Aggregation Algorithms
    00:28:08
  • Index Concurrency Control
    01:08:01
  • Join Algorithms
    01:05:29
  • Query Optimization
    01:13:39
  • Parallel Execution
    00:39:32
  • Embedded Logic
    01:12:57
  • Concurrency Control Theory
    01:17:05
  • Two-Phase Locking Concurrency Control
    01:18:13
  • Timestamp Ordering Concurrency Control
    01:20:37
  • Multi-Version Concurrency Control
    01:09:34
  • Logging Schemes
    01:16:27
  • Database Recovery
    01:16:31
  • Distributed OLTP Databases Part I
    01:10:51
  • Distributed OLTP Databases Part II
    01:19:37
  • Distributed OLAP Databases
    01:06:22
  • Ethan Zhang [VoltDB]
    01:22:12
  • Systems Potpourri [CockroachDB, Spanner, MongoDB]
    01:18:54
+ 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 | 17 Students | 467 Courses
Student feedback
0
0 Reviews
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Reviews

Free
Includes: