DBMS > Alibaba Cloud MaxCompute vs. Amazon Redshift vs. Firebase Realtime Database
System Properties Comparison Alibaba Cloud MaxCompute vs. Amazon Redshift vs. Firebase Realtime Database
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Alibaba Cloud MaxCompute Xexclude from comparison||Amazon Redshift Xexclude from comparison||Firebase Realtime Database Xexclude from comparison|
|Primary database model||Relational DBMS a graph-processing framework is available with the graphs being stored in tables||Relational DBMS||Document store|
|Developer||Alibaba||Amazon (based on PostgreSQL)||Google acquired by Google 2014|
|License Commercial or Open Source||commercial||commercial||commercial|
|Cloud-based only Only available as a cloud service||yes||yes||yes|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||hosted||hosted||hosted|
|Typing predefined data types such as float or date||yes||yes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no||no|
|SQL Support of SQL||SQL-like query language||yes does not fully support an SQL-standard||no|
|APIs and other access methods||Fluentd|
RESTful HTTP API
|Supported programming languages||Java||All languages supporting JDBC/ODBC||Java|
|Server-side scripts Stored procedures||user defined functions in Java||user defined functions in Python||limited functionality with using 'rules'|
|Triggers||no||no||Callbacks are triggered when data changes|
|Partitioning methods Methods for storing different data on different nodes||Sharding Implicit feature of the cloud service||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||yes Implicit feature of the cloud service||yes|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency||Eventual Consistency if the client is offline|
Immediate Consistency if the client is online
|Foreign keys Referential integrity||no||yes informational only, not enforced by the system||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||yes|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes|
|User concepts Access control||Access rights for users and roles||fine grained access rights according to SQL-standard||yes, based on authentication and database rules|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||CData: Connect to Big Data & NoSQL through standard Drivers.|
Dremio is like magic for Redshift accelerating your analytical queries up to 1,000x.
DBHawk: a web-based Amazon Redshift Workbench and Cloud database tool.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Alibaba Cloud MaxCompute||Amazon Redshift||Firebase Realtime Database|
|DB-Engines blog posts|
The popularity of cloud-based DBMSs has increased tenfold in four years Increased popularity for consuming DBMS services out of the cloud
Increased popularity for consuming DBMS services out of the cloud
|Recent citations in the news|
Alibaba Cloud Releases New Products to Int'l...
Alibaba Cloud Unveils New Products to Empower Data Intelligence for Enterprises and Internet Companies
Alibaba Cloud To Launch Big Data Service in...
Alibaba Cloud unveils data intelligence products
Alibaba Cloud: Rising Star in the Cloud Market
provided by Google News
Amazon's AWS Lake Formation Ups the Ante in Data Lake Space
Amazon announces general availability of AWS Lake Formation
Amazon Web Services Announces Availability of AWS Lake Formation
Amazon Releases AWS Lake Formation to General Availability
provided by Google News
Compare Google Cloud Firestore and Firebase Realtime Database
How unsecured Firebase databases put critical data at risk
We Built Collaborative Editing for Our Newsroom's CMS. Here's how.
Realtime vs Cloud Firestore: Which Firebase Database to go?
How was Google Firebase security bypassed?
provided by Google News
Business Intelligence Analyst
Business Data Scientist
Business Intelligence (BI) Engineer
Data Scientist I (Pricing & Experimentation), Finance Research
Web Application Programmer
Data Engineering Intern
DATA SCIENCE MANAGER
Share this page