Checkpoints

Consistent

Concurrency Control

Multi-version Concurrency Control (MVCC) Deterministic Concurrency Control

Data Model

Relational

Foreign Keys

Supported

Hardware Acceleration

Custom

Cache-conscious data structures for in-memory tables

Indexes

B+Tree Patricia/Radix Trie

B+-tree for on-disk tables, and combination of compressed Patricia trie and cache conscious B-tree leaf level nodes.

Isolation Levels

Read Committed Serializable Repeatable Read

Read Committed, Repeatable Read & Serializable for on-disk tables, Read Committed and Repeatable Read for in-memory tables.

Logging

Physiological Logging

Parallel Execution

Bushy

Parallel reads

Query Compilation

Code Generation Stored Procedure Compilation

Query Execution

Materialized Model

Query Interface

Custom API SQL Stored Procedures HTTP / REST Command-line / Shell

Storage Architecture

Disk-oriented In-Memory Hybrid

Per table granularity. Both in-memory - and on-disk tables are supported on same schema. Table types are transparent to queries.

Storage Model

N-ary Storage Model (Row/Record)

Stored Procedures

Supported

System Architecture

Shared-Nothing Shared-Everything Embedded

Views

Virtual Views