MIT · 6.5831

Database Systems

数据库系统

Relational models, schema design, query processing and optimization, transactions, recovery, and distributed databases.

Start with one small step

Topic 1: Introduction, Relational Model, and SQL I

No path choice or account is required. Start one real official item and OpenStudy will remember where you left off.

Start the first lesson ↗Preview a gentle study plan

Subject：Databases

Level：Advanced Undergraduate

Suggested stage：Years 3–4 (inferred)

Public-material edition：2026

Language：English

Videos：Not verified

Assignments / solutions：Available / Not verified

Prerequisites

MIT 6.033 or equivalent →

Start here

All official course content

Lectures, video, assignments and exams are separated so you do not have to hunt through the course homepage.

58 direct tasks

▶Lectures, video & readingCourse content in the official sequence24

Topic 1: Introduction, Relational Model, and SQL I Topic 2: SQL II Topic 3: Schema Design Topic 4: Introduction to Database Internals Topic 5: Indexing and Access Methods Topic 6: Database Operators and Query Processing Topic 7: Join Algorithms Topic 8: Query Optimization Topic 9: Normalization Topic 10: OLAP and Column Stores Topic 11: Transactions and Locking Topic 12: Optimistic Concurrency Control and Snapshot Isolation Topic 13: Recovery I Topic 14: Recovery II Topic 15: Distributed Databases Topic 16: Distributed Transactions Topic 17: Vector Databases Topic 18: Eventual Consistency Topic 19: Cluster Computing with Spark Topic 20: Cloud Databases Topic 21: Advanced Cardinality Estimation and Sketches Topic 22: Semantic Operators Topic 23: Final Project Presentations I Topic 24: Final Project Presentations II

✓Assignments & practiceOpen the matching problem or assignment page27

◆Labs & projectsCourse projects, labs and milestones5

Lab 1 Lab 2 Lab 3 Lab 4 (6.5831 only)Optional final project and report

◇Exams & quizzesOfficial quizzes, exams and review material2

Quiz 1 Quiz 2

Official resource hubs

Use these to browse a complete resource collection; the section above links directly to individual study items.

Spring 2026 schedule and readingsMIT Data Systems Group ↗

Spring 2026 lecture notes, labs, and problem setsMIT Data Systems Group ↗

Source and verification

Every link points to an official university or course-team page. The year identifies the linked public-material edition, not necessarily the latest on-campus offering; a school may have newer materials that are not public. Unknown facts remain unverified rather than guessed.

MIT Data Systems Group · verified 2026-09-02

Open official course ↗Report a resource issue