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 SQL Database vs. Quasardb vs. SingleStore

System Properties Comparison Amazon SimpleDB vs. Microsoft Azure SQL Database vs. Quasardb vs. SingleStore

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonMicrosoft Azure SQL Database infoformerly SQL Azure  Xexclude from comparisonQuasardb  Xexclude from comparisonSingleStore infoformer name was MemSQL  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 ScioreDatabase as a Service offering with high compatibility to Microsoft SQL ServerDistributed, high-performance timeseries databaseMySQL wire-compliant distributed RDBMS that combines an in-memory row-oriented and a disc-based column-oriented storage with patented universal storage to handle transactional and analytical workloads in one single table type
Primary database modelKey-value storeRelational DBMSTime Series DBMSRelational DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Document store
Spatial DBMS
Time Series DBMS
Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.88
Rank#133  Overall
#23  Key-value stores
Score76.78
Rank#16  Overall
#11  Relational DBMS
Score0.21
Rank#322  Overall
#29  Time Series DBMS
Score5.38
Rank#62  Overall
#35  Relational DBMS
Websiteaws.amazon.com/­simpledbazure.microsoft.com/­en-us/­products/­azure-sql/­databasequasar.aiwww.singlestore.com
Technical documentationdocs.aws.amazon.com/­simpledbdocs.microsoft.com/­en-us/­azure/­azure-sqldoc.quasar.ai/­masterdocs.singlestore.com
DeveloperAmazonMicrosoftquasardbSingleStore Inc.
Initial release2007201020092013
Current releaseV123.14.1, January 20248.5, January 2024
License infoCommercial or Open Sourcecommercialcommercialcommercial infoFree community edition, Non-profit organizations and non-commercial usage are eligible for free licensescommercial infofree developer edition available
Cloud-based only infoOnly available as a cloud serviceyesyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SingleStoreDB Cloud: The world's fastest, modern cloud database for both operational (OLTP) and analytical (OLAP) workloads. Available instantly with multi-cloud and hybrid-cloud capabilities
Implementation languageC++C++C++, Go
Server operating systemshostedhostedBSD
Linux
OS X
Windows
Linux info64 bit version required
Data schemeschema-freeyesschema-freeyes
Typing infopredefined data types such as float or datenoyesyes infointeger and binaryyes
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.yesnono
Secondary indexesyes infoAll columns are indexed automaticallyyesyes infowith tagsyes
SQL infoSupport of SQLnoyesSQL-like query languageyes infobut no triggers and foreign keys
APIs and other access methodsRESTful HTTP APIADO.NET
JDBC
ODBC
HTTP APICluster Management API infoas HTTP Rest and CLI
HTTP API
JDBC
MongoDB API
ODBC
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
.Net
C#
Java
JavaScript (Node.js)
PHP
Python
Ruby
.Net
C
C#
C++
Go
Java
JavaScript (Node.js)
PHP
Python
R
Bash
C
C#
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresnoTransact SQLnoyes
Triggersnoyesnono
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationSharding infoconsistent hashingSharding infohash partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes, with always 3 replicas availableSource-replica replication with selectable replication factorSource-replica replication infostores two copies of each physical data partition on two separate nodes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonowith Hadoop integrationno infocan define user-defined aggregate functions for map-reduce-style calculations
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes, multi-version concurrency control (MVCC)
Durability infoSupport for making data persistentyesyesyes infoby using LevelDByes infoAll updates are persistent, including those to disk-based columnstores and memory-based row stores. Transaction commits are supported via write-ahead log.
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infoTransient modeyes
User concepts infoAccess controlAccess rights for users and roles can be defined via the AWS Identity and Access Management (IAM)fine grained access rights according to SQL-standardCryptographically strong user authentication and audit trailFine grained access control via users, groups and roles
More information provided by the system vendor
Amazon SimpleDBMicrosoft Azure SQL Database infoformerly SQL AzureQuasardbSingleStore infoformer name was MemSQL
Specific characteristicsSingleStore offers a fully-managed , distributed, highly-scalable SQL database designed...
» more
Competitive advantagesSingleStore’s competitive advantages include: Easy and Simplified Architecture with...
» more
Typical application scenariosDriving Fast Analytics: SingleStore delivers the fastest and most scalable reporting...
» more
Key customersIEX Cloud : Improves Financial Data Distribution Speed 15x with Singlestore DB Comcast,...
» more
Market metricsCustomers in various industries worldwide including US and International Industry...
» more
Licensing and pricing modelsF ree Tier and Enterprise Edition
» 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 SimpleDBMicrosoft Azure SQL Database infoformerly SQL AzureQuasardbSingleStore infoformer name was MemSQL
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

Turbocharge Your Application Development Using WebAssembly With SingleStoreDB
17 October 2022,  Akmal Chaudhri, SingleStore (sponsor) 

Cloud-Based Analytics With SingleStoreDB
9 June 2022,  Akmal Chaudhri, SingleStore (sponsor) 

SingleStore: The Increasing Momentum of Multi-Model Database Systems
14 February 2022,  Akmal Chaudhri, SingleStore (sponsor) 

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

Copilot in Azure SQL Database in Private Preview
27 March 2024, InfoQ.com

Microsoft unveils Copilot for Azure SQL Database
27 March 2024, InfoWorld

Azure SQL Database migration to OCI - resources estimation and migration approach
11 January 2024, blogs.oracle.com

Expand the limits of innovation with Azure data
21 March 2024, microsoft.com

Azure SQL Database outage caused by network infrastructure
18 September 2023, The Register

provided by Google News

Record quasar is most luminous object in the universe
20 February 2024, EarthSky

Quasar Partners with PTC to Empower IoT Customers with High-Performance Data Solutions
11 September 2023, Datanami

QUASAR yacht (Bilgin, 46.8m, 2016)
3 July 2023, Boat International

Gas on the run – ALMA spots the shadow of a molecular outflow from a quasar when the Universe was less than one ...
2 February 2024, waseda.jp

Quasar Selected by National Renewable Energy Laboratory to Help with Energy System De-risking and Optimization
6 June 2023, PR Newswire

provided by Google News

Building a Modern Database: Nikita Shamgunov on Postgres and Beyond
18 April 2024, Madrona Venture Group

SingleStore CEO sees little future for purpose-built vector databases
24 January 2024, VentureBeat

SingleStore Announces Real-time Data Platform to Further Accelerate AI, Analytics and Application Development
24 January 2024, Business Wire

SingleStore adds indexed vector search to Pro Max release for faster AI work – Blocks and Files
29 January 2024, Blocks and Files

SingleStore update adds new tools to fuel GenAI, analytics
24 January 2024, TechTarget

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

Milvus logo

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

Neo4j logo

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

Present your product here