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 > Datastax Enterprise vs. Faircom DB vs. OpenTSDB vs. TerarkDB vs. TiDB

System Properties Comparison Datastax Enterprise vs. Faircom DB vs. OpenTSDB vs. TerarkDB vs. TiDB

Editorial information provided by DB-Engines
NameDatastax Enterprise  Xexclude from comparisonFaircom DB infoformerly c-treeACE  Xexclude from comparisonOpenTSDB  Xexclude from comparisonTerarkDB  Xexclude from comparisonTiDB  Xexclude from comparison
DescriptionDataStax Enterprise (DSE) is the always-on, scalable data platform built on Apache Cassandra and designed for hybrid Cloud. DSE integrates graph, search, analytics, administration, developer tooling, and monitoring into a unified platform.Native high-speed multi-model DBMS for relational and key-value store data simultaneously accessible through SQL and NoSQL APIs.Scalable Time Series DBMS based on HBaseA key-value store forked from RocksDB with advanced compression algorithms. It can be used standalone or as a storage engine for MySQL and MongoDBTiDB is an open source distributed Hybrid Transactional/Analytical Processing (HTAP) database that supports MySQL and Spark SQL syntaxes.
Primary database modelWide column storeKey-value store
Relational DBMS
Time Series DBMSKey-value storeRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Search engine
Document store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score9.89
Rank#48  Overall
#4  Wide column stores
Score0.44
Rank#247  Overall
#38  Key-value stores
#116  Relational DBMS
Score1.86
Rank#126  Overall
#8  Time Series DBMS
Score0.04
Rank#325  Overall
#50  Key-value stores
Score3.26
Rank#95  Overall
#51  Relational DBMS
Websitewww.datastax.com/­products/­datastax-enterprisewww.faircom.com/­products/­faircom-dbopentsdb.netgithub.com/­Terark/­terarkdbpingcap.com
Technical documentationdocs.datastax.comlearn.faircomcorp.com/­developers/­documentation_directoryopentsdb.net/­docs/­build/­html/­index.htmlgithub.com/­Terark/­terarkdb/­wikidocs.pingcap.com/­tidb/­stable
DeveloperDataStaxFairCom Corporationcurrently maintained by Yahoo and other contributorsTerarkPingCAP, Inc.
Initial release20111979201120162016
Current release6.8, April 2020V12, November 20205.0.1, April 2021
License infoCommercial or Open Sourcecommercialcommercial infoRestricted, free version availableOpen Source infoLGPLcommercial inforestricted open source version availableOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
TiDB Cloud: Fully-managed TiDB Service. Bring everything great about TiDB to the cloud.
Implementation languageJavaANSI C, C++JavaC++Go, Rust
Server operating systemsLinux
OS X
AIX
FreeBSD
HP-UX
Linux
NetBSD
OS X
QNX
SCO
Solaris
VxWorks
Windows infoeasily portable to other OSs
Linux
Windows
Linux
Data schemeschema-freeschema free, schema optional, schema required, partial schema,schema-freeschema-freeyes
Typing infopredefined data types such as float or dateyesyes, ANSI SQL Types, JSON, typed binary structuresnumeric data for metrics, strings for tagsnoyes
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.nonononono
Secondary indexesyesyesnonoyes
SQL infoSupport of SQLSQL-like DML and DDL statements (CQL); Spark SQLyes, ANSI SQL with proprietary extensionsnonoyes
APIs and other access methodsProprietary protocol infoCQL (Cassandra Query Language)
TinkerPop Gremlin infowith DSE Graph
ADO.NET
Direct SQL
JDBC
JPA
ODBC
RESTful HTTP/JSON API
RESTful MQTT/JSON API
RPC
HTTP API
Telnet API
C++ API
Java API
JDBC
ODBC
Proprietary protocol
Supported programming languagesC
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
.Net
C
C#
C++
Java
JavaScript (Node.js and browser)
PHP
Python
Visual Basic
Erlang
Go
Java
Python
R
Ruby
C++
Java
Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnoyes info.Net, JavaScript, C/C++nonono
Triggersyesyesnonono
Partitioning methods infoMethods for storing different data on different nodesSharding infono "single point of failure"File partitioning, horizontal partitioning, sharding infoCustomizable business rules for table partitioningSharding infobased on HBasenonehorizontal partitioning (by key range)
Replication methods infoMethods for redundantly storing data on multiple nodesconfigurable replication factor, datacenter aware, advanced replication for edge computingyes, configurable to be parallel or serial, synchronous or asynchronous, uni-directional or bi-directional, ACID-consistent or eventually consistent (with custom conflict resolution).selectable replication factor infobased on HBasenoneUsing Raft consensus algorithm to ensure data replication with strong consistency among multiple replicas.
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnononoyes infowith TiSpark Connector
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Tunable Consistency infoconsistency level can be individually decided with each write operation
Eventual Consistency
Immediate Consistency
Tunable consistency per server, database, table, and transaction
Immediate Consistency infobased on HBaseImmediate Consistency
Foreign keys infoReferential integritynoyesnonono infocurrently only supported in syntax
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoAtomicity and isolation are supported for single operationstunable from ACID to Eventually ConsistentnonoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesYes, tunable from durable to delayed durability to in-memoryyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesnoyesno
User concepts infoAccess controlAccess rights for users can be defined per objectFine grained access rights according to SQL-standard with additional protections for filesnonoUsers with fine-grained authorization concept. No user groups or roles.
More information provided by the system vendor
Datastax EnterpriseFaircom DB infoformerly c-treeACEOpenTSDBTerarkDBTiDB
Specific characteristicsDataStax Enterprise is scale-out data infrastructure for enterprises that need to...
» more
Achieve Hundreds of Thousands of Transactions Per Second on A Single Database Server...
» more
TiDB is an open-source NewSQL database built by PingCAP. TiDB supports Hybrid Transactional...
» more
Competitive advantagesSupporting the following application requirements: Zero downtime - Built on Apache...
» more
Top Features SQL Key-value store and navigational NoSQL API Indexed binary objects...
» more
In the current database landscape, infrastructure engineers often have to use one...
» more
Typical application scenariosApplications that must be massively and linearly scalable with 100% uptime and able...
» more
Real-time transaction processing solutions leverage FairCom DB because its NoSQL...
» more
TiDB is designed to support both OLTP and OLAP scenarios. You can use TiDB , the...
» more
Key customersCapital One, Cisco, Comcast, eBay, McDonald's, Microsoft, Safeway, Sony, UBS, and...
» more
Microsoft, UPS, Verizon, Motorola, Commvault, Thomson Reuters, ACI, BNY Mellon, Rockwell...
» more
Shopee (E-commerce) BookMyShow.com (E-commerce) Yiguo.com (E-commerce) JD Cloud &...
» more
Market metricsAmong the Forbes 100 Most Innovative Companies, DataStax is trusted by 5 of the top...
» more
From banking and financial transactions, transportation, warehouse automation, package...
» more
25K+ GitHub Stars for TiDB, and 8K+ GitHub Stars for TiKV 1.6K+ members in TiDB Community...
» more
Licensing and pricing modelsAnnual subscription
» more
Just as the technical aspects of FairCom DB are flexible to meet operation requirements,...
» more
Open Source Apache 2.0 with either commercial licensing or fully-hosted DB-as-a-service...
» 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

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

More resources
Datastax EnterpriseFaircom DB infoformerly c-treeACEOpenTSDBTerarkDBTiDB
DB-Engines blog posts

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

show all

Recent citations in the news

“We are the CIO’s secret weapon”
13 January 2022, The Stack

DataStax Shows Strong Momentum with New Customers, Partners and Products
26 May 2021, Business Wire

DataStax Further Expands in Asia-Pacific with New Office and General Manager in China
3 November 2021, Business Wire

DataStax Q2 Marked by Strong Growth with Leading Enterprises Including Barracuda Networks and Priceline
31 August 2021, Business Wire

DataStax Accelerates Global Growth in Q3 with New Customers Including GrubHub, M&T Bank and Axway and Strong Demand for its Serverless Cloud Database, Astra DB
29 November 2021, Business Wire

provided by Google News

FairCom Announces New and Rebranded Data Products
23 November 2020, Database Trends and Applications

FairCom lives 2021 on the 'edge' with IoT data management solution
20 December 2021, PRNewswire

World's First Converged IIoT Hub to be Showcased at IoT Tech Expo
3 September 2021, Automation.com

provided by Google News

TAOS Data Announces The Release of taosAdapter: In Support of Seamless Migration from OpenTSDB to TDengine
14 December 2021, PRNewswire

Pinterest Switches from OpenTSDB to Their Own Time Series Database
16 September 2018, InfoQ.com

RedisTimeSeries Module Adds Time Series Database Features to Redis
20 July 2019, InfoQ.com

provided by Google News

Understand NVMe 2.0 specification and its related features
4 January 2022, TechTarget

ByteDance eyes big data push with Terark acquisition EJINSIGHT - ejinsight.com
30 April 2019, EJ Insight

Terark, A Chinese Startup, May Have Just Revolutionized How Data Is Stored, Accessed & Analyzed
26 June 2017, Indiatimes.com

provided by Google News

PingCAP Introduces its New Developer Tier to Boost Application Innovation with TiDB Cloud
9 November 2021, PRNewswire

PingCAP announces Public Preview of TiDB Cloud USA - English
10 May 2021, PRNewswire

SD Times Open-Source Project of the Week: TiDB
5 November 2021, SDTimes.com

PingCAP Enhances Support for Data Intensive Applications with TiDB 5.3
7 December 2021, PRNewswire

PingCap TiDB 5.3 Supports Both High Volume Transaction Processing and Real-Time Analytics
4 January 2022, Database Trends and Applications

provided by Google News

Job opportunities

Datastax Engineer
M&T Bank, Buffalo, NY

Enterprise Customer Success Manager (Remote US)
DataStax, San Francisco Bay Area, CA

System Administrator
CDO Technologies Inc, Warner Robins, GA

Director, Enterprise Applications
TuSimple, San Diego, CA

Federal Account Executive
DataStax, Washington, DC

Sales Operations Manager
FairCom, Salt Lake City, UT

Account Executive
FairCom, Sandy, UT

Account Executive (Hybrid)
FairCom, Salt Lake City, UT

Software Engineer
FairCom, Sandy, UT

QA Engineer (Hybrid)
FairCom, Salt Lake City, UT

Sr. Member of Technical Staff
Oracle, United States

DevOps Engineer
Sapient Industries, Pennsylvania

Reliability Engineer - Observability
Two Sigma Investments, LLC., New York, NY

Software Engineer
Intelliforce IT Solutions Group, Ellicott City, MD

Senior Software Engineer, Observability
Cruise, California

Software Engineer, Storage and Caching
Pinterest, United States

Senior HR Business Partner, North America
PingCAP, Remote

Sales Account Executive- Remote
PingCAP, Remote

Senior Recruiter, North America Business
PingCAP, Remote

Engineering Manager, Cash App Pay
Cash App, Ontario, CA

jobs by Indeed



Share this page

Featured Products

Datastax Astra logo

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

AllegroGraph logo

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

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here