DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > ClickHouse vs. IBM Db2 Event Store vs. SAP IQ vs. Tarantool

System Properties Comparison ClickHouse vs. IBM Db2 Event Store vs. SAP IQ vs. Tarantool

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonIBM Db2 Event Store  Xexclude from comparisonSAP IQ infoformer name: Sybase IQ  Xexclude from comparisonTarantool  Xexclude from comparison
DescriptionA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.Distributed Event Store optimized for Internet of Things use casesColumnar RDBMS optimized for Big Data analyticsIn-memory computing platform with a flexible data schema for efficiently building high-performance applications
Primary database modelRelational DBMSEvent Store
Time Series DBMS
Relational DBMS infocolumn-orientedDocument store
Key-value store
Relational DBMS
Secondary database modelsTime Series DBMSSpatial DBMS infowith Tarantool/GIS extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score18.71
Rank#30  Overall
#18  Relational DBMS
Score0.17
Rank#316  Overall
#2  Event Stores
#26  Time Series DBMS
Score2.39
Rank#103  Overall
#51  Relational DBMS
Score1.33
Rank#155  Overall
#26  Document stores
#25  Key-value stores
#68  Relational DBMS
Websiteclickhouse.comwww.ibm.com/­products/­db2-event-storewww.sap.com/­products/­technology-platform/­sybase-iq-big-data-management.htmlwww.tarantool.io
Technical documentationclickhouse.com/­docswww.ibm.com/­docs/­en/­db2-event-storehelp.sap.com/­docs/­SAP_IQwww.tarantool.io/­en/­doc
DeveloperClickhouse Inc.IBMSAP, formerly SybaseVK
Initial release2016201719942008
Current releasev24.6.2.17-stable, July 20242.016.1 SPS04, April 20192.10.0, May 2022
License infoCommercial or Open SourceOpen Source infoApache 2.0commercial infofree developer edition availablecommercialOpen Source infoBSD-2, source-available extensions (modules), commercial licenses for Tarantool Enterprise
Cloud-based only infoOnly available as a cloud servicenononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C and C++C and C++
Server operating systemsFreeBSD
Linux
macOS
Linux infoLinux, macOS, Windows for the developer additionAIX
HP-UX
Linux
Solaris
Windows
BSD
Linux
macOS
Data schemeyesyesyesFlexible data schema: relational definition for tables with ability to store json-like documents in columns
Typing infopredefined data types such as float or dateyesyesyesstring, double, decimal, uuid, integer, blob, boolean, datetime
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nononono
Secondary indexesyesnoyesyes
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yes infothrough the embedded Spark runtimeyesFull-featured ANSI SQL support
APIs and other access methodsgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
ADO.NET
DB2 Connect
JDBC
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
RESTful HTTP API
Open binary protocol
Supported programming languagesC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Rust
Scala info3rd party library
C
C#
C++
Cobol
Delphi
Fortran
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
Scala
Visual Basic
C
C#
C++
Java
Perl
PHP
Python
Ruby
C
C#
C++
Erlang
Go
Java
JavaScript
Lua
Perl
PHP
Python
Rust
Server-side scripts infoStored proceduresyesyesyesLua, C and SQL stored procedures
Triggersnonoyesyes, before/after data modification events, on replication events, client session events
Partitioning methods infoMethods for storing different data on different nodeskey based and customShardingshared disk or shared nothing architectures with SAP IQ MultiplexerSharding, partitioned with virtual buckets by user defined affinity key. Live resharding for scale up and scale down without maintenance downtime.
Replication methods infoMethods for redundantly storing data on multiple nodesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Active-active shard replicationSAP/Sybase Replication ServerAsynchronous replication with multi-master option
Configurable replication topology (full-mesh, chain, star)
Synchronous quorum replication (with Raft)
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoHadoop integration
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual ConsistencyImmediate ConsistencyCasual consistency across sharding partitions
Eventual consistency within replicaset partition infowhen using asyncronous replication
Immediate Consistency within single instance
Sequential consistency including linearizable read within replicaset partition infowhen using Raft
Foreign keys infoReferential integritynonoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACIDACID, with serializable isolation and linearizable read (within partition); Configurable MVCC (within partition); No cross-shard distributed transactions
Concurrency infoSupport for concurrent manipulation of datayesNo - written data is immutableyesyes, cooperative multitasking
Durability infoSupport for making data persistentyesYes - Synchronous writes to local disk combined with replication and asynchronous writes in parquet format to permanent shared storageyesyes, write ahead logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesnoyes, full featured in-memory storage engine with persistence
User concepts infoAccess controlAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.fine grained access rights according to SQL-standardfine grained access rights according to SQL-standardAccess Control Lists
Mutual TLS authentication for Tarantol Enterprise
Password based authentication
Role-based access control (RBAC) and LDAP for Tarantol Enterprise
Users and Roles

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
ClickHouseIBM Db2 Event StoreSAP IQ infoformer name: Sybase IQTarantool
DB-Engines blog posts

Data processing speed and reliability: in-memory synchronous replication
9 November 2021,  Vladimir Perepelytsya, Tarantool (sponsor) 

show all

Recent citations in the news

Wiz Research Uncovers Exposed DeepSeek Database Leaking Sensitive Information, Including Chat History
29 January 2025, Wiz

Wiz reveals DeepSeek database exposed API keys, chat history
30 January 2025, TechTarget

Guess who left a database wide open, exposing chat logs, API keys, and more? Yup, DeepSeek
30 January 2025, The Register

Wiz researchers find sensitive DeepSeek data exposed to internet
30 January 2025, CyberScoop

DeepSeek AI Database Exposed: Over 1 Million Log Lines, Secret Keys Leaked
30 January 2025, The Hacker News

provided by Google News

Rimini Street expands support beyond SAP and Oracle
11 June 2022, InsideSAP

Google Cloud adds backup vaults and centralized management
10 September 2024, Blocks and Files

SAS/Access: Product Overview and Insight
7 September 2018, Datamation

Using SAP Hana as a data warehouse
17 August 2015, ComputerWeekly.com

Congrats, HCL, on your £1.5m contract to upgrade a county council's ERP system to SAP S4/HANA within a year
5 November 2020, The Register

provided by Google News

Tarantool Announces New Enterprise Version With Enhanced Scaling and Monitoring Capabilities
18 May 2018, Newswire

How to build a high-performance application on Tarantool from scratch
26 November 2020, Хабр

Accelerating PHP connectors for Tarantool using Async, Swoole, and Parallel
18 December 2019, Хабр

VShard — horizontal scaling in Tarantool
7 March 2019, Хабр

provided by Google News



Share this page

Featured Products

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Present your product here