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. Microsoft Azure Table Storage vs. OpenQM vs. Percona Server for MySQL vs. SAP SQL Anywhere

System Properties Comparison Amazon SimpleDB vs. Microsoft Azure Table Storage vs. OpenQM vs. Percona Server for MySQL vs. SAP SQL Anywhere

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonMicrosoft Azure Table Storage  Xexclude from comparisonOpenQM infoalso called QM  Xexclude from comparisonPercona Server for MySQL  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  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 Wide Column Store for rapid development using massive semi-structured datasetsQpenQM is a high-performance, self-tuning, multi-value DBMSEnhanced drop-in replacement for MySQL based on XtraDB or TokuDB storage engines with improved performance and additional diagnostic and management features.RDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments
Primary database modelKey-value storeWide column storeMultivalue DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.88
Rank#133  Overall
#23  Key-value stores
Score4.04
Rank#77  Overall
#6  Wide column stores
Score0.34
Rank#284  Overall
#10  Multivalue DBMS
Score2.10
Rank#119  Overall
#57  Relational DBMS
Score3.95
Rank#80  Overall
#42  Relational DBMS
Websiteaws.amazon.com/­simpledbazure.microsoft.com/­en-us/­services/­storage/­tableswww.rocketsoftware.com/­products/­rocket-multivalue-application-development-platform/­rocket-open-qmwww.percona.com/­software/­mysql-database/­percona-serverwww.sap.com/­products/­technology-platform/­sql-anywhere.html
Technical documentationdocs.aws.amazon.com/­simpledbwww.percona.com/­downloads/­Percona-Server-LATESThelp.sap.com/­docs/­SAP_SQL_Anywhere
DeveloperAmazonMicrosoftRocket Software, originally Martin PhillipsPerconaSAP infoformerly Sybase
Initial release20072012199320081992
Current release3.4-128.0.36-28, 202417, July 2015
License infoCommercial or Open SourcecommercialcommercialOpen Source infoGPLv2, extended commercial license availableOpen Source infoGPL version 2commercial
Cloud-based only infoOnly available as a cloud serviceyesyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++
Server operating systemshostedhostedAIX
FreeBSD
Linux
macOS
Raspberry Pi
Solaris
Windows
LinuxAIX
HP-UX
Linux
OS X
Solaris
Windows
Data schemeschema-freeschema-freeyes infowith some exceptionsyesyes
Typing infopredefined data types such as float or datenoyesyesyes
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.noyesyesyes
Secondary indexesyes infoAll columns are indexed automaticallynoyesyesyes
SQL infoSupport of SQLnononoyesyes
APIs and other access methodsRESTful HTTP APIRESTful HTTP APIADO.NET
JDBC
ODBC
ADO.NET
HTTP API
JDBC
ODBC
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
.Net
C#
C++
Java
JavaScript (Node.js)
PHP
Python
Ruby
.Net
Basic
C
Java
Objective C
PHP
Python
Ada
C
C#
C++
D
Eiffel
Erlang
Haskell
Java
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
Server-side scripts infoStored proceduresnonoyesyesyes, in C/C++, Java, .Net or Perl
Triggersnonoyesyesyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationSharding infoImplicit feature of the cloud serviceyesnone
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes infoimplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.yesMulti-source replication
Source-replica replication
XtraDB Cluster
Source-replica replication infoDatabase mirroring
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynononoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationoptimistic lockingACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
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.noyesyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access rights based on private key authentication or shared access signaturesAccess rights can be defined down to the item levelUsers with fine-grained authorization concept infono user groups or rolesfine 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

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

More resources
Amazon SimpleDBMicrosoft Azure Table StorageOpenQM infoalso called QMPercona Server for MySQLSAP SQL Anywhere infoformerly called Adaptive Server Anywhere
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

An Overview of Amazon Web Services - Cloud Application Architectures [Book]
22 September 2018, oreilly.com

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

provided by Google News

Working with Azure to Use and Manage Data Lakes
7 March 2024, Simplilearn

How to use Azure Table storage in .Net
14 January 2019, InfoWorld

How to Use C# Azure.Data.Tables SDK with Azure Cosmos DB
9 July 2021, hackernoon.com

Quick Guide to Azure Storage Pricing
16 May 2023, DevOps.com

Inside Azure File Storage
7 October 2015, Microsoft

provided by Google News

A Momentous 2023, Headlined by a 19% increase of ARR, Positions Percona for Even Greater Success in the Year ...
27 March 2024, Business Wire

Sizing Up Servers: Intel's Skylake-SP Xeon versus AMD's EPYC 7000 - The Server CPU Battle of the Decade?
11 July 2017, AnandTech

Update or migrate? Planning for MySQL 5.7 EOL
22 June 2023, InfoWorld

ScaleFlux computational storage makes Percona MySQL faster – Blocks and Files
5 August 2020, Blocks and Files

How to deploy the Percona database performance monitor with Docker
24 February 2023, TechRepublic

provided by Google News

SAP vulnerabilities Let Attacker Inject OS Commands—Patch Now!
11 July 2023, CybersecurityNews

SAP Products & Services Data Portfolio
2 July 2021, Datamation

Securing SAP with AWS Network Firewall: Part 2 – Managed Rules | Amazon Web Services
17 July 2023, AWS Blog

Rimini Street expands support beyond SAP and Oracle
21 May 2016, InsideSAP

MindsDB is now the leading and fastest growing applied ML platform in the world India - English
3 November 2022, PR Newswire

provided by Google News



Share this page

Featured Products

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

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

Present your product here