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 > Aerospike vs. Fauna vs. Kdb+ vs. ScyllaDB

System Properties Comparison Aerospike vs. Fauna vs. Kdb+ vs. ScyllaDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonFauna  Xexclude from comparisonKdb+  Xexclude from comparisonScyllaDB  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL DatabaseFauna (previously named FaunaDB) provides a web-native interface, with support for GraphQL and custom business logic that integrates seamlessly with the rest of the serverless ecosystem. The underlying globally distributed storage and compute platform is fast, consistent, and reliable, with a modern security infrastructure.High performance Time Series DBMSCassandra and DynamoDB compatible wide column store
Primary database modelKey-value storeDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Time Series DBMSKey-value store
Wide column store
Secondary database modelsDocument storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score5.77
Rank#62  Overall
#8  Key-value stores
Score1.67
Rank#135  Overall
#22  Document stores
#12  Graph DBMS
#66  Relational DBMS
#9  Time Series DBMS
Score8.32
Rank#51  Overall
#2  Time Series DBMS
Score2.71
Rank#102  Overall
#19  Key-value stores
#8  Wide column stores
Websitewww.aerospike.comfauna.comkx.comwww.scylladb.com
Technical documentationwww.aerospike.com/­docsdocs.fauna.comcode.kx.comdocs.scylladb.com
DeveloperAerospikeFauna, Inc.Kx Systems, a division of First Derivatives plcScyllaDB
Initial release201220142000 infokdb was released 2000, kdb+ in 20032015
Current release5.6.0.3, May 20213.6, May 2018Scylla Open Source 4.3, January 2021
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availablecommercialcommercial infofree 32-bit versionOpen Source infoOpen Source (AGPL), commercial license available
Cloud-based only infoOnly available as a cloud servicenoyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
Implementation languageCScalaqC++
Server operating systemsLinuxhostedLinux
OS X
Solaris
Windows
Linux
Data schemeschema-freeschema-freeyesschema-free
Typing infopredefined data types such as float or dateyesnoyesyes
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.nonoyesno
Secondary indexesyesyesyes infotable attribute 'grouped'yes infocluster global secondary indices
SQL infoSupport of SQLnonoSQL-like query language (q)SQL-like DML and DDL statements (CQL)
APIs and other access methodsJDBC
Proprietary protocol
RESTful HTTP APIHTTP API
JDBC
Jupyter
Kafka
ODBC
WebSocket
Proprietary protocol (CQL) infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
C#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
C
C#
C++
Go
J
Java
JavaScript
Lua
MatLab
Perl
PHP
Python
R
Scala
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 proceduresuser defined functions infowith Luauser defined functionsuser defined functionsyes, Lua
Triggersnonoyes infowith viewsno
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning infoconsistent hashinghorizontal partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replicationSource-replica replicationselectable replication factor infoRepresentation of geographical distribution of servers is possible
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/Reducenono infosimilar paradigm used for internal processingno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationImmediate ConsistencyImmediate ConsistencyEventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Foreign keys infoReferential integritynoyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsACIDnono infoAtomicity and isolation are supported for single operations
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyesyes infoin-memory tables
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyIdentity management, authentication, and access controlrights management via user accountsAccess rights for users can be defined per object
More information provided by the system vendor
Aerospike infopreviously called CitrusleafFaunaKdb+ScyllaDB
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Serverless database delivered as an API Web-native security model with attribute...
» more
Integrated columnar database & programming system for streaming, real time and historical...
» more
Scylla is a highly-available, highly-scalable, highly-performant NoSQL database....
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
100% serverless , no connection pooling bottlenecks, or cold starts unlike legacy...
» more
provides seamless scalability; runs on industry standard server platforms; is top-ranked...
» more
Highly-performant (efficiently utilizes full resources of a node and network; millions...
» more
Typical application scenariosAerospike excels in mission-critical applications that have mixed read/write workloads...
» more
Javascript apps Serverless backends for microservices Cloud-native apps B2B and B2C...
» more
tick database streaming sensor data massive intelligence applications oil and gas...
» more
AdTech ( AdGear , AppMonet , Dstillery , FullContact , MediaMath , Numberly , SAS...
» more
Key customersNielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services...
» more
ShiftX
» more
Goldman Sachs Morgan Stanley Merrill Lynch J.P. Morgan Deutsche Bank IEX Securities...
» more
Comcast, Grab, OlaCabs, Yahoo! Japan, IMVU, Adgear, Xandr, Zenly, Natura, Snapfish,...
» more
Market metricsAerospike's combination of speed, scalability, and reliability delivers 10x performance...
» more
kdb+ performance and reliability proven by our customers in critical infrastructure...
» more
Licensing and pricing modelsSubscription-based Enterprise Edition and free, open-source Community Edition
» more
Usage-based pricing including a free tier
» more
upon request
» more
Scylla Open Source - free open source software (AGPL) Scylla Enterprise - subscription-based...
» more

Related products and services

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

More resources
Aerospike infopreviously called CitrusleafFaunaKdb+ScyllaDB
DB-Engines blog posts

Evaluating Hbase and Aerospike Solutions for Real-time System of Record
17 March 2020,  Srini Srinivasan, Aerospike (sponsor) 

show all

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

show all

Conferences and events

Scylla Virtual Workshop
Virtual Workshop, 10 AM PT / 1 PM ET / 6 PM BST, 25 June 2021

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

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

Finished events

Building Event Streaming Architectures on Scylla and Kafka
Webinar, 10 AM PT / 1 PM ET / 6 PM GMT, 17 June 2021 (finished)

Recent citations in the news

NoSQL Database Market – Major Technology Giants in Buzz Again | MongoDB, MySQL, Aerospike – The Manomet Current
19 June 2021, The Manomet Current

Why did an American database provider expand its interest in Israeli tech?
12 June 2021, Geektime

Operational Database Management Market to See Huge Growth by 2026 | Oracle, IBM, Neo Technologies – The Manomet Current
21 June 2021, The Manomet Current

Global NoSQL Market Insights Report 2021, Trends & Opportunities to 2027|Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database, etc – KSU | The Sentinel Newspaper
21 June 2021, KSU | The Sentinel Newspaper

Aerospike Adds Expressions to Next-Generation NoSQL Database 5
18 November 2020, Business Wire

provided by Google News

Ten years of NewSQL: Back to the future of distributed relational databases
3 June 2021, S&P Global

How Fauna Delivers Data-as-Utility in a Serverless World | eWEEK
23 April 2021, eWeek

New UK database aims to speed up offshore wind site surveys
10 June 2021, Windpower Monthly

Fauna CEO says cloud APIs help developers build apps without a database
9 May 2021, VentureBeat

Edge computing startup Macrometa gets $20M Series A led by Pelion Venture Partners
15 June 2021, TechCrunch

provided by Google News

AquaQ and Alveo form strategic partnership - HedgeWeek
2 June 2021, HedgeWeek

Weka Sets 6 Records on STAC-M3 With WekaFS Parallel File System on Amazon EC2
8 June 2021, Business Wire

Weka beats DDN, Supermicro Optane and Dell EMC PowerScale in stacks of STAC benchmarks – Blocks and Files
9 June 2021, Blocks and Files

KX Integrates E-Comms With Trade Surveillance for Improved Regulatory Compliance and Fraud Detection
17 June 2021, StreetInsider.com

Time Series Databases Software Market- increasing demand with Industry Professionals: InfluxData, Trendalyze, Amazon Timestream, DataStax, Prometheus, etc – KSU | The Sentinel Newspaper
21 June 2021, KSU | The Sentinel Newspaper

provided by Google News

ScyllaDB Announces Comprehensive Support for Apache Kafka
20 June 2021, AiThority

ScyllaDB Announces Scylla Enterprise 2021 NoSQL Database
20 May 2021, Illinoisnewstoday.com

ScyllaDB Announces NoSQL SOC2 Certification
13 June 2021, Illinoisnewstoday.com

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

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

provided by Google News

Job opportunities

Senior Database Administrator
Fidelity Investments, Westlake, TX

SVP, Product Management
Tru Optik Data Corp, Stamford, CT

App Support Lead
Barclays, Whippany, NJ

Principal Database Administrator - DB2
Fidelity Investments, Durham, NC

Cloud Operations Engineer
Aerospike, California

Fish Biologist
US Interior, US Fish and Wildlife Service, Vancouver, WA

Wildlife Biologist 1
State of West Virginia, West Virginia

613472 - Natural Resources Scientist
Geosyntec Consultants, Richmond, VA

Genetics Research Assistant
Omaha Zoo Group, Omaha, NE

Senior Environmental Specialist (Land Conservation and Management)
Alachua County, FL, Gainesville, FL

Project Manager
Kirlin Mechanical LLC, Rockville, MD

Plumbing and HVAC Estimator
Kirlin Mechanical LLC, Rockville, MD

Systematic Trader
Citadel Securities, Chicago, IL

AMM Quantitative Researcher
Morgan Stanley, New York, NY

Tools Manager
Kirlin Mechanical LLC, Rockville, MD

Senior Infrastructure Engineer
OneSignal, San Mateo, CA

Digital Solutions Senior Platform Engineer
NV Energy, Reno, NV

Principal Data Engineer, ElasticSearch - Secureworks - 100% US Remote
Secureworks, Austin, TX

Software Engineer - Data Platform
Canonical - Jobs, North Carolina

Software Engineer - Data Platform
Canonical, New York State

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.

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!

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.

Present your product here