DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Alibaba Cloud AnalyticDB for PostgreSQL vs. Blueflood vs. InterSystems IRIS vs. Microsoft SQL Server vs. PostGIS

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. Blueflood vs. InterSystems IRIS vs. Microsoft SQL Server vs. PostGIS

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDB  Xexclude from comparisonBlueflood  Xexclude from comparisonInterSystems IRIS  Xexclude from comparisonMicrosoft SQL Server  Xexclude from comparisonPostGIS  Xexclude from comparison
DescriptionAn online MPP (Massively Parallel Processing) data warehousing service based on GreenplumScalable TimeSeries DBMS based on CassandraA containerised multi-model DBMS, interoperability and analytics data platform with wide capabilities for vertical and horizontal scalabilityMicrosofts flagship relational DBMSSpatial extension of PostgreSQL
Primary database modelRelational DBMSTime Series DBMSDocument store
Key-value store
Object oriented DBMS
Relational DBMS
Relational DBMSSpatial DBMS
Secondary database modelsDocument store
Graph DBMS
Spatial DBMS
Relational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.72
Rank#217  Overall
#101  Relational DBMS
Score0.06
Rank#354  Overall
#35  Time Series DBMS
Score2.76
Rank#96  Overall
#17  Document stores
#16  Key-value stores
#1  Object oriented DBMS
#49  Relational DBMS
Score799.81
Rank#3  Overall
#3  Relational DBMS
Score19.62
Rank#29  Overall
#1  Spatial DBMS
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqlblueflood.iowww.intersystems.com/­products/­intersystems-iriswww.microsoft.com/­en-us/­sql-serverpostgis.net
Technical documentationwww.alibabacloud.com/­help/­en/­analyticdb-for-postgresql/­latest/­product-introduction-overviewgithub.com/­rax-maas/­blueflood/­wikidocs.intersystems.com/­irislatest/­csp/­docbook/­DocBook.UI.Page.clslearn.microsoft.com/­en-US/­sql/­sql-serverpostgis.net/­documentation
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupRackspaceInterSystemsMicrosoft
Initial release20162013201819892005
Current release2023.3, June 2023SQL Server 2022, November 20223.4.2, February 2024
License infoCommercial or Open SourcecommercialOpen Source infoApache 2.0commercialcommercial inforestricted free version is availableOpen Source infoGPL v2.0
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
SQLServer Flex @ STACKIT offers a managed version of SQL Server with adjustable CPU, RAM, storage amount and speed, in enterprise grade to perfectly match all application requirements. All services are 100% GDPR-compliant.
Implementation languageJavaC++C
Server operating systemshostedLinux
OS X
AIX
Linux
macOS
Ubuntu
Windows
Linux
Windows
Data schemeyespredefined schemedepending on used data modelyesyes
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.yesnoyesyesyes
Secondary indexesyesnoyesyesyes
SQL infoSupport of SQLyesnoyesyesyes
APIs and other access methodsJDBC
ODBC
HTTP RESTJDBC
ODBC
RESTful HTTP API
ADO.NET
JDBC
ODBC
OLE DB
Tabular Data Stream (TDS)
Supported programming languagesC
Java
Perl
Python
R
.Net
C++
Java
JavaScript (Node.js)
Python
C#
C++
Delphi
Go
Java
JavaScript (Node.js)
PHP
Python
R
Ruby
Visual Basic
Server-side scripts infoStored proceduresyesnoyesTransact SQL, .NET languages, R, Python and (with SQL Server 2019) Javauser defined functions
Triggersyesnoyesyesyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceSharding infobased on CassandraShardingtables can be distributed across several files (horizontal partitioning); sharding through federationyes infobased on PostgreSQL
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceselectable replication factor infobased on CassandraSource-replica replicationyes, but depending on the SQL-Server Editionyes infobased on PostgreSQL
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency infobased on Cassandra
Immediate Consistency infobased on Cassandra
Immediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACIDACID
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.nonoyesyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardnoyesfine grained access rights according to SQL-standardyes infobased on PostgreSQL
More information provided by the system vendor
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBBluefloodInterSystems IRISMicrosoft SQL ServerPostGIS
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
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBBluefloodInterSystems IRISMicrosoft SQL ServerPostGIS
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Spatial database management systems
6 April 2021, Matthias Gelbmann

show all

Recent citations in the news

BrokenSesame: Accidental ‘write’ permissions to private registry allowed potential RCE to Alibaba Cloud Database Services
19 April 2023, Wiz

Two Critical Flaws Found in Alibaba Cloud's PostgreSQL Databases
20 April 2023, The Hacker News

Alibaba Cloud Launches ModelScope Platform and New Solutions to Lower the Threshold for Materializing Business Innovation
3 November 2022, CEO Today

Alibaba Cloud Unveils Cloud Laptop that Powers Remote Working
3 November 2022, Alizila

Alibaba Cloud reports strong first-quarter sales
20 August 2020, SiliconANGLE News

provided by Google News

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

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

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

Epic to use InterSystems as data foundation for latest EHR release
13 October 2020, Healthcare IT News

provided by Google News

Save money on Microsoft SQL Server licensing with Microsoft Azure Arc
6 November 2024, microsoft.com

Microsoft Previews Copilot AI in SQL Server Management Studio
7 November 2024, Visual Studio Magazine

Embed textual data in Amazon RDS for SQL Server using Amazon Bedrock
30 October 2024, AWS Blog

Azure Arc and SQL Server: bridge the gap between cloud and on-premise
4 November 2024, Inetum

How to check your SQL Server version
21 August 2024, ITPro

provided by Google News



Share this page

Featured Products

Neo4j logo

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

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

RaimaDB logo

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

Present your product here