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

DBMS > Amazon SimpleDB vs. Apache IoTDB vs. IBM Cloudant vs. Microsoft Azure SQL Database

System Properties Comparison Amazon SimpleDB vs. Apache IoTDB vs. IBM Cloudant vs. Microsoft Azure SQL Database

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonApache IoTDB  Xexclude from comparisonIBM Cloudant  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  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 ScioreAn IoT native database with high performance for data management and analysis, deployable on the edge and the cloud and integrated with Hadoop, Spark and FlinkDatabase as a Service offering based on Apache CouchDBDatabase as a Service offering with high compatibility to Microsoft SQL Server
Primary database modelKey-value storeTime Series DBMSDocument storeRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.09
Rank#123  Overall
#24  Key-value stores
Score0.36
Rank#264  Overall
#21  Time Series DBMS
Score3.33
Rank#95  Overall
#17  Document stores
Score84.89
Rank#15  Overall
#10  Relational DBMS
Websiteaws.amazon.com/­simpledbiotdb.apache.orgwww.ibm.com/­cloud/­cloudantazure.microsoft.com/­en-us/­services/­sql-database
Technical documentationdocs.aws.amazon.com/­simpledbcloud.ibm.com/­docs/­Cloudantdocs.microsoft.com/­en-us/­azure/­azure-sql
DeveloperAmazonApache Software FoundationIBM, Apache Software Foundation infoIBM acquired Cloudant in February 2014Microsoft
Initial release2007201820102010
Current releaseV12
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud serviceyesnoyesyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaErlangC++
Server operating systemshostedAll OS with a Java VM (>= 1.8)hostedhosted
Data schemeschema-freeyesschema-freeyes
Typing infopredefined data types such as float or datenoyesnoyes
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.nonoyes
Secondary indexesyes infoAll columns are indexed automaticallyyesyesyes
SQL infoSupport of SQLnoSQL-like query languagenoyes
APIs and other access methodsRESTful HTTP APIJDBC
Native API
RESTful HTTP/JSON APIADO.NET
JDBC
ODBC
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
C#
Java
JavaScript
Objective-C
PHP
Ruby
.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
Server-side scripts infoStored proceduresnoyesView functions (Map-Reduce) in JavaScriptTransact SQL
Triggersnoyesyesyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication
Source-replica replication
yes, with always 3 replicas available
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoIntegration with Hadoop and Sparkyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Eventual Consistency
Strong Consistency with Raft
Eventual ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyes
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 possibleACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoOptimistic lockingyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)yesAccess rights for users can be defined per databasefine grained access rights according to SQL-standard
More information provided by the system vendor
Amazon SimpleDBApache IoTDBIBM CloudantMicrosoft Azure SQL Database infoformerly SQL Azure
Specific characteristicsApache IoTDB (Internet of Things Database) is a time series data management system...
» more
Competitive advantagesLow Cost and High Performance Tens of million points write throughput High compression...
» more
Typical application scenariosIoT / IIoT End-Edge-Cloud Collaboration Real-Time and Historian Time Series Analytics
» more
Key customersOver 200 customers worldwide, including Bosch, Siemens, Komat'su, Alibaba, etc.
» more
Market metrics185+ contributors and 10,000+ times monthly clones on GitHub Rank 7 by commits among...
» more
Licensing and pricing modelsOpen Source: Apache License v2.0 Pricing for commercial-/cloud-/edge-edition provided...
» 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
Amazon SimpleDBApache IoTDBIBM CloudantMicrosoft Azure SQL Database infoformerly SQL Azure
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