Need advice about which tool to choose?Ask the StackShare community!

Clickhouse

298
412
+ 1
74
MonetDB

9
27
+ 1
2
Add tool

Clickhouse vs MonetDB: What are the differences?

What is Clickhouse? A column-oriented database management system. It allows analysis of data that is updated in real time. It offers instant results in most cases: the data is processed faster than it takes to create a query.

What is MonetDB? Column-store database. MonetDB innovates at all layers of a DBMS, e.g. a storage model based on vertical fragmentation, a modern CPU-tuned query execution architecture, automatic and self-tuning indexes, run-time query optimization, and a modular software architecture.

Clickhouse and MonetDB can be categorized as "Databases" tools.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Clickhouse
Pros of MonetDB
  • 19
    Fast, very very fast
  • 11
    Good compression ratio
  • 6
    Horizontally scalable
  • 5
    Great CLI
  • 5
    RESTful
  • 5
    Utilizes all CPU resources
  • 4
    Great number of SQL functions
  • 4
    Open-source
  • 3
    Has no transactions
  • 2
    Buggy
  • 2
    ODBC
  • 2
    Flexible connection options
  • 2
    Flexible compression options
  • 2
    Highly available
  • 1
    In IDEA data import via HTTP interface not working
  • 1
    Server crashes its normal :(
  • 2
    High Performance

Sign up to add or upvote prosMake informed product decisions

Cons of Clickhouse
Cons of MonetDB
  • 5
    Slow insert operations
    Be the first to leave a con

    Sign up to add or upvote consMake informed product decisions

    What is Clickhouse?

    It allows analysis of data that is updated in real time. It offers instant results in most cases: the data is processed faster than it takes to create a query.

    What is MonetDB?

    MonetDB innovates at all layers of a DBMS, e.g. a storage model based on vertical fragmentation, a modern CPU-tuned query execution architecture, automatic and self-tuning indexes, run-time query optimization, and a modular software architecture.

    Need advice about which tool to choose?Ask the StackShare community!

    Jobs that mention Clickhouse and MonetDB as a desired skillset
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US; Seattle, WA, US
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US; Seattle, WA, US
    CBRE
    United States of America Texas Richardson
    CBRE
    United States of America Texas Richardson
    CBRE
    United States of America Texas Richardson
    CBRE
    Philippines National Capital Region Makati City
    What companies use Clickhouse?
    What companies use MonetDB?
      No companies found
      See which teams inside your own company are using Clickhouse or MonetDB.
      Sign up for StackShare EnterpriseLearn More

      Sign up to get full access to all the companiesMake informed product decisions

      What tools integrate with Clickhouse?
      What tools integrate with MonetDB?

      Sign up to get full access to all the tool integrationsMake informed product decisions

      What are some alternatives to Clickhouse and MonetDB?
      Cassandra
      Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
      Elasticsearch
      Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
      MySQL
      The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
      InfluxDB
      InfluxDB is a scalable datastore for metrics, events, and real-time analytics. It has a built-in HTTP API so you don't have to write any server side code to get up and running. InfluxDB is designed to be scalable, simple to install and manage, and fast to get data in and out.
      Druid
      Druid is a distributed, column-oriented, real-time analytics data store that is commonly used to power exploratory dashboards in multi-tenant environments. Druid excels as a data warehousing solution for fast aggregate queries on petabyte sized data sets. Druid supports a variety of flexible filters, exact calculations, approximate algorithms, and other useful calculations.
      See all alternatives