DB-EnginesExtremeDB Active Replication featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft Azure Synapse Analytics vs. Oracle NoSQL vs. Sadas Engine vs. SiriDB

System Properties Comparison Microsoft Azure Synapse Analytics vs. Oracle NoSQL vs. Sadas Engine vs. SiriDB

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 comparisonOracle NoSQL  Xexclude from comparisonSadas Engine  Xexclude from comparisonSiriDB  Xexclude from comparison
DescriptionElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodesSADAS Engine is a columnar DBMS specifically designed for high performance in Data warehouse environmentsOpen Source Time Series DBMS
Primary database modelRelational DBMSDocument store
Key-value store
Relational DBMS
Relational DBMSTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score10.35
Rank#42  Overall
#27  Relational DBMS
Score4.52
Rank#80  Overall
#13  Document stores
#13  Key-value stores
#44  Relational DBMS
Score0.00
Rank#334  Overall
#139  Relational DBMS
Score0.04
Rank#316  Overall
#28  Time Series DBMS
Websiteazure.microsoft.com/­services/­synapse-analyticswww.oracle.com/­database/­technologies/­related/­nosql.htmlwww.sadasengine.comsiridb.net
Technical documentationdocs.microsoft.com/­azure/­synapse-analyticsdocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.htmlwww.sadasengine.com/­index.php/­downloads/­documentation-columnar-dbdocs.siridb.net
DeveloperMicrosoftOracleSADAS s.r.l.Transceptor Technology
Initial release2016201120062017
Current release20.3, December 20208.0
License infoCommercial or Open SourcecommercialOpen Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)commercial infofree trial version availableOpen Source infoMIT License
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.
Implementation languageC++JavaC++C
Server operating systemshostedLinux
Solaris SPARC/x86
AIX
Linux
Windows
Linux
Data schemeyesSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.yesyes
Typing infopredefined data types such as float or dateyesoptionalyesyes infoNumeric data
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.nononono
Secondary indexesyesyesyesyes
SQL infoSupport of SQLyesSQL-like DML and DDL statementsyesno
APIs and other access methodsADO.NET
JDBC
ODBC
RESTful HTTP APIJDBC
ODBC
Proprietary protocol
HTTP API
Supported programming languagesC#
Java
PHP
C
C#
Go
Java
JavaScript (Node.js)
Python
.Net
C
C#
C++
Groovy
Java
PHP
Python
C
C++
Go
Python
Server-side scripts infoStored proceduresTransact SQLnonono
Triggersnononono
Partitioning methods infoMethods for storing different data on different nodesSharding, horizontal partitioningShardinghorizontal partitioningSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyesElectable source-replica replication per shard. Support distributed global deployment with Multi-region table featurenoneyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnowith Hadoop integrationnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency infodepending on configuration
Immediate Consistency
Foreign keys infoReferential integrityno infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraintsnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDconfigurable infoACID within a storage node (=shard)no
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infooff heap cacheyes infomanaged by 'Learn by Usage'yes
User concepts infoAccess controlyesAccess rights for users and rolesAccess rights for users, groups and roles according to SQL-standardsimple rights management via user accounts

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 WarehouseOracle NoSQLSadas EngineSiriDB
Recent citations in the news

Profisee Includes Microsoft Azure Native Integration to its Platform
25 February 2021, Database Trends and Applications

Next Pathway Announces New Capabilities to Crawler360 and SHIFT to Accelerate Migration From Hadoop to the Cloud
25 February 2021, PRNewswire

ThoughtSpot and Microsoft Partner to Unleash the Value of Cloud Data with Search and AI-driven Analytics
11 February 2021, Business Wire

AIS: Helping legacy federal systems move to the cloud
15 February 2021, Federal News Network

Cloud Data Warehouse Performance Testing – Gigaom
9 February 2021, Gigaom

provided by Google News

NoSQL Databases Market 2020: Key Players with Product Particulars, Applications, Market Size & Forecast till 2027 : Accumulo, Aerospike, Amazon SimpleDB, Azure Table, Cassandra, BigTable, Couchbase Server, CouchDB, Dynamo DB, Elasticsearch, Flink, HBase, HPCC Systems, Hypertable, MongoDB, NeDB, Oracle NoSQL, Riak, Redis
21 January 2021, NeighborWebSJ

Charles Pack Examines the Benefits of Oracle NoSQL for the Oracle RDBMS DBA
10 May 2016, Database Trends and Applications

First look: Oracle NoSQL Database
16 November 2011, InfoWorld

Oracle Defies Self With 'NoSQL' Database
3 October 2011, Wired News

Oracle Announces 5 Key Enhancements to NoSQL Database
25 May 2016, Database Trends and Applications

provided by Google News

Transceptor Technology Open Sources the Time Series Database SiriDB
1 February 2017, PR Newswire

provided by Google News

Job opportunities

Azure Synapse SQL DBA
Luxoft, Remote

Synapse DBA
Luxoft, Remote

IT Consultant I
Kaiser Permanente, Pleasanton, CA

Database Administrator (Fully Remote)
Life Time, Chanhassen, MN

Azure BI
Intone Networks, Remote

Database Architect, Oracle/NoSQL
Williams Sonoma, San Jose, CA

IT Subject Matter Expert (Secret Cleared)
ECS Federal LLC, Fairfax, VA

Software Engineering
JPMorgan Chase Bank, N.A., Tampa, FL

PwC Digital - QA Tester
PRICE WATERHOUSE COOPERS, Washington, DC

Engineer II
Anthem, Norfolk, VA

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Present your product here