DBMS > Alibaba Cloud Table Store vs. CouchDB vs. Cubrid vs. Faircom EDGE

System Properties Comparison Alibaba Cloud Table Store vs. CouchDB vs. Cubrid vs. Faircom EDGE

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Alibaba Cloud Table Store  Xexclude from comparison	CouchDB stands for "Cluster Of Unreliable Commodity Hardware"  Xexclude from comparison	Cubrid  Xexclude from comparison	Faircom EDGE formerly c-treeEDGE  Xexclude from comparison
Description	A fully managed Wide Column Store for large quantities of semi-structured data with real-time access	A native JSON - document store inspired by Lotus Notes, scalable from globally distributed server-clusters down to mobile phones.	CUBRID is an open-source SQL-based relational database management system with object extensions for OLTP	FairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environments
Primary database model	Wide column store	Document store	Relational DBMS	Key-value store Relational DBMS
Secondary database models		Spatial DBMS using the Geocouch extension
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 0.38 Rank #261   Overall #11   Wide column stores	Score 17.16 Rank #41   Overall #7   Document stores	Score 1.02 Rank #173   Overall #84   Relational DBMS	Score 0.07 Rank #327   Overall #48   Key-value stores #148   Relational DBMS
Website	www.alibabacloud.com/­product/­table-store	couchdb.apache.org	cubrid.com (korean) cubrid.org (english)	www.faircom.com/­products/­faircomedge-iot-database
Technical documentation	www.alibabacloud.com/­help/­product/­27278.htm	docs.couchdb.org/­en/­stable	cubrid.org/­manuals	learn.faircomcorp.com/­developers/­documentation_directory
Developer	Alibaba	Apache Software Foundation Apache top-level project, originally developed by Damien Katz, a former Lotus Notes developer	CUBRID Corporation, CUBRID Foundation	FairCom Corporation
Initial release	2016	2005	2008	1979
Current release		3.2.2, April 2022	11.0, January 2021	V3, October 2020
License Commercial or Open Source	commercial	Open Source Apache version 2	Open Source Apache Version 2.0	commercial Restricted, free version available
Cloud-based only Only available as a cloud service	yes	no	no	no
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Erlang	C, C++, Java	ANSI C, C++
Server operating systems	hosted	Android BSD Linux OS X Solaris Windows	Linux Windows	Android Linux ARM, x86 Raspbian Windows
Data scheme	schema-free	schema-free	yes	Flexible Schema (defined schema, partial schema, schema free)
Typing predefined data types such as float or date	yes	no	yes	yes, ANSI Standard SQL Types
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.	no	no	no	yes
Secondary indexes	no	yes via views	yes	yes
SQL Support of SQL	no	no	yes	yes ANSI SQL queries
APIs and other access methods	HTTP API	RESTful HTTP/JSON API	ADO.NET JDBC ODBC OLE DB	ADO.NET Direct SQL IoT Microservice layer JDBC MQTT (Message Queue Telemetry Transport) ODBC RESTful HTTP API
Supported programming languages	Java Python	C C# ColdFusion Erlang Haskell Java JavaScript Lisp Lua Objective-C OCaml Perl PHP PL/SQL Python Ruby Smalltalk	C C# C++ Go Java JavaScript (Node.js) Perl PHP Python Ruby	C C# C++ Java JavaScript PHP Python VB.Net
Server-side scripts Stored procedures	no	View functions in JavaScript	Java Stored Procedures	yes .Net, JavaScript, C/C++
Triggers	no	yes	yes	yes
Partitioning methods Methods for storing different data on different nodes	Sharding Implicit feature of the cloud service	Sharding improved architecture with release 2.0	none	File partitioning Customizable business rules for partitioning
Replication methods Methods for redundantly storing data on multiple nodes	yes Implicit feature of the cloud service	Multi-source replication Source-replica replication	Source-replica replication	yes Synchronous and asynchronous realtime replication based on transaction logs
MapReduce Offers an API for user-defined Map/Reduce methods	no	yes	no	no
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency	Eventual Consistency	Immediate Consistency	Immediate Consistency Tunable Consistency
Foreign keys Referential integrity	no	no	yes	yes when using SQL
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	Atomic single-row operations	no atomic operations within a single document possible	ACID	ACID
Concurrency Support for concurrent manipulation of data	yes	yes strategy: optimistic locking	yes	yes across SQL and NoSQL
Durability Support for making data persistent	yes	yes	yes	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	no	no	no	yes
User concepts Access control	Access rights based on subaccounts and tokens	Access rights for users can be defined per database	fine grained access rights according to SQL-standard	Fine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.
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 We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	Alibaba Cloud Table Store	CouchDB stands for "Cluster Of Unreliable Commodity Hardware"	Cubrid	Faircom EDGE formerly c-treeEDGE
DB-Engines blog posts