---
id: "monetdb"
type: "component"
kind: "data-warehouse"
provider: "default"
category: "data"
docs: "https://www.monetdb.org/documentation/"
url: "https://localhost:3000/catalogue/components/monetdb"
---

# MonetDB

Column-store relational database for analytical queries, held in memory-mapped files.

| | |
|---|---|
| Provider | [default](https://localhost:3000/catalogue?provider=default) |
| Kind | [Data warehouse](https://localhost:3000/catalogue/kinds/data-warehouse) |
| Category | Data |
| Official docs | [https://www.monetdb.org/documentation/](https://www.monetdb.org/documentation/) |

## Properties

| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| `concurrencyControl` | enum | `optimistic` | no | "optimistic" | inherited |
| `format` | enum | `columnar`, `row` | no | "columnar" | **"columnar"** |
| `managed` | boolean | — | no | false | **false** |
| `memoryMapped` | boolean | — | no | true | inherited |
| `realtime` | boolean | — | no | false | **false** |
| `upsert` | boolean | — | no | false | **true** |

Bold values are the ones this component pins.

## Rules that apply · 0

No rule selects this kind or its category.

## Other products of the same kind · 39

- [AnalyticDB](https://localhost:3000/catalogue/components/alibaba-analyticdb.md) `alibaba-analyticdb` — alibabacloud
- [ApsaraDB for ClickHouse](https://localhost:3000/catalogue/components/alibaba-clickhouse.md) `alibaba-clickhouse` — alibabacloud
- [Hologres](https://localhost:3000/catalogue/components/alibaba-hologres.md) `alibaba-hologres` — alibabacloud
- [MaxCompute](https://localhost:3000/catalogue/components/alibaba-maxcompute.md) `alibaba-maxcompute` — alibabacloud
- [ApsaraDB for SelectDB](https://localhost:3000/catalogue/components/alibaba-selectdb.md) `alibaba-selectdb` — alibabacloud
- [Amazon Athena](https://localhost:3000/catalogue/components/aws-athena.md) `aws-athena` — aws
- [Amazon Redshift](https://localhost:3000/catalogue/components/redshift.md) `redshift` — aws
- [Azure Analysis Services](https://localhost:3000/catalogue/components/azure-analysis-services.md) `azure-analysis-services` — azure
- [Microsoft Fabric](https://localhost:3000/catalogue/components/azure-fabric.md) `azure-fabric` — azure
- [Azure Synapse Analytics](https://localhost:3000/catalogue/components/azure-synapse.md) `azure-synapse` — azure
- [R2 SQL](https://localhost:3000/catalogue/components/cloudflare-r2-sql.md) `cloudflare-r2-sql` — cloudflare
- [ClickHouse](https://localhost:3000/catalogue/components/clickhouse.md) `clickhouse` — default
- [Generic data warehouse](https://localhost:3000/catalogue/components/data-warehouse.md) `data-warehouse` — default
- [Databricks SQL](https://localhost:3000/catalogue/components/databricks-sql.md) `databricks-sql` — default
- [Apache Doris](https://localhost:3000/catalogue/components/doris.md) `doris` — default
- [Dremio](https://localhost:3000/catalogue/components/dremio.md) `dremio` — default
- [Apache Drill](https://localhost:3000/catalogue/components/drill.md) `drill` — default
- [Apache Druid](https://localhost:3000/catalogue/components/druid.md) `druid` — default
- [DuckDB](https://localhost:3000/catalogue/components/duckdb.md) `duckdb` — default
- [Exasol](https://localhost:3000/catalogue/components/exasol.md) `exasol` — default
- [Firebolt](https://localhost:3000/catalogue/components/firebolt.md) `firebolt` — default
- [Greenplum](https://localhost:3000/catalogue/components/greenplum.md) `greenplum` — default
- [Apache Hive](https://localhost:3000/catalogue/components/hive.md) `hive` — default
- [Apache Impala](https://localhost:3000/catalogue/components/impala.md) `impala` — default
- [Apache Kylin](https://localhost:3000/catalogue/components/kylin.md) `kylin` — default
- [MotherDuck](https://localhost:3000/catalogue/components/motherduck.md) `motherduck` — default
- [Apache Pinot](https://localhost:3000/catalogue/components/pinot.md) `pinot` — default
- [Presto](https://localhost:3000/catalogue/components/presto.md) `presto` — default
- [Snowflake](https://localhost:3000/catalogue/components/snowflake.md) `snowflake` — default
- [StarRocks](https://localhost:3000/catalogue/components/starrocks.md) `starrocks` — default
- [Teradata Vantage](https://localhost:3000/catalogue/components/teradata.md) `teradata` — default
- [Trino](https://localhost:3000/catalogue/components/trino.md) `trino` — default
- [Vertica](https://localhost:3000/catalogue/components/vertica.md) `vertica` — default
- [Google BigQuery](https://localhost:3000/catalogue/components/bigquery.md) `bigquery` — gcp
- [Db2 Warehouse as a Service](https://localhost:3000/catalogue/components/ibm-db2-warehouse.md) `ibm-db2-warehouse` — ibm
- [Netezza Performance Server as a Service](https://localhost:3000/catalogue/components/ibm-netezza.md) `ibm-netezza` — ibm
- [IBM watsonx.data](https://localhost:3000/catalogue/components/ibm-watsonx-data.md) `ibm-watsonx-data` — ibm
- [Autonomous AI Lakehouse](https://localhost:3000/catalogue/components/oci-autonomous-data-warehouse.md) `oci-autonomous-data-warehouse` — oci
- [MySQL HeatWave cluster](https://localhost:3000/catalogue/components/oci-mysql-heatwave-cluster.md) `oci-mysql-heatwave-cluster` — oci

## Use it in a design

```yaml
nodes:
  - { id: "monetdb", component: "monetdb" }
```

## Source (`component` YAML, verbatim)

```yaml
# yaml-language-server: $schema=../../schema/component.schema.json
# MonetDB: column-store relational database for analytical queries. Per the MonetDB documentation
# columns are held in memory-mapped binary files and transactions run under optimistic concurrency
# control, so conflicts are detected at commit rather than prevented by locks.
schemaVersion: "1"
type: "component"
id: "monetdb"
kind: "data-warehouse"
provider: "default"
docs: "https://www.monetdb.org/documentation/"
defaults:
  managed: false
  format: "columnar"
  realtime: false
  upsert: true
properties:
  memoryMapped:
    type: "boolean"
    default: true
  concurrencyControl:
    type: "enum"
    values: ["optimistic"]
    default: "optimistic"
```

Human page: https://localhost:3000/catalogue/components/monetdb