Difference between Alibaba Cloud MaxCompute and Amazon Redshift
1. Alibaba Cloud MaxCompute :
The MaxCompute which is previously known as ODPS is a general-purpose, fully managed, multi-tenancy data processing platform for large-scale data warehousing. It is used to store and compute batches of structured data. This provides a very large range of data warehouse solutions. It also provides large data analysis and modeling services.
2. Amazon Redshift :
Amazon Redshift is an efficient solution to collect and store all your data and enables you to analyze it. It is a large scale data warehouse service for use with business intelligence tools. Feature of Amazon Redshift – fast, simple, cost-effective data warehousing service. It forms part of larger cloud-computing platform Amazon Web Services.
Difference between Alibaba Cloud MaxCompute and Amazon Redshift :
S.NO. |
Alibaba Cloud MaxCompute |
Amazon Redshift |
1. |
It was developed by Alibaba in 2016. |
It was developed by Amazon in 2012. |
2. |
It is general-purpose, fully managed, multi-tenancy data processing platform for large-scale data warehousing. |
It is large scale data warehouse service for use with business intelligence tools. |
3. |
It supports SQL-like query language. |
It does not fully support SQL-standard. |
4. |
It offers API for user-defined Map/Reduce methods. |
It does not offer API for user-defined Map/Reduce methods. |
5. |
It does not provide concept of Referential Integrity. Hence, no Foreign Keys. |
It provides concept of Referential Integrity. Hence, there are Foreign Keys. |
6. |
It does not support In-memory capabilities. |
It supports In-memory capabilities. |
7. |
It does not support ACID property. |
It supports ACID property. |
8. |
It supports Java programming language. |
It supports all languages supporting JDBC/ODBC. |
9. |
It does not support secondary indexes. |
It supports restricted secondary indexes. |
Last Updated :
30 Jul, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...