Logging

Physiological Logging

System Architecture

Shared-Everything

Joins

Hash Join Index Nested Loop Join

Query Interface

SQL

Parallel Execution

Intra-Operator (Horizontal)

Stored Procedures

Supported

Query Compilation

Code Generation JIT Compilation Stored Procedure Compilation

NoisePage transforms query plans into a database-centric DSL called TPL ("terrier programming language"). The DBMS then compiles the TPL program into bytecodes that it can either interpret with its own VM or compile into machine code with LLVM.

Indexes

Hash Table Bw-Tree

Data Model

Relational

Concurrency Control

Multi-version Concurrency Control (MVCC) Optimistic Concurrency Control (OCC)

Transactions generate redo records in thread-local memory.

Isolation Levels

Snapshot Isolation

Storage Organization

Heaps

Storage Format

Apache Arrow

Storage Architecture

In-Memory

Storage Model

Decomposition Storage Model (Columnar)

Query Execution

Vectorized Model