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. Apache IoTDB vs. IBM Cloudant vs. Microsoft Azure SQL Database vs. STSdb

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

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 comparisonSTSdb  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 ServerKey-Value Store with special method for indexing infooptimized for high performance using a special indexing method
Primary database modelKey-value storeTime Series DBMSDocument storeRelational DBMSKey-value store
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score2.11
Rank#123  Overall
#24  Key-value stores
Score0.42
Rank#253  Overall
#20  Time Series DBMS
Score3.47
Rank#95  Overall
#17  Document stores
Score85.33
Rank#15  Overall
#10  Relational DBMS
Score0.01
Rank#345  Overall
#53  Key-value stores
Websiteaws.amazon.com/­simpledbiotdb.apache.orgwww.ibm.com/­cloud/­cloudantazure.microsoft.com/­en-us/­services/­sql-databasegithub.com/­STSSoft/­STSdb4
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 2014MicrosoftSTS Soft SC
Initial release20072018201020102011
Current releaseV124.0.8, September 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2.0commercialcommercialOpen Source infoGPLv2, commercial license available
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.
Implementation languageJavaErlangC++C#
Server operating systemshostedAll OS with a Java VM (>= 1.8)hostedhostedWindows
Data schemeschema-freeyesschema-freeyesyes
Typing infopredefined data types such as float or datenoyesnoyesyes infoprimitive types and user defined types (classes)
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 automaticallyyesyesyesno
SQL infoSupport of SQLnoSQL-like query languagenoyesno
APIs and other access methodsRESTful HTTP APIJDBC
Native API
RESTful HTTP/JSON APIADO.NET
JDBC
ODBC
.NET Client API
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
C#
Java
Server-side scripts infoStored proceduresnoyesView functions (Map-Reduce) in JavaScriptTransact SQLno
Triggersnoyesyesyesno
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationShardingnone
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication
Source-replica replication
yes, with always 3 replicas availablenone
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoIntegration with Hadoop and Sparkyesnono
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 integritynononoyesno
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 possibleACIDno
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.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-standardno

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 SimpleDBApache IoTDBIBM CloudantMicrosoft Azure SQL Database infoformerly SQL AzureSTSdb
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

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

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

show all

Recent citations in the news

Amazon Simple Database Service (SimpleDB)
21 March 2022, TechTarget

Why AWS Keeps It Simple
13 December 2021, Datanami

Amazon DynamoDB Serves Trillions Of Requests Per Month While Counterpart SimpleDB Is No Longer A Listed Product On AWS
13 November 2013, TechCrunch

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

provided by Google News

The Apache® Software Foundation Announces Program for ApacheCon@Home 2021
17 August 2021, GlobeNewswire

provided by Google News

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

IBM extends Call for Code for Racial Justice program
24 February 2021, TechTarget

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

Cloudant Upgrades Cloud Database Service With Integrated Text Indexing and Search Based on Apache Lucene
9 October 2012, PR Newswire

Cloudant Merges BigCouch Into Apache CouchDB
22 July 2013, eWeek

provided by Google News

Microsoft Announces Intelligent Data Platform For Database Integration
24 May 2022, TechDecisions

Microsoft Power BI Gets Low-Code Datamart Feature
24 May 2022, thenewstack.io

The biggest Azure announcements from Microsoft Build 2022 - Cloud
24 May 2022, CRN Australia

Manage Red Hat workloads seamlessly on Azure | Azure Blog and Updates
10 May 2022, Microsoft

SQL Server in Azure database choices and what they offer users
29 July 2019, TechTarget

provided by Google News

Job opportunities

Platform & Systems Architect - Remote
TTEC, Englewood, CO

Software Development Engineer II
Amazon.com Services LLC, Austin, TX

Senior Data Architect (remote)
LinQuest Corporation, Beavercreek, OH

Sr. Global Alliance Manager, DevOps
Amazon Web Services, Inc., Austin, TX

Senior Partner Development Manager, Telecommunications, Media, and Technology
Amazon Web Services, Inc., Los Angeles, CA

Senior Database Administrator - SQL Server
Bonterra, Washington, DC

Senior Oracle/SQL Server Database Administrator - REMOTE OPPORTUNITY
Superior Court of Orange County, Orange County, CA

Senior Database Engineer-SQL Server
WELLS FARGO BANK, West Des Moines, IA

Database Administrator
PacificSource Health Plans, Springfield, OR

Database Administrator
PacificSource Health Plans, Boise, ID

jobs by Indeed



Share this page

Featured Products

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!

Redis logo

The world’s most loved real‑time data platform.
Try free

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.

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

Present your product here