DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > HBase vs. IBM Db2 warehouse vs. Interbase vs. Redis vs. TimescaleDB

System Properties Comparison HBase vs. IBM Db2 warehouse vs. Interbase vs. Redis vs. TimescaleDB

Editorial information provided by DB-Engines
NameHBase  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonInterbase  Xexclude from comparisonRedis  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionWide-column store based on Apache Hadoop and on concepts of BigTableCloud-based data warehousing serviceLight-weight proven RDBMS infooriginally from BorlandPopular 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 time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelWide column storeRelational DBMSRelational DBMSKey-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistenceTime Series DBMS
Secondary database modelsDocument store infowith RedisJSON
Graph DBMS infowith RedisGraph
Spatial DBMS
Search engine infowith RediSearch
Time Series DBMS infowith RedisTimeSeries
Vector DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score31.60
Rank#26  Overall
#2  Wide column stores
Score1.61
Rank#156  Overall
#71  Relational DBMS
Score5.51
Rank#70  Overall
#38  Relational DBMS
Score157.00
Rank#6  Overall
#1  Key-value stores
Score5.33
Rank#72  Overall
#4  Time Series DBMS
Websitehbase.apache.orgwww.ibm.com/­products/­db2/­warehousewww.embarcadero.com/­products/­interbaseredis.com
redis.io
www.timescale.com
Technical documentationhbase.apache.org/­book.htmldocs.embarcadero.com/­products/­interbasedocs.redis.com/­latest/­index.html
redis.io/­docs
docs.timescale.com
DeveloperApache Software Foundation infoApache top-level project, originally developed by PowersetIBMEmbarcaderoRedis project core team, inspired by Salvatore Sanfilippo infoDevelopment sponsored by Redis Inc.Timescale
Initial release20082014198420092017
Current release2.3.4, January 2021InterBase 2020, December 20197.2.4, January 20242.13.0, November 2023
License infoCommercial or Open SourceOpen Source infoApache version 2commercialcommercialOpen Source infosource-available extensions (modules), commercial licenses for Redis EnterpriseOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenoyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
Implementation languageJavaCCC
Server operating systemsLinux
Unix
Windows infousing Cygwin
hostedAndroid
iOS
Linux
OS X
Windows
BSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
Linux
OS X
Windows
Data schemeschema-free, schema definition possibleyesyesschema-freeyes
Typing infopredefined data types such as float or dateoptions to bring your own types, AVROyesyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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.nono infoImport/export of XML data possibleno infoexport as XML data possiblenoyes
Secondary indexesnoyesyesyes infowith RediSearch moduleyes
SQL infoSupport of SQLnoyesyeswith RediSQL moduleyes infofull PostgreSQL SQL syntax
APIs and other access methodsJava API
RESTful HTTP API
Thrift
.NET Client API
JDBC
ODBC
OLE DB
ADO.NET
JDBC
ODBC
proprietary protocol infoRESP - REdis Serialization ProtocolADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesC
C#
C++
Groovy
Java
PHP
Python
Scala
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
.Net
C
C++
Delphi
Java
Object Pascal
PHP
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
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresyes infoCoprocessors in JavaPL/SQL, SQL PLyes infoInterbase procedure and trigger languageLua; Redis Functions coming in Redis 7 (slides and Github)user defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersyesyesyespublish/subscribe channels provide some trigger functionality; RedisGearsyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingnoneSharding infoAutomatic hash-based sharding with support for hash-tags for manual shardingyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
yesInterbase Change ViewsMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
Source-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnonothrough RedisGearsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
Immediate Consistency
Foreign keys infoReferential integritynoyesyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataSingle row ACID (across millions of columns)ACIDACIDAtomic execution of command blocks and scripts and optimistic lockingACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoMultiversion concurreny controlyes infoData access is serialized by the serveryes
Durability infoSupport for making data persistentyesyesyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logsyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyesyesno
User concepts infoAccess controlAccess Control Lists (ACL) for RBAC, integration with Apache Ranger for RBAC & ABACfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardAccess 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
fine grained access rights according to SQL-standard

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 Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
» more

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

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

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

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

More resources
HBaseIBM Db2 warehouse infoformerly named IBM dashDBInterbaseRedisTimescaleDB
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, 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

Best Practices from Rackspace for Modernizing a Legacy HBase/Solr Architecture Using AWS Services | Amazon Web ...
9 October 2023, AWS Blog

Newest trends at the 2024 HBASE Home Show
15 February 2024, KELOLAND.com

Less Components, Higher Performance: Apache Doris instead of ClickHouse, MySQL, Presto, and HBase
20 October 2023, hackernoon.com

Migrate data from Apache HBase to Amazon DynamoDB | Amazon Web Services
23 May 2023, AWS Blog

HBase: The database big data left behind
6 May 2016, InfoWorld

provided by Google News

Introducing the next generation of Db2 Warehouse: Our cost-effective, cloud-native data warehouse built for always-on ...
11 July 2023, ibm.com

Announcing the deprecation of prior generation Db2 Warehouse plans on AWS
16 October 2023, ibm.com

Top 7 Cloud Data Warehouse Companies
31 May 2023, Datamation

Db2 Warehouse delivers 4x faster query performance than previously, while cutting storage costs by 34x
11 July 2023, ibm.com

Data mining in Db2 Warehouse: the basics
23 June 2020, Towards Data Science

provided by Google News

Borland InterBase backdoor detected
11 January 2001, ZDNet

Borland Interbase backdoor exposed • The Register
12 January 2001, The Register

Johnson Sakaja Donates KSh 200k to Support Cash Strapped Football Teams From Kibera - Tuko.co.ke
21 February 2024, Tuko.co.ke

An independent soccer league transforming lives in a slum in Kenya
15 November 2022, FanSided

Malaysian e-commerce firm Lelong.my acquires local digital marketing agency Mataris Agency
29 January 2018, Yahoo Singapore News

provided by Google News

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

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

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

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

Redis tightens its license terms, pleasing basically no one
22 March 2024, The Register

provided by Google News

TimescaleDB Is a Vector Database Now, Too
25 September 2023, Datanami

Timescale Launches Dynamic PostgreSQL, the Cost-Effective Alternative to Serverless and Peak-Allocation Pay Models
6 November 2023, PR Newswire

Timescale Introduces Dynamic PostgreSQL, an Alternative to Serverless Databases
19 November 2023, InfoQ.com

Visualizing IoT Data at Scale With Hopara and TimescaleDB
16 May 2023, Embedded Computing Design

Power IoT and time-series workloads with TimescaleDB for Azure Database for PostgreSQL
18 March 2019, azure.microsoft.com

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

AllegroGraph logo

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

Ontotext logo

GraphDB allows you to link diverse data, index it for semantic search and enrich it via text analysis to build big knowledge graphs. Get it free.

Neo4j logo

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

Present your product here