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 > Microsoft Azure Synapse Analytics vs. OpenQM vs. Sqrrl vs. YugabyteDB

System Properties Comparison Microsoft Azure Synapse Analytics vs. OpenQM vs. Sqrrl vs. YugabyteDB

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 comparisonOpenQM infoalso called QM  Xexclude from comparisonSqrrl  Xexclude from comparisonYugabyteDB  Xexclude from comparison
Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.
DescriptionElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerQpenQM is a high-performance, self-tuning, multi-value DBMSAdaptable, secure NoSQL built on Apache AccumuloHigh-performance distributed SQL database for global, internet-scale applications. Wire and feature compatible with PostgreSQL.
Primary database modelRelational DBMSMultivalue DBMSDocument store
Graph DBMS
Key-value store
Wide column store
Relational DBMS
Secondary database modelsDocument store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score21.33
Rank#36  Overall
#22  Relational DBMS
Score0.23
Rank#284  Overall
#10  Multivalue DBMS
Score3.11
Rank#98  Overall
#51  Relational DBMS
Websiteazure.microsoft.com/­services/­synapse-analyticswww.openqm.comsqrrl.comwww.yugabyte.com
Technical documentationdocs.microsoft.com/­azure/­synapse-analyticswww.openqm.com/­support/­documentationdocs.yugabyte.com
github.com/­yugabyte/­yugabyte-db
DeveloperMicrosoftMartin PhillipsAmazon infooriginally Sqrrl Data, Inc.Yugabyte Inc.
Initial release2016199320122017
Current release3.4-122.6, August 2021
License infoCommercial or Open SourcecommercialOpen Source infoGPLv2, extended commercial license availablecommercialOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud serviceyesnonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Yugabyte Cloud is the fully managed database-as-a-service offering of YugabyteDB. Get started quickly, and effortlessly ensure continuous availability and limitless scale of your cloud native applications.
Implementation languageC++JavaC and C++
Server operating systemshostedAIX
FreeBSD
Linux
macOS
Raspberry Pi
Solaris
Windows
LinuxLinux
OS X
Data schemeyesyes infowith some exceptionsschema-freedepending on used data model
Typing infopredefined data types such as float or dateyesyesyes
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.noyesno
Secondary indexesyesyesyesyes
SQL infoSupport of SQLyesnonoyes, PostgreSQL compatible
APIs and other access methodsADO.NET
JDBC
ODBC
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
JDBC
YCQL, an SQL-based flexible-schema API with its roots in Cassandra Query Language
YSQL - a fully relational SQL API that is wire compatible with the SQL language in PostgreSQL
Supported programming languagesC#
Java
PHP
.Net
Basic
C
Java
Objective C
PHP
Python
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
C
C#
C++
Go
Java
JavaScript (Node.js)
Python
Ruby
Server-side scripts infoStored proceduresTransact SQLyesnoyes infosql, plpgsql, C
Triggersnoyesnoyes
Partitioning methods infoMethods for storing different data on different nodesSharding, horizontal partitioningyesSharding infomaking use of HadoopHash and Range Sharding, row-level geo-partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyesyesselectable replication factor infomaking use of HadoopBased on Raft distributed consensus protocol, minimum 3 replicas for continuous availability
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.Strong consistency on writes and tunable consistency on reads
Foreign keys infoReferential integrityno infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDAtomic updates per row, document, or graph entityDistributed ACID with Serializable & Snapshot Isolation. Inspired by Google Spanner architecture.
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes infobased on RocksDB
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.no
User concepts infoAccess controlyesAccess rights can be defined down to the item levelCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)yes
More information provided by the system vendor
Microsoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseOpenQM infoalso called QMSqrrlYugabyteDB
Specific characteristicsYugabyteDB is an open source distributed SQL database for cloud native transactional...
» more
Competitive advantagesPostgreSQL compatible: Get instantly productive with a PostgreSQL compatible RDBMS....
» more
Typical application scenariosSystems of record and engagement for cloud native applications that require resilience,...
» more
Market metrics900,000+ lifetime clusters deployed 5.5K+ GitHub stars 4.3K+ YugabyteDB Community...
» more
Licensing and pricing modelsApache 2.0 license for the database
» 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
Microsoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseOpenQM infoalso called QMSqrrlYugabyteDB
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

Researchers criticize Oracle's vulnerability disclosure process
24 June 2022, TechTarget

A New Microsoft Platform in Town: the Microsoft Intelligent Data Platform
8 June 2022, InfoQ.com

6 'nightmare' cloud security flaws were found in Azure in the last year. Does Microsoft have work to do?
1 June 2022, Protocol

provided by Google News

OpenQM
9 January 2019, International Spectrum Magazine

provided by Google News

Behavior Analytics Market Size Growth Overview by 2028 – Sqrrl Data, Inc., Dtex Systems, E8 Security Inc., HP Enterprise, etc – Indian Defence News
21 June 2022, Indian Defence News

How microfinance startups leverage AI to democratise credit access
24 June 2022, Analytics India Magazine

User And Entity Behavior Analytics Industry Market Size & Revenue Analysis | Bottomline TechnologiesInc, Varonis Systems – Indian Defence News
18 June 2022, Indian Defence News

CASHe acquires Sqrrl, forays into wealthtech space
10 May 2022, YourStory

Peanut Butter Whiskey Market Set for Explosive Growth : Skatterbrain, Hard Truth, Skrewball Whiskey, Ole Smoky Distillery
11 June 2022, Digital Journal

provided by Google News

Yugabyte Announces Fourth Annual Distributed SQL Summit to Accelerate Cloud Native Initiatives in Any Future
23 June 2022, Business Wire

Can Yugabyte Become The Defacto Database For Large-Scale, Cloud Native Applications?
19 May 2022, Forbes

Yugabyte stores up $188M more for its open-source distributed SQL database model, now valued at $1.3B+
28 October 2021, TechCrunch

How to choose a database (hint: boring is good)
16 June 2022, TechRepublic

Yugabyte Delivers Effortless Distributed SQL With Cloud Database-as-a-Service
21 September 2021, Business Wire

provided by Google News

Job opportunities

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

Azure Data Engineer
Agama Solutions, Houston, TX

Data Engineer - Azure
Intone Networks, Remote

Azure Architect
Triune Infomatics Inc, Oakland, CA

Support Engineer - Azure Synapse
Microsoft, Issaquah, WA

Senior Database Engineer
WELLS FARGO BANK, Des Moines, IA

Sr. Data Engineer - Remote
DST Systems, Remote

Senior Database Engineer
U.S. Bank, San Francisco, CA

Software Engineer 2 (Full-stack / Microservices)
U.S. Bank, Blue Ash, OH

Advanced Solutions Architect - E-Commerce Transactional Solutions (REMOTE)
Kroger General Office, Cincinnati, OH

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

Vertica logo

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

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.

Redis logo

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

Present your product here