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

DBMS > Alibaba Cloud AnalyticDB for PostgreSQL vs. Alibaba Cloud MaxCompute vs. Firebase Realtime Database vs. IBM Db2

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. Alibaba Cloud MaxCompute vs. Firebase Realtime Database 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 comparisonAlibaba Cloud MaxCompute  Xexclude from comparisonFirebase Realtime Database  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 GreenplumMaxCompute (previously known as ODPS) is a general purpose, fully managed, multi-tenancy data processing platform for large-scale data warehousingCloud-hosted realtime document store. iOS, Android, and JavaScript clients share one Realtime Database instance and automatically receive updates with the newest data.Common in IBM host environments, 2 different versions for host and Windows/Linux
Primary database modelRelational DBMSRelational DBMS infoa graph-processing framework is available with the graphs being stored in tablesDocument storeRelational 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)
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.32
Rank#237  Overall
#111  Relational DBMS
Score0.47
Rank#212  Overall
#101  Relational DBMS
Score12.35
Rank#38  Overall
#6  Document stores
Score165.55
Rank#6  Overall
#5  Relational DBMS
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqlwww.alibabacloud.com/­product/­maxcomputefirebase.google.com/­products/­realtime-databasewww.ibm.com/­analytics/­db2
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­35387.htmwww.alibabacloud.com/­help/­product/­27797.htmfirebase.google.com/­docs/­databasewww.ibm.com/­support/­knowledgecenter/­SSEPGG
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupAlibabaGoogle infoacquired by Google 2014IBM
Initial release2016201620121983 infohost version
Current release12.1, October 2016
License infoCommercial or Open Sourcecommercialcommercialcommercialcommercial infofree version is available
Cloud-based only infoOnly available as a cloud serviceyesyesyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++
Server operating systemshostedhostedhostedAIX
HP-UX
Linux
Solaris
Windows
z/OS
Data schemeyesyesschema-freeyes
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 indexesyesnoyesyes
SQL infoSupport of SQLyesSQL-like query languagenoyes
APIs and other access methodsJDBC
ODBC
Fluentd
Flume
MaxCompute Console
Android
iOS
JavaScript API
RESTful HTTP API
ADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
Supported programming languagesC
Java
Perl
Python
R
JavaJava
JavaScript
Objective-C
C
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
Server-side scripts infoStored proceduresyesuser defined functions infoin Javalimited functionality with using 'rules'yes
TriggersyesnoCallbacks are triggered when data changesyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud serviceSharding infoImplicit feature of the cloud serviceSharding infoonly with Windows/Unix/Linux Version
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceyes infoImplicit feature of the cloud serviceyes infowith separate tools (MQ, InfoSphere)
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyEventual Consistency infoif the client is offline
Immediate Consistency infoif the client is online
Foreign keys infoReferential integrityyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoyesACID
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes
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.nono
User concepts infoAccess controlfine grained access rights according to SQL-standardAccess rights for users and rolesyes, based on authentication and database rulesfine 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
3rd partiesGeneral SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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 HybridDBAlibaba Cloud MaxComputeFirebase Realtime DatabaseIBM Db2 infoformerly named DB2 or IBM Database 2
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

show all

Recent citations in the news

Cloud DBaaS is the future of database management for the Enterprise
7 February 2020, Times of India

Alibaba Cloud offers DBaaS to digitalise India businesses in a cloud native era
23 December 2019, Wire19

Alibaba Cloud DBaaS to digitalise businesses
10 January 2020, DATAQUEST

Tableau expands data 'viz' toolsets & extensions - CW Developer Network
14 November 2019, ComputerWeekly.com

Tableau Global Partner Summit Showcases Innovative Product Integrations to Enable Unprecedented Customer Choice and Flexibility
12 November 2019, Yahoo Finance

provided by Google News

Streaming Data Services Comparison: Alibaba Cloud, AWS, Azure, Google Cloud, IBM Cloud - Latest Digital Transformation Trends | Cloud News
20 January 2020, Wire19

Alibaba Cloud achieves 'record' in big data performance
29 October 2019, DataCenterNews North America

Alibaba Cloud Claims New Global Record in Big Data, Decision Support
30 October 2019, CDOTrends

Alibaba Cloud Achieves World Record in Big Data Performance and Decision Support
21 October 2019, Yahoo Finance

Intel Xeon Scalable Processors Accelerate Big Data Computing in Alibaba Cloud
15 October 2019, AiThority

provided by Google News

5 cloud database comparison tips to guide your data strategy
23 January 2020, TechTarget

Exposed Firebase databases hidden by Google search
2 December 2019, TechTarget

AI workshop held at Ubunifu college
13 February 2020, CIO East Africa

Compare Google Cloud Firestore and Firebase Realtime Database
9 August 2019, TechTarget

Facial recognition lawsuits, regulations, proposals and launches lead biometrics news this week
7 February 2020, Biometric Update

provided by Google News

How do OODBMS and ORDBMS Differ from RDBMS?
10 February 2020, Database Journal

NGS Breaks Scalability Barrier With OLAP Client
10 February 2020, IT Jungle

Google offers IBM AS/400 apps new home in its cloud
20 January 2020, CIO

How IBM Is Turning Db2 into an 'AI Database'
3 June 2019, Datanami

Oracle Cloud update: Literally doubling down
5 February 2020, ZDNet

provided by Google News

Job opportunities

Alibaba Cloud Intelligence Staff Engineer Sunnyvale
Alibaba, Sunnyvale, CA

Alibaba Cloud Intelligence Senior Engineer Sunnyvale
Alibaba, Sunnyvale, CA

PROFESSIONAL XAMARIN DEVELOPER
Edge One Solutions, Remote

Technical Lead
Photon, New York, NY

Data Engineer
Petuum, Sunnyvale, CA

Business Intelligence Analyst
CBS, New York, NY

Data Analyst/Developer
RPX, San Francisco, CA

DB2 LUW Database Administrator
Bank of America, Charlotte, NC

DPS - IT - Database Administrator, DB2
TEXAS DEPARTMENT OF PUBLIC SAFETY, Austin, TX

Database Administrator_Remote
Sawdey Solution Services, Inc., Remote

IMS Sr. Database Administrator Remote/Virtual
Unum, Remote

AWS Database Migration Specialist - DB2
Northbay, Boston, MA

jobs by Indeed




Share this page

Featured Products

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandraâ„¢ from the Cassandra experts.
Learn more.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Couchbase logo

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

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here