DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Blueflood vs. InterSystems Caché vs. Microsoft Azure Synapse Analytics vs. RDFox

System Properties Comparison Blueflood vs. InterSystems Caché vs. Microsoft Azure Synapse Analytics vs. RDFox

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameBlueflood  Xexclude from comparisonInterSystems Caché  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparisonRDFox  Xexclude from comparison
Caché is a deprecated database engine which is substituted with InterSystems IRIS. It therefore is removed from the DB-Engines Ranking.
DescriptionScalable TimeSeries DBMS based on CassandraA multi-model DBMS and application serverElastic, large scale data warehouse service leveraging the broad eco-system of SQL ServerHigh performance knowledge graph and semantic reasoning engine
Primary database modelTime Series DBMSKey-value store
Object oriented DBMS
Relational DBMS
Relational DBMSGraph DBMS
RDF store
Secondary database modelsDocument storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.13
Rank#346  Overall
#33  Time Series DBMS
Score19.93
Rank#31  Overall
#19  Relational DBMS
Score0.29
Rank#300  Overall
#24  Graph DBMS
#13  RDF stores
Websiteblueflood.iowww.intersystems.com/­products/­cacheazure.microsoft.com/­services/­synapse-analyticswww.oxfordsemantic.tech
Technical documentationgithub.com/­rax-maas/­blueflood/­wikidocs.intersystems.comdocs.microsoft.com/­azure/­synapse-analyticsdocs.oxfordsemantic.tech
DeveloperRackspaceInterSystemsMicrosoftOxford Semantic Technologies
Initial release2013199720162017
Current release2018.1.4, May 20206.0, Septermber 2022
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialcommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++C++
Server operating systemsLinux
OS X
AIX
HP Open VMS
HP-UX
Linux
OS X
Solaris
Windows
hostedLinux
macOS
Windows
Data schemepredefined schemedepending on used data modelyesyes infoRDF schemas
Typing infopredefined data types such as float or dateyesyesyesyes
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 indexesnoyesyes
SQL infoSupport of SQLnoyesyesno
APIs and other access methodsHTTP REST.NET Client API
JDBC
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
RESTful HTTP API
SPARQL 1.1
Supported programming languagesC#
C++
Java
C#
Java
PHP
C
Java
Server-side scripts infoStored proceduresnoyesTransact SQL
Triggersnoyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infobased on CassandranoneSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor infobased on CassandraSource-replica replicationyesreplication via a shared file system
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate ConsistencyImmediate ConsistencyImmediate Consistency in stand-alone mode, Eventual Consistency in replicated setups
Foreign keys infoReferential integritynoyesno 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 datanoACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
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.noyesyes
User concepts infoAccess controlnoAccess rights for users, groups and rolesyesRoles, resources, and access types

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
BluefloodInterSystems CachéMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data WarehouseRDFox
Recent citations in the news

Real-Time Performance and Health Monitoring Using Netdata
2 September 2019, CNX Software

provided by Google News

Cognizant Deploys a Comprehensive Hospital Performance Management Solution at Hunterdon Healthcare
21 February 2012, Cognizant news

AWS, GCP, Oracle, Azure, SAP Lead Cloud DBMS Market: Gartner
12 February 2022, CRN

Epic On EHR Interoperability: Not A '1-Time Project'
10 April 2015, InformationWeek

Associative Data Modeling Demystified – Part1
9 July 2016, Data Science Central

Announcing IBM Spectrum Sentinel: Building a Cyber Resilient Future
24 June 2022, ibm.com

provided by Google News

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA | Azure updates
8 April 2024, Microsoft

Azure Synapse Runtime for Apache Spark 3.2 End of Support | Azure updates
22 March 2024, Microsoft

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

Use semantic reasoning to infer new facts from your RDF graph by integrating RDFox with Amazon Neptune | Amazon ...
20 February 2023, AWS Blog

The intuitions behind Knowledge Graphs and Reasoning | by Peter Crocker
5 May 2020, Towards Data Science

Eight interesting open-source graph databases
3 January 2023, INDIAai

Financial Crime Discovery using Amazon EKS and Graph Databases | Amazon Web Services
1 February 2022, AWS Blog

Top 9 Open Source Graph Databases – AIM
7 November 2022, Analytics India Magazine

provided by Google News



Share this page

Featured Products

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

Neo4j logo

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

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here