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

DBMS > Alibaba Cloud AnalyticDB for PostgreSQL vs. Apache Drill vs. HugeGraph vs. IBM Db2

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. Apache Drill vs. HugeGraph vs. IBM Db2

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDB  Xexclude from comparisonApache Drill  Xexclude from comparisonHugeGraph  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparison
DescriptionAn online MPP (Massively Parallel Processing) data warehousing service based on GreenplumSchema-free SQL Query Engine for Hadoop, NoSQL and Cloud StorageA fast-speed and highly-scalable Graph DBMSCommon in IBM host environments, 2 different versions for host and Windows/Linux
Primary database modelRelational DBMSDocument store
Relational DBMS
Graph DBMSRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDB
Secondary database modelsDocument store
RDF store infoin Db2 LUW (Linux, Unix, Windows)
Spatial DBMS infowith Db2 Spatial Extender
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.76
Rank#220  Overall
#102  Relational DBMS
Score2.02
Rank#124  Overall
#22  Document stores
#59  Relational DBMS
Score0.17
Rank#335  Overall
#31  Graph DBMS
Score125.90
Rank#9  Overall
#6  Relational DBMS
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqldrill.apache.orggithub.com/­hugegraph
hugegraph.apache.org
www.ibm.com/­products/­db2
Technical documentationwww.alibabacloud.com/­help/­en/­analyticdb-for-postgresql/­latest/­product-introduction-overviewdrill.apache.org/­docshugegraph.apache.org/­docswww.ibm.com/­docs/­en/­db2
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupApache Software FoundationBaiduIBM
Initial release2016201220181983 infohost version
Current release1.20.3, January 20230.912.1, October 2016
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2Open Source infoApache Version 2.0commercial infofree version is available
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 languageJavaC and C++
Server operating systemshostedLinux
OS X
Windows
Linux
macOS
Unix
AIX
HP-UX
Linux
Solaris
Windows
z/OS
Data schemeyesschema-freeyesyes
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.yesnono
Secondary indexesyesnoyes infoalso supports composite index and range indexyes
SQL infoSupport of SQLyesSQL SELECT statement is SQL:2003 compliantnoyes
APIs and other access methodsJDBC
ODBC
JDBC
ODBC
RESTful HTTP API
Java API
RESTful HTTP API
TinkerPop Gremlin
ADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
Supported programming languagesC
Java
Perl
Python
R
C++Groovy
Java
Python
C
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresyesuser defined functionsasynchronous Gremlin script jobsyes
Triggersyesnonoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceShardingyes infodepending on used storage backend, e.g. Cassandra and HBaseSharding infoonly with Windows/Unix/Linux Version
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceyes infodepending on used storage backend, e.g. Cassandra and HBaseyes infowith separate tools (MQ, InfoSphere)
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesvia hugegraph-sparkno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneEventual Consistency
Foreign keys infoReferential integrityyesnoyes infoedges in graphyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
Durability infoSupport for making data persistentyesDepending on the underlying data sourceyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noDepending on the underlying data sourceyes
User concepts infoAccess controlfine grained access rights according to SQL-standardDepending on the underlying data sourceUsers, roles and permissionsfine grained access rights according to SQL-standard

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
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBApache DrillHugeGraphIBM Db2 infoformerly named DB2 or IBM Database 2
Recent citations in the news

Alibaba Cloud upgrades AnalyticDB with vector database engine
25 July 2023, CloudTech News

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

Accidental ‘write’ Permissions In Alibaba PostgreSQL Let Attackers Access Sensitive Data
22 April 2023, GBHackers

Two critical vulnerabilities spotted in Alibaba Cloud's PostgreSQL databases
21 April 2023, TEISS

How Data Analytics Capabilities of Alibaba Group Evolve Its Ecosystem to the Cloud
20 February 2021, DataDrivenInvestor

provided by Google News

Apache Drill vs. Apache Spark — Which SQL query engine is better for you?
23 September 2019, Towards Data Science

Apache Drill case study: A tutorial on processing CSV files
9 June 2016, TheServerSide.com

Apache Drill Poised to Crack Tough Data Challenges
19 May 2015, Datanami

Apache Drill Eliminates ETL, Data Transformation for MapR Database
11 April 2016, The New Stack

Drill Mines Diverse Data Sets, Google Style
20 May 2015, The Next Platform

provided by Google News

POC exploit code published for critical Apache HugeGraph bug
7 June 2024, The Register

Critical Apache HugeGraph Flaw Let Attackers Execute Remote Code
23 April 2024, GBHackers

PoC Exploit Released for High Severity Apache HugeGraph RCE flaw
7 June 2024, CybersecurityNews

AI, Lockbit, Veeam, Club Penguin, Kali, Commando Cat, HugeGraph, Aaran Leyland… – SWN #391
7 June 2024, SC Media

Microsoft's Recall criticized for security shortcomings. Cyberespionage in Ukraine.
10 June 2024, The CyberWire

provided by Google News

Infotel Returns to IDUG North America 2024 in Charlotte to Showcase Latest Db2 Solutions and Feature Presentation ...
13 June 2024, PR Web

Use AWS DMS to migrate data from IBM Db2 DPF to an AWS target | Amazon Web Services
28 May 2024, AWS Blog

IBM Collaborates with AWS to Launch a New Cloud Database Offering, Enabling Customers to Optimize Data ...
27 November 2023, IBM Newsroom

IBM's vintage Db2 database jumps on AWS's cloud bandwagon
29 November 2023, The Register

Precisely Supports Amazon RDS for Db2 Service with Real-Time Data Integration Capabilities
3 April 2024, precisely.com

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.

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

Milvus logo

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

Present your product here