Logging

Physical Logging

Indexes

Hash Table

MonetDB has a special column imprints for secondary indexes.

Concurrency Control

Optimistic Concurrency Control (OCC)

Storage Model

Decomposition Storage Model (Columnar)

Data Model

Column Family / Wide-Column

Query Compilation

Code Generation

The query will be compiled to MonetDB Assembly Language(MAL).

Joins

Hash Join

MonetDB uses radix partitioned join algorithm in hash join.

Foreign Keys

Supported

Isolation Levels

Serializable

Cannot find the default isolation level. However it supports set the isolation level to be SERIALIZABLE.

Query Execution

Vectorized Model

Storage Architecture

Disk-oriented

Query Interface

SQL

Some other tools are in the citations.

Views

Virtual Views

Stored Procedures

Supported