Parallel Execution

Intra-Operator (Horizontal)

Storage Architecture

In-Memory

Indexes

Hash Table Bw-Tree

Concurrency Control

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

Transactions generate redo records in thread-local memory.

Logging

Physiological Logging

System Architecture

Shared-Everything

Query Execution

Vectorized Model

Data Model

Relational

Isolation Levels

Snapshot Isolation

Storage Format

Apache Arrow

Storage Model

Decomposition Storage Model (Columnar)

Storage Organization

Heaps

Stored Procedures

Supported

Query Compilation

Code Generation JIT Compilation Stored Procedure Compilation

Joins

Hash Join Index Nested Loop Join

Query Interface

SQL