cmu-db/bustub
Bustub
This is an educational relational database engine used in Carnegie Mellon University's database systems course. Students learn internals by implementing core components of a working database, including storage, indexing, concurrency control, and crash recovery.
The system covers key database architecture: a B+ tree index for fast key-based lookups and range scans, a disk-oriented buffer pool that caches pages from disk, an iterator-based query execution model that composes physical operators, page-based storage for records, two-phase locking for coordinating concurrent transactions, and write-ahead logging to ensure durability and recoverability after failures.
It also provides an interactive SQL shell for executing queries against a relational schema, concurrent transaction management with ACID guarantees, and crash recovery via logging and checkpoint techniques—giving students a complete hands-on environment for building and experimenting with database internals.
Features
- Database Internals - Teaches database internals by having students build core components like buffer pools, B+ trees, and query execution.
- Concurrent Read-Write Transactions - Coordinates multiple client operations to preserve data consistency with ACID properties and concurrency control.
- Page-Based Storage - Organises database records into fixed-size pages that are the unit of transfer between disk and buffer pool.
- Two-Phase Locking Protocols - Coordinates concurrent transactions by acquiring locks in a growing phase and releasing in a shrinking phase.
- Reactive SQL Query Execution - Parses and executes SQL statements against a relational schema with support for multiple query types.
- Educational Database Systems - Serves as an educational relational database engine for teaching internals through hands-on implementation.
- SQL Query Execution Engines - Parses and executes SQL statements against a relational schema to retrieve or modify data.
- B+ Tree Indexing - Implements a B+ tree index for fast key-based lookups and efficient range scans.
- Write-Ahead Logging - Ensures transaction durability by recording changes to a log before writing data pages to disk.
- Database Crash Recovery - Restores database consistency after crashes using write-ahead logging and checkpoint-based recovery.
- Database Crash Recovery - Restores database consistency after failures using write-ahead logging and checkpoint-based recovery.
- Database Query Execution Iterators - Implements an iterator-based query execution model that composes physical operators into a pull-based tree.
- Database Concurrency Control - Manages concurrent transactions with ACID guarantees through locking and isolation protocols.
- Database Buffer Pools - Ships a disk-oriented buffer pool that caches pages from disk to minimize I/O operations.
- Interactive SQL Executors - Provides an interactive command-line interface for executing SQL queries and viewing results in real time.
- Interactive Shells - Provides an interactive command-line interface for typing SQL commands and viewing results in real time.
