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. Kinetica vs. Microsoft Azure Data Explorer vs. Microsoft Azure Synapse Analytics vs. SAP Advantage Database Server

System Properties Comparison Amazon SimpleDB vs. Kinetica vs. Microsoft Azure Data Explorer vs. Microsoft Azure Synapse Analytics vs. SAP Advantage Database Server

Editorial information provided by DB-Engines
NameAmazon SimpleDB  Xexclude from comparisonKinetica  Xexclude from comparisonMicrosoft Azure Data Explorer  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonSAP Advantage Database Server infoformer name: Sybase ADS  Xexclude from comparison
SAP Advantage Database Server seems to be discontinued. Therefore it is excluded from the DB-Engines Ranking.
DescriptionHosted simple database service by Amazon, with the data stored in the Amazon Cloud. infoThere is an unrelated product called SimpleDB developed by Edward ScioreFully vectorized database across both GPUs and CPUsFully managed big data interactive analytics platformElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerLow-cost RDBMS with access to ISAM and FoxPro data structures
Primary database modelKey-value storeRelational DBMSRelational DBMS infocolumn orientedRelational DBMSRelational DBMS
Secondary database modelsSpatial DBMS
Time Series DBMS
Document store infoIf a column is of type dynamic docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-types/­dynamic then it's possible to add arbitrary JSON documents in this cell
Event Store infothis is the general usage pattern at Microsoft. Billing, Logs, Telemetry events are stored in ADX and the state of an individual entity is defined by the arg_max(timestamps)
Spatial DBMS
Search engine infosupport for complex search expressions docs.microsoft.com/­en-us/­azure/­kusto/­query/­parseoperator FTS, Geospatial docs.microsoft.com/­en-us/­azure/­kusto/­query/­geo-point-to-geohash-function distributed search -> ADX acts as a distributed search engine
Time Series DBMS infosee docs.microsoft.com/­en-us/­azure/­data-explorer/­time-series-analysis
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.88
Rank#133  Overall
#23  Key-value stores
Score0.66
Rank#234  Overall
#107  Relational DBMS
Score3.80
Rank#81  Overall
#43  Relational DBMS
Score19.93
Rank#31  Overall
#19  Relational DBMS
Websiteaws.amazon.com/­simpledbwww.kinetica.comazure.microsoft.com/­services/­data-explorerazure.microsoft.com/­services/­synapse-analyticswww.sap.com/products/advantage-database-server.html
Technical documentationdocs.aws.amazon.com/­simpledbdocs.kinetica.comdocs.microsoft.com/­en-us/­azure/­data-explorerdocs.microsoft.com/­azure/­synapse-analytics
DeveloperAmazonKineticaMicrosoftMicrosoftSybase, SAP
Initial release20072012201920161993
Current release7.1, August 2021cloud service with continuous releases
License infoCommercial or Open Sourcecommercialcommercialcommercialcommercialcommercial
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 languageC, C++C++
Server operating systemshostedLinuxhostedhostedLinux
Windows
Data schemeschema-freeyesFixed schema with schema-less datatypes (dynamic)yesyes
Typing infopredefined data types such as float or datenoyesyes infobool, datetime, dynamic, guid, int, long, real, string, timespan, double: docs.microsoft.com/­en-us/­azure/­kusto/­query/­scalar-data-typesyesyes
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.noyesnono
Secondary indexesyes infoAll columns are indexed automaticallyyesall fields are automatically indexedyesyes
SQL infoSupport of SQLnoSQL-like DML and DDL statementsKusto Query Language (KQL), SQL subsetyesyes
APIs and other access methodsRESTful HTTP APIJDBC
ODBC
RESTful HTTP API
Microsoft SQL Server communication protocol (MS-TDS)
RESTful HTTP API
ADO.NET
JDBC
ODBC
.NET Client API
ADO.NET
JDBC
ODBC
OLE DB
Supported programming languages.Net
C
C++
Erlang
Java
PHP
Python
Ruby
Scala
C++
Java
JavaScript (Node.js)
Python
.Net
Go
Java
JavaScript (Node.js)
PowerShell
Python
R
C#
Java
PHP
Delphi
Perl
PHP
Server-side scripts infoStored proceduresnouser defined functionsYes, possible languages: KQL, Python, RTransact SQLyes
Triggersnoyes infotriggers when inserted values for one or more columns fall within a specified rangeyes infosee docs.microsoft.com/­en-us/­azure/­kusto/­management/­updatepolicynoyes
Partitioning methods infoMethods for storing different data on different nodesnone infoSharding must be implemented in the applicationShardingSharding infoImplicit feature of the cloud serviceSharding, horizontal partitioningnone
Replication methods infoMethods for redundantly storing data on multiple nodesyesSource-replica replicationyes infoImplicit feature of the cloud service. Replication either local, cross-facility or geo-redundant.yesMulti-source replication infoCONFLICT Trigger to resolve replication conflicts
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoSpark connector (open source): github.com/­Azure/­azure-kusto-sparknono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency infocan be specified for read operations
Immediate Consistency or Eventual Consistency depending on configurationEventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesnono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infoConcurrent data updates can be detected by the applicationnonoACIDACID
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.yes infoGPU vRAM or System RAMnono infocaching of (temporary) tables can be configured
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 on table levelAzure Active Directory Authenticationyesfine 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 SimpleDBKineticaMicrosoft Azure Data ExplorerMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseSAP Advantage Database Server infoformer name: Sybase ADS
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

Kinetica Delivers Real-Time Vector Similarity Search
21 March 2024, insideBIGDATA

Kinetica Elevates RAG with Fast Access to Real-Time Data
26 March 2024, Datanami

Kinetica ramps up RAG for generative AI, empowering enterprises with real-time operational data
18 March 2024, SiliconANGLE News

Kinetica Launches Generative AI Solution for Real-Time Inferencing Powered by NVIDIA AI Enterprise
18 March 2024, GlobeNewswire

Transforming spatiotemporal data analysis with GPUs and generative AI
30 October 2023, InfoWorld

provided by Google News

We’re retiring Azure Time Series Insights on 7 July 2024 – transition to Azure Data Explorer | Azure updates
31 May 2024, Microsoft

Update records in a Kusto Database (public preview) | Azure updates
20 February 2024, Microsoft

Public Preview: Azure Data Explorer connector for Apache Flink | Azure updates
8 January 2024, Microsoft

Announcing General Availability to migrate Virtual Network injected Azure Data Explorer Cluster to Private Endpoints ...
5 February 2024, Microsoft

New Features for graph-match KQL Operator: Enhanced Pattern Matching and Cycle Control | Azure updates
24 January 2024, Microsoft

provided by Google News

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA | Azure updates
8 April 2024, azure.microsoft.com

Azure Synapse Runtime for Apache Spark 3.2 End of Support | Azure updates
22 March 2024, azure.microsoft.com

Azure Synapse Analytics: Everything you need to know about Microsoft's cloud analytics platform
24 September 2023, DataScientest

Migrate Microsoft Azure Synapse Analytics to Amazon Redshift using AWS SCT | Amazon Web Services
18 October 2023, AWS Blog

Azure Synapse vs. Databricks: Data Platform Comparison 2024
26 March 2024, eWeek

provided by Google News

SAP Announces Q3 2023 Results: Asia Pacific and Japan View
19 October 2023, SAP News

provided by Google News



Share this page

Featured Products

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.

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