DB-EnginesEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Axibase vs. DataFS vs. IBM Db2 warehouse vs. InterSystems IRIS vs. Microsoft Azure Synapse Analytics

System Properties Comparison Axibase vs. DataFS vs. IBM Db2 warehouse vs. InterSystems IRIS vs. Microsoft Azure Synapse Analytics

Editorial information provided by DB-Engines
NameAxibase  Xexclude from comparisonDataFS  Xexclude from comparisonIBM Db2 warehouse infoformerly named IBM dashDB  Xexclude from comparisonInterSystems IRIS  Xexclude from comparisonMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse  Xexclude from comparison
DescriptionScalable TimeSeries DBMS based on HBase with integrated rule engine and visualizationAll data is stored inside objects which are linked by so-called link attributes. Objects consist of classes which can be extended and de-extended at runtime. Graphs can be defined with a struct.Cloud-based data warehousing serviceA containerised multi-model DBMS, interoperability and analytics data platform with wide capabilities for vertical and horizontal scalabilityElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelTime Series DBMSObject oriented DBMSRelational DBMSDocument store
Key-value store
Object oriented DBMS
Relational DBMS
Relational DBMS
Secondary database modelsGraph DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.20
Rank#306  Overall
#25  Time Series DBMS
Score0.01
Rank#376  Overall
#18  Object oriented DBMS
Score1.26
Rank#161  Overall
#73  Relational DBMS
Score2.89
Rank#94  Overall
#17  Document stores
#16  Key-value stores
#1  Object oriented DBMS
#49  Relational DBMS
Score18.72
Rank#31  Overall
#19  Relational DBMS
Websiteaxibase.com/­docs/­atsd/­financenewdatabase.comwww.ibm.com/­products/­db2/­warehousewww.intersystems.com/­products/­intersystems-irisazure.microsoft.com/­services/­synapse-analytics
Technical documentationdev.mobiland.com/­Overview.xspdocs.intersystems.com/­irislatest/­csp/­docbook/­DocBook.UI.Page.clsdocs.microsoft.com/­azure/­synapse-analytics
DeveloperAxibase CorporationMobiland AGIBMInterSystemsMicrosoft
Initial release20132018201420182016
Current release155851.1.263, October 20222023.3, June 2023
License infoCommercial or Open Sourcecommercial infoCommunity Edition (single node) is free, Enterprise Edition (distributed) is paidcommercialcommercialcommercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyesnoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaC++
Server operating systemsLinuxWindowshostedAIX
Linux
macOS
Ubuntu
Windows
hosted
Data schemeyesClasses, Structs, and Lists are written in proprietary DataTypeDefinitionLanguage (.dtdl) and Objects consisting of those are written in proprietary DataAccessDefinitionLanguage (.dadl)yesdepending on used data modelyes
Typing infopredefined data types such as float or dateyes infoshort, integer, long, float, double, decimal, stringyesyesyesyes
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.nonono infoImport/export of XML data possibleyesno
Secondary indexesnonoyesyesyes
SQL infoSupport of SQLSQL-like query languagenoyesyesyes
APIs and other access methodsJDBC
Proprietary protocol (Network API)
RESTful HTTP API
.NET Client API
Proprietary client DLL
WinRT client
.NET Client API
JDBC
ODBC
OLE DB
JDBC
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
Supported programming languagesGo
Java
PHP
Python
R
Ruby
.Net
C
C#
C++
VB.Net
Java
JavaScript (Node.js)
Perl
PHP
Python
R
Ruby
.Net
C++
Java
JavaScript (Node.js)
Python
C#
Java
PHP
Server-side scripts infoStored proceduresyesPL/SQL, SQL PLyesTransact SQL
Triggersyesno, except callback-events from server when changes happenedyesyesno
Partitioning methods infoMethods for storing different data on different nodesShardingProprietary Sharding systemShardingShardingSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationyesSource-replica replicationyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyesyesno 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 datanoACIDACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesyes
User concepts infoAccess controlWindows-Profilefine grained access rights according to SQL-standardyesyes
More information provided by the system vendor
AxibaseDataFSIBM Db2 warehouse infoformerly named IBM dashDBInterSystems IRISMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Specific characteristicsInterSystems IRIS is a complete cloud-first data platform which includes a multi-model...
» 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
AxibaseDataFSIBM Db2 warehouse infoformerly named IBM dashDBInterSystems IRISMicrosoft Azure Synapse Analytics infopreviously named Azure SQL Data Warehouse
Recent citations in the news

The Ultimate ATV Test: Suzuki’s King Quad 750 AXI Rugged Package vs. Alaska’s Hunting Season
14 October 2020, Outdoor Life

provided by Google News

Tackling AI’s data challenges with IBM databases on AWS
14 March 2024, IBM

Data Mining in Db2 Warehouse: the basics
23 June 2020, Towards Data Science

Db2 Warehouse delivers 4x faster query performance than previously, while cutting storage costs by 34x
11 July 2023, IBM

Top 7 Cloud Data Warehouse Companies
31 May 2023, Datamation

The 10 Best Cloud Data Warehouse Solutions to Consider in 2024
22 October 2023, Solutions Review

provided by Google News

InterSystems TrakCare and InterSystems IRIS for Health to underpin deployment of fully unified future-ready AI-driven healthcare ecosystem at NEOM
24 July 2024, PR Newswire

Consultmed moving its e-referral software to InterSystems's IRIS for Health and more briefs
5 May 2024, Mobihealth News

NEOM partners with InterSystems to enable AI-driven healthcare experience
25 July 2024, Yahoo Finance

Consultmed to re-platform eReferral software on InterSystems’ IRIS for Health
30 April 2024, pulseit.news

InterSystems collaborates with Imagelink Software to accelerate digital transformation for Malaysian government and businesses with next-generation document management solution
24 April 2024, PR Newswire

provided by Google News

General Available: Azure Synapse Runtime for Apache Spark 3.4 is now GA
8 April 2024, azure.microsoft.com

Azure Synapse Runtime for Apache Spark 3.2 End of Support
22 March 2024, azure.microsoft.com

Enable location analytics with Azure Maps
17 July 2024, azure.microsoft.com

Announcing General Availability of Graph Semantics in Kusto
27 May 2024, azure.microsoft.com

Azure Synapse Analytics: Transforming Data Management
29 August 2024, Simplilearn

provided by Google News



Share this page

Featured Products

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

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

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.

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here