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 > Derby vs. FoundationDB vs. Redis vs. ScyllaDB

System Properties Comparison Derby vs. FoundationDB vs. Redis vs. ScyllaDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameDerby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDB  Xexclude from comparisonFoundationDB  Xexclude from comparisonRedis  Xexclude from comparisonScyllaDB  Xexclude from comparison
Created as commercial project in 2013, FoundationDB has been acquired by Apple in March 2015 and was withdrawn from the market. As a consequence, the product was removed from the DB-Engines ranking. In April 2018, Apple open-sourced FoundationDB and it therefore reappears in the ranking.
DescriptionFull-featured RDBMS with a small footprint, either embedded into a Java application or used as a database server.Ordered key-value store. Core features are complimented by layers.Popular 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.Cassandra and DynamoDB compatible wide column store
Primary database modelRelational DBMSDocument store infosupported via specific layer
Key-value store
Relational DBMS infosupported via specific SQL-layer
Key-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistenceKey-value store
Wide column store
Secondary database modelsDocument store infowith RedisJSON
Graph DBMS infowith RedisGraph
Spatial DBMS
Search engine infowith RediSearch
Time Series DBMS infowith RedisTimeSeries
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score4.84
Rank#73  Overall
#40  Relational DBMS
Score1.32
Rank#149  Overall
#26  Document stores
#28  Key-value stores
#72  Relational DBMS
Score168.31
Rank#6  Overall
#1  Key-value stores
Score3.17
Rank#92  Overall
#15  Key-value stores
#8  Wide column stores
Websitedb.apache.org/­derbywww.foundationdb.orgredis.io
redislabs.com
www.scylladb.com
Technical documentationdb.apache.org/­derby/­manuals/­index.htmlapple.github.io/­foundationdbdocs.redislabs.com/­latest/­index.html
redis.io/­documentation
docs.scylladb.com
DeveloperApache Software FoundationFoundationDBRedis project core team, inspired by Salvatore Sanfilippo infoDevelopment sponsored by Redis LabsScyllaDB
Initial release1997201320092015
Current release10.15.2.0, March 20206.2.28, November 20206.2.4, June 2021Scylla Open Source 4.3, January 2021
License infoCommercial or Open SourceOpen Source infoApache version 2Open Source infoApache 2.0Open Source infosource-available extensions (modules), commercial licenses for Redis EnterpriseOpen Source infoOpen Source (AGPL), commercial license available
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.
  • Redis Enterprise Cloud: Instantly scale and pay only for the resources you need - on any cloud - AWS, Azure or Google Cloud.
  • 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.
Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
Implementation languageJavaC++CC++
Server operating systemsAll OS with a Java VMLinux
OS X
Windows
BSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
Linux
Data schemeyesschema-free infosome layers support schemasschema-freeschema-free
Typing infopredefined data types such as float or dateyesno infosome layers support typingpartial 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.yesnono
Secondary indexesyesnoyes infowith RediSearch moduleyes infocluster global secondary indices
SQL infoSupport of SQLyessupported in specific SQL layer onlynoSQL-like DML and DDL statements (CQL)
APIs and other access methodsJDBCproprietary protocol infoRESP - REdis Serialization ProtocolProprietary protocol (CQL) infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Supported programming languagesJava.Net
C
C++
Go
Java
JavaScript infoNode.js
PHP
Python
Ruby
Swift
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
For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala
For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
Server-side scripts infoStored proceduresJava Stored Proceduresin SQL-layer onlyLua; Redis Functions coming in Redis 7 (slides and Github)yes, Lua
Triggersyesnopublish/subscribe channels provide some trigger functionality; RedisGearsno
Partitioning methods infoMethods for storing different data on different nodesnoneShardingSharding infoAutomatic hash-based sharding with support for hash-tags for manual shardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
selectable replication factor infoRepresentation of geographical distribution of servers is possible
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonothrough RedisGearsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyLinearizable consistencyEventual Consistency
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
Eventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Foreign keys infoReferential integrityyesin SQL-layer onlynono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDAtomic execution of command blocks and scripts and optimistic lockingno infoAtomicity and isolation are supported for single operations
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoData access is serialized by the serveryes
Durability infoSupport for making data persistentyesyesyes 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.yesyesyes infoin-memory tables
User concepts infoAccess controlfine grained access rights according to SQL-standardnoAccess Control Lists (ACLs): redis.io/­topics/­acl
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/­topics/­encryption
Password-based authentication
Access rights for users can be defined per object
More information provided by the system vendor
Derby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBFoundationDBRedisScyllaDB
Specific characteristicsThe Redis real-time data platform builds upon the unmatched simplicity and speed...
» more
Scylla is a highly-available, highly-scalable, highly-performant NoSQL database....
» more
Competitive advantagesRedis Enterprise is a robust in-memory database platform built by the people who...
» more
Highly-performant (efficiently utilizes full resources of a node and network; millions...
» more
Typical application scenariosRedis Enterprise is used by large enterprise, startup, and government organizations...
» more
AdTech ( AdGear , AppMonet , Dstillery , FullContact , MediaMath , Numberly , SAS...
» more
Key customersVerizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...
» more
Comcast, Grab, OlaCabs, Yahoo! Japan, IMVU, Adgear, Xandr, Zenly, Natura, Snapfish,...
» more
Market metricsMost launched Docker container per day according to Docker Hub (7.2M launches per...
» more
Licensing and pricing modelsRedis Enterprise Cloud lets users scale up and down instantly, and pay only for the...
» more
Scylla Open Source - free open source software (AGPL) Scylla Enterprise - subscription-based...
» 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

Redis Enterprise Cloud: Try with 400$ usage credit.
» 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
Derby infooften called Apache Derby, originally IBM Cloudscape; contained in the Java SDK as JavaDBFoundationDBRedisScyllaDB
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

Conferences and events

Scylla University LIVE (AMERICAS)
9AM-1PM PT / 12PM-4PM ET / 1PM-5PM BRT, 29 July 2021

Finished events

Scylla University LIVE (EMEA and APAC)
12PM-4PM GMT / 2PM-6PM CEST / 5:30PM-9:30PM IST, 28 July 2021 (finished)

Recent citations in the news

Six free databases with commercial-quality features
3 December 2012, Network World

How-to: Use the New Apache Oozie Database Migration Tool
12 November 2016, DZone News

Next Next post: The Ultimate Open Source Database List Profiling 16 Software Tools
30 May 2019, Solutions Review

Staying in sync with your data
14 May 2020, SDTimes.com

JDK 9 Is the End of the Road for Some Features
25 January 2017, DZone News

provided by Google News

Apple Acquires Durable Database Company FoundationDB
24 March 2015, TechCrunch

FoundationDB, a very interesting NoSQL database owned by Apple, is now an open-source project
19 April 2018, GeekWire

Apple’s FoundationDB open sources the database layer behind CloudKit
14 January 2019, 9to5Mac

Apple Open Sources FoundationDB, a Distributed Datastore -- ADTmag
26 April 2018, ADT Magazine

FoundationDB's Record Layer Supports Relational Database Semantics, Schema Management and Indexing
10 February 2019, InfoQ.com

provided by Google News

Redis survey finds AI is stressing IT infrastructure to breaking point
29 June 2021, VentureBeat

Redis Comprehensive Guide for Data Scientists-
30 June 2021, Illinoisnewstoday.com

Non-relational's quiet revolution in databases
1 July 2021, TechRepublic

Scaling CockroachDB in the red ocean of relational databases
15 July 2021, TechCrunch

Pliops XDP hits the streets to rescue X86 servers from data-handling overload – Blocks and Files
27 July 2021, Blocks and Files

provided by Google News

For Developers Only: ScyllaDB Announces P99 CONF Speaker
27 July 2021, GlobeNewswire

ScyllaDB Announces Scylla Enterprise 2021 NoSQL Database
20 May 2021, GlobeNewswire

ScyllaDB Unveils 'Monstrous' New Capabilities for Its NoSQL
12 January 2021, GlobeNewswire

There's a NoSQL Database for That
22 July 2021, Datanami

ScyllaDB Announces Scylla Enterprise 2020 NoSQL Database
19 August 2020, GlobeNewswire

provided by Google News

Job opportunities

INTEGRATION SYSTEMS ENGINEER
Esperanto.ai, Mountain View, CA

Database App Server Engineer
Maryland Courts, Annapolis, MD

Database Developer
Farm Credit Services of America, Omaha, NE

Database Engineer
Wells Fargo, Raleigh, NC

SQL Database Administrator
RM Interiors & Design, Mesa, AZ

Database Administrator
Detroit Tigers, Detroit, MI

Software Engineer - Storage Infrastructure
Discord, San Francisco, CA

Senior Software Engineer - Storage Infrastructure
Discord, San Francisco, CA

Digital Solutions Senior Platform Engineer
NV Energy, Reno, NV

Senior Infrastructure Engineer (Remote CA, NY, TX)
OneSignal, San Mateo, CA

Software Engineer - Data Platform
Canonical - Jobs, California

jobs by Indeed



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

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

Vertica logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

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

Present your product here