Difference between Alibaba Cloud ApsaraDB for PolarDB and Alibaba Cloud Table Store

1. Alibaba Cloud ApsaraDB for PolarDB :
The ApsaraDB for PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. ApsaraDB architecture supported 5000 physical machines in a single cluster. It is designed for business-critical database applications that require fast performance, high concurrency, and automatic scaling.

2. Alibaba Cloud Table Store :
The Alibaba Cloud Table Store is a fully managed Wide Column Store for large quantities of semi-structured data with real-time access. It is a NoSQL database service that uses a variety of data models. Tablestore was developed by Alibaba Cloud and can store a large amount of structured data. It is used for efficient query and data analysing.


Difference between Alibaba Cloud ApsaraDB for PolarDB and Alibaba Cloud Table Store :

S.NO.	Alibaba Cloud ApsaraDB for PolarDB	Alibaba Cloud Table Store
1.	It was developed by Alibaba in August 2013.	It was developed by Alibaba in 2016.
2.	It is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle.	It is a fully managed Wide Column Store for large quantities of semi-structured data with real-time access.
3.	In Alibaba Cloud ApsaraDB for PolarDB there are hosted server operating systems.	In Alibaba Cloud Table Store there are hosted server operating systems.
4.	The license of Alibaba Cloud ApsaraDB for PolarDB is commercial.	The license of Alibaba Cloud Table Store is also commercial.
5.	It supports XML Format.	It does not support XML Format.
6.	It supports the Server-side scripting.	It does not support the Server-side scripting.
7.	There is only one partitioning method – Sharding.	It also support partitioning methods.
8.	It supports SQL query language.	It does not support SQL query language.
9.	It supports replication methods.	It also supports replication methods.
10.	ApsaraDB for PolarDB provides the concept of Referential Integrity. Hence, there are Foreign Keys.	Table Store does not provide the concept of Referential Integrity. Hence, no Foreign Keys.
11.	It supports in-memory capabilities.	It does not support in-memory capabilities.
12.	It does not offer any API for user-defined Map/Reduce methods.	It also does not offer any API for user-defined Map/Reduce methods.
13.	It supports ACID properties.	It supports Atomic single-row operations.
14.	Programming languages supported are Java and Python.	Programming languages supported are Java and Python.