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

DBMS > Microsoft Azure Synapse Analytics vs. Prometheus vs. Riak KV

System Properties Comparison Microsoft Azure Synapse Analytics vs. Prometheus vs. Riak KV

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonPrometheus  Xexclude from comparisonRiak KV  Xexclude from comparison
DescriptionElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerOpen-source TimeSeries DBMS and monitoring systemDistributed, fault tolerant key-value store
Primary database modelRelational DBMSTime Series DBMSKey-value store infowith links between data sets and object tags for the creation of secondary indexes
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score21.33
Rank#36  Overall
#22  Relational DBMS
Score6.32
Rank#67  Overall
#3  Time Series DBMS
Score6.52
Rank#65  Overall
#9  Key-value stores
Websiteazure.microsoft.com/­services/­synapse-analyticsprometheus.ioriak.com/­products/­riak-kv
Technical documentationdocs.microsoft.com/­azure/­synapse-analyticsprometheus.io/­docs
DeveloperMicrosoftBasho Technologies
Initial release201620152009
Current release2.1.0, April 2015
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0Open Source infoApache version 2, commercial enterprise edition
Cloud-based only infoOnly available as a cloud serviceyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++GoErlang
Server operating systemshostedLinux
Windows
Linux
OS X
Data schemeyesyesschema-free
Typing infopredefined data types such as float or dateyesNumeric data onlyno
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.nono infoImport of XML data possibleno
Secondary indexesyesnorestricted
SQL infoSupport of SQLyesnono
APIs and other access methodsADO.NET
JDBC
ODBC
RESTful HTTP/JSON APIHTTP API
Native Erlang Interface
Supported programming languagesC#
Java
PHP
.Net
C++
Go
Haskell
Java
JavaScript (Node.js)
Python
Ruby
C infounofficial client library
C#
C++ infounofficial client library
Clojure infounofficial client library
Dart infounofficial client library
Erlang
Go infounofficial client library
Groovy infounofficial client library
Haskell infounofficial client library
Java
JavaScript infounofficial client library
Lisp infounofficial client library
Perl infounofficial client library
PHP
Python
Ruby
Scala infounofficial client library
Smalltalk infounofficial client library
Server-side scripts infoStored proceduresTransact SQLnoJavaScript and Erlang
Triggersnonoyes infopre-commit hooks and post-commit hooks
Partitioning methods infoMethods for storing different data on different nodesSharding, horizontal partitioningShardingSharding infono "single point of failure"
Replication methods infoMethods for redundantly storing data on multiple nodesyesyes infoby Federationselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneEventual Consistency
Foreign keys infoReferential integrityno infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsnono infolinks between data sets can be stored
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnono
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.no
User concepts infoAccess controlyesnono

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
Microsoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehousePrometheusRiak KV
Recent citations in the news

SynLapse: Orca Security Publishes Details for Critical Azure Synapse Vulnerability
25 June 2022, InfoQ.com

Microsoft takes months to fix critical Azure Synapse bug
15 June 2022, TechTarget

Striim Joins Forces with Microsoft to Speed Cloud and Digital Transformation
28 June 2022, Yahoo Finance

Wiz launches open database to track cloud vulnerabilities
28 June 2022, TechTarget

Matillion Announces Matillion ETL for Databricks Partner Connect and public preview of Matillion Data Loader for Databricks
28 June 2022, PR Newswire

provided by Google News

Future Prospects of Time Series Databases Software Market by 2029 | InfluxDB, Axibase Time Series Database, Trendalyze – Designer Women
28 June 2022, Designer Women

Consider Grafana vs. Prometheus for your time-series tools
18 October 2021, TechTarget

Prometheus vs Zabbix: Network monitoring tools comparison
15 April 2022, TechRepublic

Grafana Labs Announces Release of Grafana 9.0 Featuring New Visualizations and Alerting Improvements, and Expands Its Open Source Offerings with On-call Management
14 June 2022, GlobeNewswire

5 Key Kubernetes Metrics to Keep an Eye on with Prometheus
1 April 2022, TechGenix

provided by Google News

Is Riak A Good NoSQL Database Option?
1 July 2019, Analytics India Magazine

Riak NoSQL Database: Use Cases and Best Practices
23 December 2011, InfoQ.com

Basho, Maker of Riak NoSQL Database, Raises $25M
13 January 2015, Data Center Knowledge

Riak TS for time series analysis at scale
29 September 2016, Opensource.com

How to Set Up Your Own NoSQL Database - MUO
22 November 2021, MakeUseOf

provided by Google News

Job opportunities

Azure Administrator / Data Engineer
Agama Solutions, Las Vegas, NV

Energy / V2X Software Data Engineer - Azure Synapse/Snowflake - V2G
General Motors, Warren, MI

Azure Architect
Intone Networks, Remote

Energy / V2X Software Data Engineer - Azure Synapse/Snowflake - V2G
General Motors, Roswell, GA

Data Engineer - Azure
Intone Networks, Remote

Application Support Engineer - Remote
Esolvit Inc.,, Remote

Software Engineer - Instana Infrastructure Metrics
IBM, Cambridge, MA

Remote DevOps Engineer
Circonus, Malvern, PA

Software Engineer, Insights
Digital Ocean Jobs, Denver, CO

Remote Technical Business Analyst
Circonus, Malvern, PA

Software Developer
MOZ Group, Seattle, WA

Software Developer
MOZ Group, Remote

Cloud Support Engineer I - Databases
Amazon Web Services, Inc., Dallas, TX

JPC - 434 - Backend Engineer
Promantis Inc, New York, NY

Senior MySQL Database Administrator
Scientific Games, Georgia

jobs by Indeed



Share this page

Featured Products

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

Neo4j logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

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.

Present your product here