Query Interface

SQL

Some other tools are in the citations.

Storage Architecture

Disk-oriented

Foreign Keys

Supported

Data Model

Column Family / Wide-Column

Views

Virtual Views

Query Compilation

Code Generation

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

Isolation Levels

Serializable

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

Storage Model

Decomposition Storage Model (Columnar)

Query Execution

Vectorized Model

Stored Procedures

Supported

Logging

Physical Logging

Indexes

Hash Table

MonetDB has a special column imprints for secondary indexes.

Joins

Hash Join

MonetDB uses radix partitioned join algorithm in hash join.

Concurrency Control

Optimistic Concurrency Control (OCC)