Data Model

Relational

Indexes

B+Tree

Joins

Nested Loop Join Hash Join Index Nested Loop Join

Logging

Physiological Logging

Query Compilation

Not Supported

Query Execution

Tuple-at-a-Time Model

Query Interface

SQL

BusTub added support for SQL in 2022. A demo is available using the BusTub webshell.

Storage Architecture

Disk-oriented

Storage Model

N-ary Storage Model (Row/Record)

Storage Organization

Heaps

Stored Procedures

Not Supported

Views

Not Supported