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

Clickhouse

Stacks388

Followers517

+ 1

Votes78

IBM DB2

Stacks243

Followers247

+ 1

Votes19

Add tool

Clickhouse vs IBM DB2: 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 IBM DB2? A family of database server products developed by IBM. DB2 for Linux, UNIX, and Windows is optimized to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.

Clickhouse and IBM DB2 belong to "Databases" category of the tech stack.

ITAIPU BINACIONAL, XMLi5 Ltd., and 3scale are some of the popular companies that use IBM DB2, whereas Clickhouse is used by Findify, AppsFlyer, and STORETAIL. IBM DB2 has a broader approval, being mentioned in 16 company stacks & 49 developers stacks; compared to Clickhouse, which is listed in 22 company stacks and 11 developer stacks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.

Learn More

Pros of Clickhouse

Pros of IBM DB2

19
Fast, very very fast
11
Good compression ratio
6
Horizontally scalable
5
Great CLI
5
Utilizes all CPU resources
5
RESTful
4
Buggy
4
Open-source
4
Great number of SQL functions
3
Server crashes its normal :(
3
Has no transactions
2
Flexible connection options
2
Highly available
2
ODBC
2
Flexible compression options
1
In IDEA data import via HTTP interface not working

7
Rock solid and very scalable
5
BLU Analytics is amazingly fast
2
Native XML support
2
Secure by default
2
Easy
1
Best performance

Sign up to add or upvote prosMake informed product decisions

Cons of Clickhouse

Cons of IBM DB2

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 IBM DB2?

DB2 for Linux, UNIX, and Windows is optimized to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.

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

Jobs that mention Clickhouse and IBM DB2 as a desired skillset

Manager I, Site Reliability Engineering

San Francisco, CA, US; , CA, US

View Job Details

+18

Manager I, Site Reliability Engineering

San Francisco, CA, US; , CA, US

View Job Details

+18

Senior Software Engineer, Big Data

San Francisco, CA, US; , CA, US

View Job Details

+11

Staff Software Engineer - Site Reliability

Toronto, ON, CA

View Job Details

+20

Staff Software Engineer - Site Reliability

Toronto, ON, CA

View Job Details

+20

Staff Software Engineer - Site Reliability

Toronto, ON, CA

View Job Details

+20

Sr. Machine Learning Engineer

Toronto, ON, CA

View Job Details

Staff Software Engineer, Ads Serving Platform

San Francisco, CA, US; , US

View Job Details

See jobs for Clickhouse

See jobs for IBM DB2

What companies use Clickhouse?

What companies use IBM DB2?

See which teams inside your own company are using Clickhouse or IBM DB2.

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

What tools integrate with Clickhouse?

What tools integrate with IBM DB2?

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

What are some alternatives to Clickhouse and IBM DB2?

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

Clickhouse vs IBM DB2

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

Pros of Clickhouse

Pros of IBM DB2

Sign up to add or upvote prosMake informed product decisions

Cons of Clickhouse

Cons of IBM DB2

Sign up to add or upvote consMake informed product decisions

What is Clickhouse?

What is IBM DB2?

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

What companies use Clickhouse?

What companies use IBM DB2?

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

What tools integrate with Clickhouse?

What tools integrate with IBM DB2?

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

Related Comparisons

Trending Comparisons

Top Comparisons