Query Interface

SQL

Some other tools are in the citations.

Views

Virtual Views

Concurrency Control

Optimistic Concurrency Control (OCC)

Logging

Physical Logging

Joins

Hash Join

MonetDB uses radix partitioned join algorithm in hash join.

Storage Model

Decomposition Storage Model (Columnar)

Isolation Levels

Serializable

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

Query Execution

Vectorized Model

Stored Procedures

Supported

Indexes

Hash Table

MonetDB has a special column imprints for secondary indexes.

Storage Architecture

Disk-oriented

Foreign Keys

Supported

Data Model

Column Family

Query Compilation

Code Generation

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