DB-EnginesExtremeDB: hybrid in-memory and persistent storage based on a true IMDSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. Elasticsearch vs. Redis

System Properties Comparison ClickHouse vs. Elasticsearch vs. Redis

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonElasticsearch  Xexclude from comparisonRedis  Xexclude from comparison
DescriptionColumn-oriented Relational DBMS powering YandexA distributed, RESTful modern search and analytics engine based on Apache Lucene infoElasticsearch lets you perform and combine many types of searches such as structured, unstructured, geo, and metricIn-memory data structure store, used as database, cache and message broker infoRedis focuses on performance so most of its design decisions prioritize high performance and very low latencies.
Primary database modelRelational DBMSSearch engineKey-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence
Secondary database modelsTime Series DBMSDocument store
Spatial DBMS
Document store infowith Redis Modules
Graph DBMS infowith Redis Modules
Spatial DBMS
Search engine infowith Redis Modules
Time Series DBMS infowith Redis Modules
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score9.26
Rank#49  Overall
#29  Relational DBMS
Score154.71
Rank#8  Overall
#1  Search engines
Score165.25
Rank#7  Overall
#1  Key-value stores
Websiteclickhouse.techwww.elastic.co/­elasticsearchredis.io
Technical documentationclickhouse.tech/­docswww.elastic.co/­guide/­en/­elasticsearch/­reference/­current/­index.htmlredis.io/­documentation
DeveloperYandex LLCElasticSalvatore Sanfilippo infoDevelopment sponsored by Redis Labs
Initial release201620102009
Current releasev20.11.3.3-stable, November 20207.8.0, June 20206.2.3, May 2021
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infoApache Version 2; Elastic LicenseOpen Source infoBSD 3-Clause, commercial license available
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.
Elasticsearch Service on Elastic Cloud: Try out the official hosted Elasticsearch and Kibana offering available on Amazon Web Services, Google Cloud and Microsoft Azure that's powered by the creators of Elasticsearch.
  • ScaleGrid for Redis: Fully managed hosting for Redis on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
  • Redis Enterprise Cloud: Instantly scale and pay only for the resources you need - on any cloud - AWS, Azure or Google Cloud.
Implementation languageC++JavaC
Server operating systemsFreeBSD
Linux
macOS
All OS with a Java VMBSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
Data schemeyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentschema-free
Typing infopredefined data types such as float or dateyesyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes
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 indexesnoyes infoAll search fields are automatically indexedyes infowith RediSearch module
SQL infoSupport of SQLClose to ANSI SQLSQL-like query languageno
APIs and other access methodsHTTP REST
JDBC
ODBC
Proprietary protocol
Java API
RESTful HTTP/JSON API
proprietary protocol infoRESP - REdis Serialization 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
Scala info3rd party library
.Net
Groovy
Community Contributed Clients
Java
JavaScript
Perl
PHP
Python
Ruby
C
C#
C++
Clojure
Crystal
D
Dart
Elixir
Erlang
Fancy
Go
Haskell
Haxe
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Objective-C
OCaml
Pascal
Perl
PHP
Prolog
Pure Data
Python
R
Rebol
Ruby
Rust
Scala
Scheme
Smalltalk
Swift
Tcl
Visual Basic
Server-side scripts infoStored proceduresnoyesLua
Triggersnoyes infoby using the 'percolation' featureno infopublish/subscribe channels provide limited trigger functionality
Partitioning methods infoMethods for storing different data on different nodesShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoES-Hadoop Connectorno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allEventual Consistency
Strong eventual consistency with CRDTs
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoOptimistic locking, atomic execution of commands blocks and scripts
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoData access is serialized by the server
Durability infoSupport for making data persistentyesyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logs
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesMemcached and Redis integrationyes
User concepts infoAccess controlAccess rights for users and rolesSimple password-based access control infoAccess control lists and SSL are available in the commercial version
More information provided by the system vendor
ClickHouseElasticsearchRedis
Specific characteristicsElasticsearch is an open source search and analytics engine. As the heart of the...
» more
Redis, benchmarked as the world's fastest database, reduces application complexity,...
» more
Competitive advantagesOpen source Real-time indexsearch, and analysis Horizontally scalable Distributed...
» more
Redis is an in-memory database platform offering native support of wide range of...
» more
Typical application scenariosEnterprise search (search experiences for your workplace, apps, and websites), observability...
» more
Redis powers personalization, real-time fraud detection, IoT, e-commerce, real-time...
» more
Key customersThousands of organizations worldwide, including Cisco, eBay, Goldman Sachs, Microsoft,...
» more
Verizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...
» more
Market metricsPublic as of October 2018 Distributed workforce with 1900+ employees around the globe​...
» more
Licensing and pricing modelsThe Elastic Stack (Elasticsearch, Kibana, Beats, and Logstash) is free and open source...
» more
The licensing model is subscription based. Redis Enterprise Cloud is priced according...
» more

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
3rd partiesElastic Cloud: Try the official managed Elasticsearch.
» more
Redisson PRO: The ultra-fast Redis Java Client.
» more

Datadog: Monitor all Redis metrics: hit rates, clients, commands per second, and more.
» more

Redis Enterprise Cloud: Try with 400$ usage credit.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
ClickHouseElasticsearchRedis
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Elasticsearch moved into the top 10 most popular database management systems
3 July 2017, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

show all

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

MongoDB is the DBMS of the year, defending the title from last year
7 January 2015, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Generous Alibaba to scatter 0.9% of annual revenue over Southeast Asia to develop tech talent and infrastructure
8 June 2021, The Register

Altinity grabs $4M seed to build cloud version of ClickHouse open-source data warehouse
1 October 2020, TechCrunch

Open source product analytics platform PostHog raises $15M
10 June 2021, VentureBeat

Aiven set to grow open source database-as-a-service platform
30 March 2021, TechTarget

Sberbank : SberCloud enters retail cloud market
20 May 2021, marketscreener.com

provided by Google News

Instaclustr Achieves PCI-DSS Certification for its Managed Elasticsearch Service on AWS
14 June 2021, Yahoo Finance

Packages May 27th, 2021 ElasticSearch Driver for Laravel Scout
27 May 2021, Laravel News

Microsoft and Elastic Partner to Offer Elastic Stack on Azure
30 May 2021, InfoQ.com

Siren partners with SECTION6 to strengthen its presence in the APAC region
9 June 2021, Help Net Security

Elastic Announces Osquery Management Integration for Unified Data Analysis to Address Cyber Threats
27 May 2021, Business Wire

provided by Google News

Redis Labs' RediSearch 2.0 Delivers Real-Time Enterprise Search, Query and Indexing
3 June 2021, Integration Developers

Database Engines Market Future Scope including key players Google, Oracle, Microsoft, MongoDB, IBM, Redis Labs – The Manomet Current
14 June 2021, The Manomet Current

Open-Source Database Software Market Analysis 2021 By Top Keyplayers | MySQL, Redis, Couchbase, Apache Hive, MongoDB, SQLite – The Courier
11 June 2021, The Courier

In-Memory Database Market – Major Technology Giants in Buzz Again | Redis Labs, Tibco Software Inc., Centrum Wiskunde And Informatica – The Manomet Current
24 May 2021, The Manomet Current

Cloud Database Market Analysis, Growth, Demand and Forecast 2021-2027 | Microsoft, Redis Labs, EnterpriseDB, Couchbase, Oracle, Century Link Inc, Tencent, CSC (Computer Science Corporation), etc – Clark County Blog
14 June 2021, Clark County Blog

provided by Google News

Job opportunities

Senior Software Engineer at Growing Fintech Startup
Databento, Remote

Systems Engineer at Growing Fintech Startup
Databento, Inc., Remote

Senior Database Engineer (Runtime)
PingCAP, Remote

Senior Database Engineer
PingCAP, Remote

Associate Data Analyst
Gubagoo Inc., Boca Raton, FL

Elasticsearch Developer
Summit Racing Equipment, Tallmadge, OH

SQL Server Database Admin
LKQ, Nashville, TN

Junior Java Software Engineer (Remote)
Datagrate, Inc., Saint Petersburg, FL

Game Intelligence Analyst
Ubisoft, Cary, NC

Linux Administrator
opentext, Denver, CO

Development Database Administration
Luxoft, Remote

SQL Server Database Build and Delivery DBA
Citi, Irving, TX

Database Developer
Hunter Engineering, Bridgeton, MO

Senior Cloud Database Engineer
Adobe, Austin, TX

Cloud Scala Software Developer (100% remote- full time)
Railroad19, Remote

jobs by Indeed




Share this page

Featured Products

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here