DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > ClickHouse vs. Oracle Berkeley DB vs. Redis vs. TinkerGraph

System Properties Comparison ClickHouse vs. Oracle Berkeley DB vs. Redis vs. TinkerGraph

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonRedis  Xexclude from comparisonTinkerGraph  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.Widely used in-process key-value storePopular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments infoRedis focuses on performance so most of its design decisions prioritize high performance and very low latencies.A lightweight, in-memory graph engine that serves as a reference implementation of the TinkerPop3 API
Primary database modelRelational DBMSKey-value store infosupports sorted and unsorted key sets
Native XML DBMS infoin the Oracle Berkeley DB XML version
Key-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistenceGraph DBMS
Secondary database modelsTime Series DBMSDocument store infowith RedisJSON
Graph DBMS infowith RedisGraph
Spatial DBMS
Search engine infowith RediSearch
Time Series DBMS infowith RedisTimeSeries
Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score15.55
Rank#38  Overall
#23  Relational DBMS
Score2.01
Rank#126  Overall
#21  Key-value stores
#3  Native XML DBMS
Score155.94
Rank#6  Overall
#1  Key-value stores
Score0.13
Rank#345  Overall
#35  Graph DBMS
Websiteclickhouse.comwww.oracle.com/­database/­technologies/­related/­berkeleydb.htmlredis.com
redis.io
tinkerpop.apache.org/­docs/­current/­reference/­#tinkergraph-gremlin
Technical documentationclickhouse.com/­docsdocs.oracle.com/­cd/­E17076_05/­html/­index.htmldocs.redis.com/­latest/­index.html
redis.io/­docs
DeveloperClickhouse Inc.Oracle infooriginally developed by Sleepycat, which was acquired by OracleRedis project core team, inspired by Salvatore Sanfilippo infoDevelopment sponsored by Redis Inc.
Initial release2016199420092009
Current releasev24.4.1.2088-stable, May 202418.1.40, May 20207.2.5, May 2024
License infoCommercial or Open SourceOpen Source infoApache 2.0Open Source infocommercial license availableOpen Source infosource-available extensions (modules), commercial licenses for Redis EnterpriseOpen Source infoApache 2.0
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.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
Implementation languageC++C, Java, C++ (depending on the Berkeley DB edition)CJava
Server operating systemsFreeBSD
Linux
macOS
AIX
Android
FreeBSD
iOS
Linux
OS X
Solaris
VxWorks
Windows
BSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
Data schemeyesschema-freeschema-freeschema-free
Typing infopredefined data types such as float or dateyesnopartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexesyes
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.noyes infoonly with the Berkeley DB XML editionnono
Secondary indexesyesyesyes infowith RediSearch moduleno
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yes infoSQL interfaced based on SQLite is availablewith RediSQL moduleno
APIs and other access methodsgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
proprietary protocol infoRESP - REdis Serialization ProtocolTinkerPop 3
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
.Net infoFigaro is a .Net framework assembly that extends Berkeley DB XML into an embeddable database engine for .NET
others infoThird-party libraries to manipulate Berkeley DB files are available for many languages
C
C#
C++
Java
JavaScript (Node.js) info3rd party binding
Perl
Python
Tcl
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
Groovy
Java
Server-side scripts infoStored proceduresyesnoLua; Redis Functions coming in Redis 7 (slides and Github)no
Triggersnoyes infoonly for the SQL APIpublish/subscribe channels provide some trigger functionality; RedisGearsno
Partitioning methods infoMethods for storing different data on different nodeskey based and customnoneSharding infoAutomatic hash-based sharding with support for hash-tags for manual shardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Source-replica replicationMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
none
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonothrough RedisGearsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
none
Foreign keys infoReferential integritynononoyes infoRelationships in graphs
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDAtomic execution of command blocks and scripts and optimistic lockingno
Concurrency infoSupport for concurrent manipulation of datayesyes infoData access is serialized by the serverno
Durability infoSupport for making data persistentyesyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logsoptional
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyes
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.noAccess Control Lists (ACLs): redis.io/­docs/­management/­security/­acl
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/­docs/­management/­security/­encryption
Password-based authentication
no

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
3rd partiesAiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more

DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

Navicat for Redis: the award-winning Redis management tool with an intuitive and powerful graphical interface.
» more

Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
» more

Redisson PRO: The ultra-fast Redis Java Client.
» more

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

More resources
ClickHouseOracle Berkeley DBRedisTinkerGraph
DB-Engines blog posts

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

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28 November 2023, AWS Blog

Intel Xeon 6766E/6780E Sierra Forest vs. Ampere Altra Performance & Power Efficiency Review
5 June 2024, Phoronix

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
1 November 2023, GrowthCap

From Open Source to SaaS: the Journey of ClickHouse
16 January 2024, InfoQ.com

provided by Google News

Margo Seltzer Named ACM Athena Lecturer for Technical and Mentoring Contributions
26 April 2023, HPCwire

ACM recognizes far-reaching technical achievements with special awards
26 May 2021, EurekAlert

Margo I. Seltzer | Berkman Klein Center
18 August 2020, Berkman Klein Center

Oracle buys Sleepycat Software
14 February 2006, MarketWatch

How to store financial market data for backtesting
26 January 2019, Towards Data Science

provided by Google News

Redis moves to source-available licenses
25 March 2024, InfoWorld

Redis switches licenses, acquires Speedb to go beyond its core in-memory database
21 March 2024, TechCrunch

Redis acquires storage engine startup Speedb to enhance its open-source database
21 March 2024, SiliconANGLE News

Redis expands data management capabilities with Speedb acquisition – Blocks and Files
22 March 2024, Blocks and Files

In-memory database Redis wants to dabble in disk
19 October 2023, The Register

provided by Google News

Unit testing Apache TinkerPop transactions: From TinkerGraph to Amazon Neptune | Amazon Web Services
3 June 2024, AWS Blog

Simple Deployment of a Graph Database: JanusGraph | by Edward Elson Kosasih
12 October 2020, Towards Data Science

Why developers like Apache TinkerPop, an open source framework for graph computing | Amazon Web Services
27 September 2021, AWS Blog

InfiniteGraph Gets Support for Common Graph Database Language and More
21 February 2012, SiliconANGLE News

Introducing Gremlin query hints for Amazon Neptune | AWS Database Blog
26 February 2019, AWS Blog

provided by Google News



Share this page

Featured Products

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

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.

Present your product here