1. Alibaba Cloud AnalyticDB for PostgreSQL :
AnalyticDB is an online analytical processing database system on Alibaba cloud. It offers both PostgreSQL and MySQL versions. AnalyticDB for PostgreSQL is an online Massively Parallel Processing (MPP) data warehousing service based on the Greenplum Open Source Database program and is enhanced with some in-depth extensions by Alibaba Cloud.
2. Amazon SimpleDB :
It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud. It is Amazon is a web service for running queries on structured data in real-time. This database is written in Erlang by Amazon.com. It has the following features – high availability and flexibility, with little or no administrative burden.
Difference between Alibaba Cloud AnalyticDB for PostgreSQL and Amazon SimpleDB :
|S.NO.||Alibaba Cloud AnalyticDB for PostgreSQL||Amazon SimpleDB|
|1.||Developed By Alibaba, Pivotal Software Inc., and PostgreSQL Global Development Group in 2016.||Developed By Amazon in 2007.|
|2.||It is an online MPP (Massively Parallel Processing) data warehousing service based on Greenplum.||It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud.|
|3.||Its primary database model is Relational DBMS.||Its primary database model is the Key-value store.|
|4.||The programming language supported are C, Java, PHP, R, and Python.||The programming language supported is .Net, C, C++, Erlang, Java, PHP, Python, Ruby, and Scala.|
|5.||It supports the ACID property.||It does not support the ACID property.|
|6.||It supports Server-side scripting.||It does not support the Server-side scripting|
|7.||It supports partitioning methods.||It does not support partitioning methods.|
|8.||It supports SQL query language.||It does not support the SQL query language.|
|9.||It supports replication methods.||It supports replication methods with multi-availability zones for high availability.|
|10.||It provides the concept of Referential Integrity. Hence, there are Foreign Keys.||It does not provide the concept of Referential Integrity. Hence, no Foreign Keys.|
|11.||It supports the ACID property.||It supports Atomic single-document operations|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.