DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Aerospike vs. EsgynDB vs. Faircom DB

System Properties Comparison Aerospike vs. EsgynDB vs. Faircom DB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAerospike infopreviously called Citrusleaf  Xexclude from comparisonEsgynDB  Xexclude from comparisonFaircom DB infoformerly c-treeACE  Xexclude from comparison
DescriptionFlash-optimized In-memory NoSQL DatabaseEnterprise-class SQL-on-Hadoop solution, powered by Apache TrafodionNative high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.
Primary database modelDocument store
Key-value store
Spatial DBMS
Relational DBMSKey-value store
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score6.63
Rank#64  Overall
#11  Document stores
#7  Key-value stores
#2  Spatial DBMS
Score0.19
Rank#335  Overall
#147  Relational DBMS
Score0.18
Rank#338  Overall
#47  Key-value stores
#148  Relational DBMS
Websiteaerospike.comwww.esgyn.cnwww.faircom.com/­products/­faircom-db
Technical documentationdocs.aerospike.comlearn.faircomcorp.com/­developers/­documentation_directory
Social network pagesLinkedInTwitterFacebook
DeveloperAerospikeEsgynFairCom Corporation
Initial release201220151979
Current release6.0.0.0, April 2022V12, November 2020
License infoCommercial or Open SourceOpen Source infoApache and AGPL Licenses; open sourced in June 2014; commercial Enterprise Edition availablecommercialcommercial infoRestricted, free version available
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.
Implementation languageCC++, JavaANSI C, C++
Server operating systemsLinuxLinuxAIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows infoeasily portable to other OSs
Data schemeschema-freeyesschema free, schema optional, schema required, partial schema,
Typing infopredefined data types such as float or dateyesyesyes, ANSI SQL Types, JSON, typed binary structures
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.nonono
Secondary indexesyesyesyes
SQL infoSupport of SQLnoyesyes, ANSI SQL with proprietary extensions
APIs and other access methodsJDBC
Proprietary protocol
ADO.NET
JDBC
ODBC
ADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC
Supported programming languages.Net
C
C#
C++
Erlang
Go
Java
JavaScript (Node.js)
Lua
Perl
PHP
Python
Ruby
All languages supporting JDBC/ODBC/ADO.Net.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic
Server-side scripts infoStored proceduresuser defined functions infowith LuaJava Stored Proceduresyes info.Net, JavaScript, C/C++
Triggersnonoyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingFile partitioning, horizontal partitioning, sharding infoCustomizable business rules for table partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replication between multi datacentersyes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).
MapReduce infoOffers an API for user-defined Map/Reduce methodsyes infoAerospike Aggregation Framework is similar to Map/Reduceyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency in cross-datacenter configuration and Immediate Consistency in local cluster configurationImmediate ConsistencyEventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction
Foreign keys infoReferential integritynoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataAtomic execution of operationsACIDtunable from ACID to Eventually Consistent
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesYes, tunable from durable to delayed durability to in-memory
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnoyes
User concepts infoAccess controlAccess rights for users and roles infowith Enterprise Edition onlyfine grained access rights according to SQL-standardFine grained access rights according to SQL-standard with additional protections for files
More information provided by the system vendor
Aerospike infopreviously called CitrusleafEsgynDBFaircom DB infoformerly c-treeACE
Specific characteristicsAerospike is an enterprise-class, NoSQL database solution delivering predictable...
» more
Achieve Hundreds of Thousands of Transactions Per Second on A Single Database Server...
» more
Competitive advantagesOptimized for use with SSDs (solid-state hard drives) Scales horizontally and vertically...
» more
Top Features SQL Key-value store and navigational NoSQL API Indexed binary objects...
» more
Typical application scenariosAerospike excels in mission-critical applications that have mixed read/write workloads...
» more
Real-time transaction processing solutions leverage FairCom DB because its NoSQL...
» more
Key customersNielsen, Williams-Sonoma, Inmobi, AppNexus, Telco (confidential), Financial Services...
» more
Microsoft, UPS, Verizon, Motorola, Commvault, Thomson Reuters, ACI, BNY Mellon, Rockwell...
» more
Market metricsAerospike's combination of speed, scalability, and reliability delivers 10x performance...
» more
From banking and financial transactions, transportation, warehouse automation, package...
» more
Licensing and pricing modelsSubscription-based Enterprise Edition and free, open-source Community Edition
» more
Just as the technical aspects of FairCom DB are flexible to meet operation requirements,...
» more
News

Aerospike 6 on AWS Graviton2 Delivers 1.6x Improvement in Price-Performance
16 November 2022

Aerospike Announces Early Availability of Aerospike Cloud
2 November 2022

Aerospike Appoints Martin James to Lead EMEA
14 September 2022

Aerospike Named to Inc. 5000 List of Fastest-growing Companies in America
17 August 2022

Aerospike Announces Record 2022 First Half
27 July 2022

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

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

More resources
Aerospike infopreviously called CitrusleafEsgynDBFaircom DB infoformerly c-treeACE
DB-Engines blog posts

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

show all

Recent citations in the news

Aerospike Cloud advances real-time database service
3 November 2022, TechTarget

Improving Price Performance Lowers Infrastructure Costs
29 November 2022, thenewstack.io

Accelerating SQL Queries on a Modern Real-Time Database
3 November 2022, thenewstack.io

Aerospike Unveils Database 6
27 April 2022, GlobeNewswire

Redis swallows RESP.app biz that made its database easier on developers
3 November 2022, The Register

provided by Google News

Job opportunities

Principal Database Administrator (Postgres)
Fidelity Investments, Westlake, TX

Senior Database Engineer
PayPal, Washington, DC

Senior Database Engineer
PayPal, Tennessee

Senior Database Engineer
PayPal, Florida

Senior Database Engineer
PayPal, North Carolina

Manager, Solution Architect - DAS Project Omnia
Deloitte, Milwaukee, WI

Manager, Solution Architect - DAS Project Omnia
Deloitte, Honolulu, HI

Manager, Solution Architect - DAS Project Omnia
Deloitte, Gilbert, AZ

Manager, Solution Architect - DAS Project Omnia
Deloitte, Salt Lake City, UT

Manager, Solution Architect - DAS Project Omnia
Deloitte, Omaha, NE

Account Manager
FairCom, Columbia, MO

Account Manager
FairCom, Salt Lake City, UT

Web Designer
FairCom, Salt Lake City, UT

Web Designer
FairCom, Columbia, MO

Technical Writer
FairCom, Sandy, UT

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Present your product here