Concurrency Control

Optimistic Concurrency Control (OCC)

Data Model

Column Family / Wide-Column

Foreign Keys

Supported

Indexes

Hash Table

MonetDB has a special column imprints for secondary indexes.

Isolation Levels

Serializable

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

Joins

Hash Join

MonetDB uses radix partitioned join algorithm in hash join.

Logging

Physical Logging

Query Compilation

Code Generation

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

Query Execution

Vectorized Model

Query Interface

SQL

Some other tools are in the citations.

Storage Architecture

Disk-oriented

Storage Model

Decomposition Storage Model (Columnar)

Stored Procedures

Supported

Views

Virtual Views