DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Aerospike vs. Apache IoTDB vs. ClickHouse

System Properties Comparison Aerospike vs. Apache IoTDB vs. ClickHouse

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonApache IoTDB  Xexclude from comparisonClickHouse  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL DatabaseAn IoT native database with high performance for data management and analysis, deployable on the edge and the cloud and integrated with Hadoop, Spark and FlinkColumn-oriented Relational DBMS powering Yandex
Primary database modelDocument store
Key-value store
Spatial DBMS
Time Series DBMSRelational DBMS
Secondary database modelsTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.69
Rank#66  Overall
#12  Document stores
#8  Key-value stores
#2  Spatial DBMS
Score0.65
Rank#242  Overall
#19  Time Series DBMS
Score13.87
Rank#44  Overall
#28  Relational DBMS
Websiteaerospike.comiotdb.apache.orgclickhouse.tech
Technical documentationdocs.aerospike.comclickhouse.tech/­docs
Social network pagesLinkedInTwitterFacebook
DeveloperAerospikeApache Software FoundationClickhouse Inc.
Initial release201220182016
Current release6.0.0.0, April 2022v22.8.5.29-lts, September 2022
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availableOpen Source infoApache Version 2.0Open Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCJavaC++
Server operating systemsLinuxAll OS with a Java VM (>= 1.8)FreeBSD
Linux
macOS
Data schemeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyesyes
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.nonono
Secondary indexesyesyesyes, when using the MergeTree engine
SQL infoSupport of SQLnoSQL-like query languageClose to ANSI SQL
APIs and other access methodsJDBC
Proprietary protocol
JDBC
Native API
HTTP REST
JDBC
ODBC
Proprietary protocol
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
C# 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
Scala info3rd party library
Server-side scripts infoStored proceduresuser defined functions infowith Luayesno
Triggersnoyesno
Partitioning methods infoMethods for storing different data on different nodesSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/ReduceIntegration with Hadoop and Sparkno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationEventual Consistency
Strong Consistency with Raft
Immediate Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsnono
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyyesAccess rights for users and roles
More information provided by the system vendor
Aerospike infopreviously called CitrusleafApache IoTDBClickHouse
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Apache IoTDB (Internet of Things Database) is a time series data management system...
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
Low Cost and High Performance Tens of million points write throughput High compression...
» more
Typical application scenariosAerospike excels in mission-critical applications that have mixed read/write workloads...
» more
IoT / IIoT End-Edge-Cloud Collaboration Real-Time and Historian Time Series Analytics
» more
Key customersNielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services...
» more
Over 200 customers worldwide, including Bosch, Siemens, Komat'su, Alibaba, etc.
» more
Market metricsAerospike's combination of speed, scalability, and reliability delivers 10x performance...
» more
185+ contributors and 10,000+ times monthly clones on GitHub Rank 7 by commits among...
» more
Licensing and pricing modelsSubscription-based Enterprise Edition and free, open-source Community Edition
» more
Open Source: Apache License v2.0 Pricing for commercial-/cloud-/edge-edition provided...
» more
News

Aerospike Appoints Martin James to Lead EMEA
14 September 2022

Aerospike Named to Inc. 5000 List of Fastest-growing Companies in America
17 August 2022

Aerospike Announces Record 2022 First Half
27 July 2022

Hoonartek and Aerospike Announce DigiTwin
5 July 2022

Aerospike Announces Aerospike SQL Powered by Starburst
15 June 2022

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
Aerospike infopreviously called CitrusleafApache IoTDBClickHouse
DB-Engines blog posts

Evaluating Hbase and Aerospike Solutions for Real-time System of Record
17 March 2020,  Srini Srinivasan, Aerospike (sponsor) 

show all

Recent citations in the news

Aerospike Appoints Martin James to Lead EMEA
14 September 2022, PR Newswire

Podcast transcript: Achieving software sustainability
7 October 2022, IT PRO

Online shopping, streaming, banking and other services urged to count carbon emissions
6 October 2022, Brunel University News

From DB2 to Real-Time with Aerospike Founder Srini Srinivasan
8 September 2022, thenewstack.io

Aerospike Unveils Database 6
27 April 2022, GlobeNewswire

provided by Google News

Timecho, Founded by the Creators of Apache IoTDB, Raises Over US$10 Million First Fund for Open-Source Software R&D and Time-Series Database Solutions USA - English - USA - English
29 June 2022, PR Newswire

The founders of Apache IoTDB founded Timecho, which has garnered over $10 million for its inaugural fund
7 July 2022, EnterpriseTalk

The Apache® Software Foundation Announces Program for ApacheCon@Home 2021
17 August 2021, Yahoo Finance

provided by Google News

Column-Store ClickHouse Launches Cloud Version
6 October 2022, Datanami

Aiven improves access to open source data technologies with new ClickHouse offering
14 September 2022, VentureBeat

Data Management News for the Week of September 16; Updates from Kensu, Oracle, Syniti, and More
15 September 2022, Solutions Review

Materialize’s ‘distributed database’ mobilizes streaming data with the simplicity of SQL
3 October 2022, VentureBeat

Multiple Flaws Uncovered in ClickHouse OLAP Database System for Big Data
16 March 2022, The Hacker News

provided by Google News

Job opportunities

Sr. NoSQL Database Administration Engineer (remote)
Charles Schwab, Raleigh, NC

Software Developer
Charles Schwab, California

Sr. Database Administrator - Oracle/SQL Server
Early Warning Services, Scottsdale, AZ

Full Stack Web Developer
IQVIA, Remote

Sr. NET Developer
Charles Schwab, Lone Tree, CO

Big Data Software Engineer, VIPER
Comcast, Denver, CO

Senior Data Engineer - Vice President
Deutsche Bank, Cary, NC

Java Engineer (Mid-level)
Ad.net, Remote

Data Engineer / Quality Engineering
Tesla, Sparks, NV

Data Engineer
Mather Economics, LLC, Atlanta, GA

jobs by Indeed



Share this page

Featured Products

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here