DB-EnginesInfluxDB download bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > AllegroGraph vs. Microsoft Azure Cosmos DB vs. Microsoft Azure Synapse Analytics

System Properties Comparison AllegroGraph vs. Microsoft Azure Cosmos DB vs. Microsoft Azure Synapse Analytics

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAllegroGraph  Xexclude from comparisonMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDB  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparison
DescriptionHigh performance, persistent RDF store with additional support for Graph DBMSGlobally distributed, horizontally scalable, multi-model database serviceElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelDocument store infowith version 6.5
Graph DBMS
RDF store
Document store
Graph DBMS
Key-value store
Wide column store
Relational DBMS
Secondary database modelsSpatial DBMSSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.33
Rank#148  Overall
#25  Document stores
#13  Graph DBMS
#7  RDF stores
Score34.71
Rank#25  Overall
#3  Document stores
#2  Graph DBMS
#3  Key-value stores
#3  Wide column stores
Score13.29
Rank#41  Overall
#25  Relational DBMS
Websiteallegrograph.comazure.microsoft.com/­services/­cosmos-dbazure.microsoft.com/­services/­synapse-analytics
Technical documentationfranz.com/­agraph/­support/­documentation/­current/­agraph-introduction.htmldocs.microsoft.com/­azure/­cosmos-dbdocs.microsoft.com/­azure/­synapse-analytics
DeveloperFranz Inc.MicrosoftMicrosoft
Initial release200420142016
Current release7.0.0, April 2020
License infoCommercial or Open Sourcecommercial infoLimited community edition freecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenoyesyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++
Server operating systemsLinux
OS X
Windows
hostedhosted
Data schemeyes infoRDF schemasschema-freeyes
Typing infopredefined data types such as float or dateyesyes infoJSON typesyes
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.no infobulk load of XML files possibleno
Secondary indexesyesyes infoAll properties auto-indexed by defaultyes
SQL infoSupport of SQLSPARQL is used as query languageSQL-like query languageyes
APIs and other access methodsRESTful HTTP API
SPARQL
DocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
ADO.NET
JDBC
ODBC
Supported programming languagesC#
Clojure
Java
Lisp
Perl
Python
Ruby
Scala
.Net
C#
Java
JavaScript
JavaScript (Node.js)
MongoDB client drivers written for various programming languages
Python
C#
Java
PHP
Server-side scripts infoStored proceduresyes infoJavaScript or Common LispJavaScriptTransact SQL
TriggersyesJavaScriptno
Partitioning methods infoMethods for storing different data on different nodeswith FederationSharding infoImplicit feature of the cloud serviceSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
yes infoImplicit feature of the cloud serviceyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnowith Hadoop integration infoIntegration with Hadoop/HDInsight on Azure*no
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on configurationBounded Staleness
Consistent Prefix
Eventual Consistency
Immediate Consistency infoConsistency level configurable on request level
Session Consistency
Immediate Consistency
Foreign keys infoReferential integritynonono infodocs.microsoft.com/­en-us/­azure/­synapse-analytics/­sql-data-warehouse/­sql-data-warehouse-table-constraints
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDMulti-item ACID transactions with snapshot isolation within a partitionACID
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 controlUsers with fine-grained authorization concept, user roles and pluggable authenticationAccess rights can be defined down to the item levelyes
More information provided by the system vendor
AllegroGraphMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Specific characteristicsKnowledge Graph Platform Leader FedShard - Designed for Entity-Event Knowledge Graph...
» more
Competitive advantagesAllegroGraph is uniquely suited to support adhoc queries through SPARQL, Prolog and...
» more
News

Gartner Case Study: Entity-Event Knowledge Graph for Powering AI Solutions (Montefiore)
15 March 2021

Understanding What Matters With Text Analytics and NLP
9 March 2021

KMWorld 100 Companies that Matter Most – Franz Inc.
9 March 2021

Maximizing Your Data Fabric’s ROI via Entity Data Modeling
24 February 2021

Data-Centric Architecture Forum – DCAF 2021
1 February 2021

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
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
AllegroGraphMicrosoft Azure Cosmos DB infoformer name was Azure DocumentDBMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Recent citations in the news

Franz Announces Allegro NFS Server 7.0 for Windows
16 February 2021, Business Wire

Franz Releases AllegroGraph 7.1
12 February 2021, Database Trends and Applications

Franz Inc. Named a 2021 KMWorld 100 Company that Matters in Knowledge Management
22 March 2021, Business Wire

Using speech technology to make real-time decisions at KMWorld Connect 2020
17 November 2020, KMWorld Magazine

Franz's AllegroGraph 7 Gains Broad Recognition in 2020 as a Leading Knowledge Graph Solution
9 December 2020, Business Wire

provided by Google News

Blowing your mind with F# | Azure Cosmos DB Conf - Microsoft
20 April 2021, Channel 9

Document Databases Software Market Research 2021 Observational studies with leading manufacturers| MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase, MarkLogic – The Courier
16 May 2021, The Courier

NoSQL Databases Software Market Size and Growth 2021-2027 | Top Companies – MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase, MarkLogic, RethinkDB, CouchDB – KSU | The Sentinel Newspaper
11 May 2021, KSU | The Sentinel Newspaper

Azure Cosmos DB Conf - Microsoft
21 April 2021, Channel 9

Can We Trust the Cloud Not to Fail?
11 May 2021, InfoQ.com

provided by Google News

Microsoft Azure Purview: A Quick Introduction
5 May 2021, CMSWire

Microsoft updates tools to help customers manage Azure cloud costs • DEVCLASS
28 April 2021, DevClass

Microsoft Azure trailing behind Amazon AWS with 19% cloud market share in Q1 2021 - MSPoweruser
3 May 2021, MSPoweruser

A closer look at IBM AutoSQL
12 May 2021, ZDNet

Informatica Announces New Cloud Data Integration Free Service for Customers to Accelerate Cloud Modernization on Microsoft Azure
19 April 2021, AiThority

provided by Google News

Job opportunities

Sales Director, Partner Success
TigerGraph, California

Sales Director, Channel Sales
TigerGraph, California

Systems Engineer
General Dynamics Information Technology, Cherry Hill, NJ

Senior Sales Engineer
TigerGraph, San Francisco, CA

Modeling and Simulation Computer Engineer
The GBS Group, Philadelphia, PA

Software Engineer, Azure Cosmos DB
Microsoft, Atlanta, GA

Azure Architect Certified
Coquina Systems, Richmond, VA

MS Azure Sr. Developer or Architect
Wintrio, Austin, TX

SQL Developer- Moultrie Mobile
EBSCO Industries Inc, Birmingham, AL

Data Engineer
GoPuff, Remote

Data Analyst
Four Winds Interactive, Remote

Power BI Developer
24/7 Business Empire Corp, Remote

Developer - Jenkins / Azure / Software release experience
JM Talent Inc., Richmond, VA

Azure Data Engineer
Azure Data Development, Remote

Synapse DBA
Luxoft, Remote

jobs by Indeed




Share this page

Featured Products

Couchbase logo

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

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..

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.

Vertica logo

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

Present your product here