RedLectern

MIT 6.830 · Fall 2010

Database Systems

Prof. Carlo Curino and Prof. Michael Stonebraker

32 activities · 7 modules · 22 lectures, 3 problem sets, 5 labs, 2 exams

MIT published no lecture videos for this course. Each session is the lecture notes plus the assigned papers and their discussion questions.

Progress not loaded Start with Lecture 1: Introduction →
  1. 01

    Foundations: the relational model and schema design

    Progress not loaded · 3 activities

    1. Lecture 1: Introduction
    2. Lecture 2: The relational model
    3. Lecture 3: Schema design
  2. 02

    Database internals: storage, operators, indexing, buffer pool

    Progress not loaded · 6 activities

    1. Lecture 4: Introduction to database internals
    2. Checkpoint: Problem Set 1
    3. Lecture 5: Database operators and query processing
    4. Lecture 6: Indexing and access methods
    5. Lecture 7: Buffer pool design and memory management
    6. Checkpoint: Lab 1: SimpleDB storage and catalog
  3. 03

    Joins and query optimization

    Progress not loaded · 2 activities

    1. Lecture 8: Join algorithms
    2. Lecture 9: Query optimization
  4. 04

    Transactions and concurrency control

    Progress not loaded · 5 activities

    1. Lecture 10: Transactions and locking
    2. Checkpoint: Problem Set 2
    3. Lecture 11: Optimistic concurrency control
    4. Checkpoint: Lab 2: SimpleDB operators
    5. Exam 1
  5. 05

    Recovery and consistency

    Progress not loaded · 3 activities

    1. Lecture 12: Recovery
    2. Lecture 13: Recovery (continued)
    3. Lecture 14: Degrees of consistency
  6. 06

    Column stores, distributed and parallel databases

    Progress not loaded · 4 activities

    1. Lecture 15: C-Store (guest lecture: Sam Madden)
    2. Checkpoint: Lab 3: SimpleDB transactions
    3. Lecture 16: Distributed transactions
    4. Lecture 17: Parallel databases
  7. 07

    Beyond the relational core

    Progress not loaded · 9 activities

    1. Lecture 18: Scientific databases
    2. Lecture 19: NoSQL
    3. Lecture 20: ORM and DryadLINQ
    4. Checkpoint: Lab 4: SimpleDB query optimizer (6.814)
    5. Lecture 21: Streaming databases
    6. Checkpoint: Problem Set 3
    7. Exam 2
    8. Lecture 22: Database as a service
    9. Checkpoint: Lab 5: SimpleDB rollback and recovery (6.814)

MIT OpenCourseWare, 6.830 Database Systems, Fall 2010, Prof. Carlo Curino and Prof. Michael Stonebraker. Licensed CC BY-NC-SA 4.0. Reorganized into modules by Sequence 106. No lecture videos were published for this course; each session is notes plus readings. Source · CC BY-NC-SA 4.0

Move progress to another device

Export this browser’s progress, notes, and playback positions, then import the file on your other device. Import replaces matching saved entries.