DBMS > Amazon Aurora vs. Ehcache vs. IBM Cloudant

System Properties Comparison Amazon Aurora vs. Ehcache vs. IBM Cloudant

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
Name	Amazon Aurora  Xexclude from comparison	Ehcache  Xexclude from comparison	IBM Cloudant  Xexclude from comparison
Description	MySQL and PostgreSQL compatible cloud service by Amazon	A widely adopted Java cache with tiered storage options	Database as a Service offering based on Apache CouchDB
Primary database model	Relational DBMS	Key-value store	Document store
Secondary database models	Document store
DB-Engines Ranking measures the popularity of database management systems Trend Chart	Score 12.86 Rank #45   Overall #29   Relational DBMS	Score 6.52 Rank #65   Overall #8   Key-value stores	Score 3.33 Rank #95   Overall #17   Document stores
Website	aws.amazon.com/­rds/­aurora	www.ehcache.org	www.ibm.com/­cloud/­cloudant
Technical documentation	docs.aws.amazon.com/­AmazonRDS/­latest/­AuroraUserGuide/­CHAP_Aurora.html	www.ehcache.org/­documentation	cloud.ibm.com/­docs/­Cloudant
Developer	Amazon	Terracotta Inc, owned by Software AG	IBM, Apache Software Foundation IBM acquired Cloudant in February 2014
Initial release	2015	2009	2010
Current release		3.9.6, September 2021
License Commercial or Open Source	commercial	Open Source Apache Version 2; commercial licenses available	commercial
Cloud-based only Only available as a cloud service	yes	no	yes
DBaaS offerings (sponsored links) Database as a Service Providers of DBaaS offerings, please contact us to be listed.
Implementation language		Java	Erlang
Server operating systems	hosted	All OS with a Java VM	hosted
Data scheme	yes	schema-free	schema-free
Typing predefined data types such as float or date	yes	yes	no
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.	yes	no	no
Secondary indexes	yes	no	yes
SQL Support of SQL	yes	no	no
APIs and other access methods	ADO.NET JDBC ODBC	JCache	RESTful HTTP/JSON API
Supported programming languages	Ada C C# C++ D Delphi Eiffel Erlang Haskell Java JavaScript (Node.js) Objective-C OCaml Perl PHP Python Ruby Scheme Tcl	Java	C# Java JavaScript Objective-C PHP Ruby
Server-side scripts Stored procedures	yes	no	View functions (Map-Reduce) in JavaScript
Triggers	yes	yes Cache Event Listeners	yes
Partitioning methods Methods for storing different data on different nodes	horizontal partitioning	Sharding by using Terracotta Server	Sharding
Replication methods Methods for redundantly storing data on multiple nodes	Source-replica replication	yes by using Terracotta Server	Multi-source replication Source-replica replication
MapReduce Offers an API for user-defined Map/Reduce methods	no	no	yes
Consistency concepts Methods to ensure consistency in a distributed system	Immediate Consistency	Tunable Consistency (Strong, Eventual, Weak)	Eventual Consistency
Foreign keys Referential integrity	yes	no	no
Transaction concepts Support to ensure data integrity after non-atomic manipulations of data	ACID	yes supports JTA and can work as an XA resource	no atomic operations within a document possible
Concurrency Support for concurrent manipulation of data	yes	yes	yes Optimistic locking
Durability Support for making data persistent	yes	yes using a tiered cache-storage approach	yes
In-memory capabilities Is there an option to define some or all structures to be held in-memory only.	yes	yes	no
User concepts Access control	fine grained access rights according to SQL-standard	no	Access rights for users can be defined per database
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
	Amazon Aurora	Ehcache	IBM Cloudant
DB-Engines blog posts	Cloud-based DBMS's popularity grows at high rates 12 December 2019, Paul Andlinger The popularity of cloud-based DBMSs has increased tenfold in four years 7 February 2017, Matthias Gelbmann Amazon - the rising star in the DBMS market 3 August 2015, Matthias Gelbmann show all