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 > Apache Kylin vs. Oracle Berkeley DB vs. Redis

System Properties Comparison Apache Kylin vs. Oracle Berkeley DB vs. Redis

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Kylin  Xexclude from comparisonOracle Berkeley DB  Xexclude from comparisonRedis  Xexclude from comparison
DescriptionA distributed analytics engine for big data, providing a SQL interface and multi-dimensional analysis (OLAP) and leveraging the Hadoop stackWidely 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.
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 persistence
Secondary database modelsDocument 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
Score1.18
Rank#172  Overall
#79  Relational DBMS
Score2.21
Rank#117  Overall
#20  Key-value stores
#3  Native XML DBMS
Score157.80
Rank#6  Overall
#1  Key-value stores
Websitekylin.apache.orgwww.oracle.com/­database/­technologies/­related/­berkeleydb.htmlredis.com
redis.io
Technical documentationkylin.apache.org/­docsdocs.oracle.com/­cd/­E17076_05/­html/­index.htmldocs.redis.com/­latest/­index.html
redis.io/­docs
DeveloperApache Software Foundation, originally contributed from eBay IncOracle infooriginally developed by Sleepycat, which was acquired by OracleRedis project core team, inspired by Salvatore Sanfilippo infoDevelopment sponsored by Redis Inc.
Initial release201519942009
Current release3.1.0, July 202018.1.40, May 20207.2.4, January 2024
License infoCommercial or Open SourceOpen Source infoApache Version 2.0Open Source infocommercial license availableOpen Source infosource-available extensions (modules), commercial licenses for Redis Enterprise
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.
Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
Implementation languageJavaC, Java, C++ (depending on the Berkeley DB edition)C
Server operating systemsLinuxAIX
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-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 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.noyes infoonly with the Berkeley DB XML editionno
Secondary indexesyesyesyes infowith RediSearch module
SQL infoSupport of SQLANSI SQL for queries (using Apache Calcite)yes infoSQL interfaced based on SQLite is availablewith RediSQL module
APIs and other access methodsJDBC
ODBC
RESTful HTTP API
proprietary protocol infoRESP - REdis Serialization Protocol
Supported programming languages.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
Server-side scripts infoStored proceduresnoLua; Redis Functions coming in Redis 7 (slides and Github)
Triggersyes infoonly for the SQL APIpublish/subscribe channels provide some trigger functionality; RedisGears
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infoAutomatic hash-based sharding with support for hash-tags for manual sharding
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnothrough RedisGears
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
Foreign keys infoReferential integritynono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDAtomic execution of command blocks and scripts and optimistic locking
Concurrency infoSupport for concurrent manipulation of datayesyes 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.noyesyes
User concepts infoAccess controlnoAccess 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

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 partiesNavicat for Redis: the award-winning Redis management tool with an intuitive and powerful graphical interface.
» more

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

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

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

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

More resources
Apache KylinOracle Berkeley DBRedis
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

Introducing Kyligence Copilot: The AI Copilot for Data to Excel Your KPIs
23 August 2023, insideBIGDATA

Overhauling Apache Kylin for the cloud
18 November 2021, InfoWorld

eBay's Kylin Becomes a Top-Level Apache Open Source Project
9 December 2015, eBay Inc.

The Apache Software Foundation Announces Apache™ Kylin™ as a Top-Level Project
8 December 2015, GlobeNewswire

Distributed OLAPer Kyligence accelerates core engine, adds real-time data support – Blocks and Files
10 August 2021, Blocks & Files

provided by Google News

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

Database Trends Report: SQL Beats NoSQL, MySQL Most Popular -- ADTmag
5 March 2019, ADT Magazine

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

The importance of bitcoin nodes and how to start one
9 May 2014, The Merkle News

provided by Google News

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

AWS announces vector search for Amazon MemoryDB for Redis (Preview)
29 November 2023, AWS Blog

Boosting throughput for cloud databases
29 April 2024, The Register

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

provided by Google News



Share this page

Featured Products

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

Milvus logo

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

SingleStore logo

The database to transact, analyze and contextualize your data in real time.
Try it today.

RaimaDB logo

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

Present your product here