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 > Amazon SimpleDB vs. ClickHouse vs. IBM Cloudant vs. Microsoft Azure Cosmos DB vs. Transbase

System Properties Comparison Amazon SimpleDB vs. ClickHouse vs. IBM Cloudant vs. Microsoft Azure Cosmos DB vs. Transbase

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonClickHouse  Xexclude from comparisonIBM Cloudant  Xexclude from comparisonMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDB  Xexclude from comparisonTransbase  Xexclude from comparison
DescriptionHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.Database as a Service offering based on Apache CouchDBGlobally distributed, horizontally scalable, multi-model database serviceA resource-optimized, high-performance, universally applicable RDBMS
Primary database modelKey-value storeRelational DBMSDocument storeDocument store
Graph DBMS
Key-value store
Wide column store
Relational DBMS
Secondary database modelsTime Series DBMSSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.88
Rank#133  Overall
#23  Key-value stores
Score15.55
Rank#38  Overall
#23  Relational DBMS
Score2.75
Rank#104  Overall
#19  Document stores
Score27.71
Rank#27  Overall
#4  Document stores
#2  Graph DBMS
#3  Key-value stores
#3  Wide column stores
Score0.17
Rank#334  Overall
#148  Relational DBMS
Websiteaws.amazon.com/­simpledbclickhouse.comwww.ibm.com/­products/­cloudantazure.microsoft.com/­services/­cosmos-dbwww.transaction.de/­en/­products/­transbase.html
Technical documentationdocs.aws.amazon.com/­simpledbclickhouse.com/­docscloud.ibm.com/­docs/­Cloudantlearn.microsoft.com/­azure/­cosmos-dbwww.transaction.de/­en/­products/­transbase/­features.html
DeveloperAmazonClickhouse Inc.IBM, Apache Software Foundation infoIBM acquired Cloudant in February 2014MicrosoftTransaction Software GmbH
Initial release20072016201020141987
Current releasev24.4.1.2088-stable, May 2024Transbase 8.3, 2022
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialcommercialcommercial infofree development license
Cloud-based only infoOnly available as a cloud serviceyesnoyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
  • DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
  • ClickHouse Cloud: Get the performance you love from open source ClickHouse in a serverless offering that takes care of the details so you can spend more time getting insight out of the fastest database on earth.
  • Aiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
Implementation languageC++ErlangC and C++
Server operating systemshostedFreeBSD
Linux
macOS
hostedhostedFreeBSD
Linux
macOS
Solaris
Windows
Data schemeschema-freeyesschema-freeschema-freeyes
Typing infopredefined data types such as float or datenoyesnoyes infoJSON typesyes
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 indexesyes infoAll columns are indexed automaticallyyesyesyes infoAll properties auto-indexed by defaultyes
SQL infoSupport of SQLnoClose to ANSI SQL (SQL/JSON + extensions)noSQL-like query languageyes
APIs and other access methodsRESTful HTTP APIgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
RESTful HTTP/JSON APIDocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
ADO.NET
JDBC
ODBC
Proprietary native API
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
C# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Rust
Scala info3rd party library
C#
Java
JavaScript
Objective-C
PHP
Ruby
.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python
C
C#
C++
Java
JavaScript
Kotlin
Objective-C
PHP
Python
Server-side scripts infoStored proceduresnoyesView functions (Map-Reduce) in JavaScriptJavaScriptyes
TriggersnonoyesJavaScriptyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationkey based and customShardingSharding infoImplicit feature of the cloud service
Replication methods infoMethods for redundantly storing data on multiple nodesyesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.Multi-source replication
Source-replica replication
yes infoImplicit feature of the cloud serviceSource-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyeswith Hadoop integration infoIntegration with Hadoop/HDInsight on Azure*no
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyEventual ConsistencyBounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency infoConsistency level configurable on request level
Session Consistency
Immediate Consistency
Foreign keys infoReferential integritynonononoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationnono infoatomic operations within a document possibleMulti-item ACID transactions with snapshot isolation within a partitionyes
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoOptimistic lockingyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.Access rights for users can be defined per databaseAccess rights can be defined down to the item levelfine grained access rights according to SQL-standard

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
3rd partiesAiven for Clickhouse: Managed cloud data warehousing with high-speed analytics.
» more

DoubleCloud: Fully managed ClickHouse alongside best-in-class managed open-source services to build analytics at scale.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
Amazon SimpleDBClickHouseIBM CloudantMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDBTransbase
DB-Engines blog posts

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

Recent citations in the news

A Place for Everything – Amazon SimpleDB | AWS News Blog
14 December 2007, AWS Blog

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed ...
12 November 2013, TechCrunch

Amazon SimpleDB Management in Eclipse | AWS News Blog
22 July 2009, AWS Blog

Good Advice on Keeping Your Database Simple and Fast.
25 March 2009, All Things Distributed

Amazon Goes Back to the Future With 'NoSQL' Database
19 January 2012, WIRED

provided by Google News

Why Clickhouse Should Be Your Next Database
6 July 2023, The New Stack

ClickHouse Cloud & Amazon S3 Express One Zone: Making a blazing fast analytical database even faster | Amazon ...
28 November 2023, AWS Blog

Intel Xeon 6766E/6780E Sierra Forest vs. Ampere Altra Performance & Power Efficiency Review
5 June 2024, Phoronix

A 1000x Faster Database Solution: ClickHouse’s Aaron Katz
1 November 2023, GrowthCap

From Open Source to SaaS: the Journey of ClickHouse
16 January 2024, InfoQ.com

provided by Google News

Cloudant Best (and Worst) Practices — Part 1
18 March 2019, IBM

Intro to Enterprise Cloud Storage: How to Set Up a Cloudant Database
1 December 2014, Linux.com

IBM Expands Cloud Database Services with Kubernetes
26 September 2019, EnterpriseAI

IBM Code Engine and IBM Cloudant: Serverless Data and Infrastructure
16 August 2021, IBM

IBM to Purchase Cloudant Database as a service (DBaaS) Provider
22 March 2014, App Developer Magazine

provided by Google News

Start your AI journey with Microsoft Azure Cosmos DB—compete for $10K
9 May 2024, azure.microsoft.com

Public Preview: DiskANN vector indexing and search in Azure Cosmos DB NoSQL | Azure updates
21 May 2024, azure.microsoft.com

Building Planet-Scale .NET Apps with Azure Cosmos DB
4 June 2024, Visual Studio Magazine

Public preview: Change partition key of a container in Azure Cosmos DB (NoSQL API) | Azure updates
27 March 2024, azure.microsoft.com

Public Preview: vCore-based Azure Cosmos DB for MongoDB cross-region disaster recovery (DR) | Azure updates
21 May 2024, azure.microsoft.com

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here