Difference between Alibaba Cloud Log Service and Amazon Redshift

1. Alibaba Cloud Log Service :
The Log Service is complete real-time data logging service that has been developed by Alibaba Group. It is complete real-time data logging service that supports collection, consumption, shipping, search, and analysis of logs.

2. Amazon Redshift :
Amazon Redshift is an efficient solution to collect and store all your data and enables you to analyze it. It is 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 Log Service and Amazon Redshift :

S.NO.	Alibaba Cloud Log Service	Amazon Redshift
1.	It was developed By AlibabaCloud Inc. in 2016.	It was developed By Amazon in 2012.
2.	It is complete real-time data logging service that supports collection, consumption, shipping, search, and analysis of logs.	It is large scale data warehouse service for use with business intelligence tools.
3.	It does not provide concept of Referential Integrity. Hence, no Foreign Keys.	It provides concept of Referential Integrity. Hence, there are Foreign Keys.
4.	It supports secondary indexes.	It supports restricted secondary indexes.
5.	Its primary database model is Search engine.	Its primary database model is Relational DBMS.
6.	It does not support Server-side scripting.	It supports user-defined functions for Server-side scripting in python.
7.	It does not support In-memory capabilities.	It supports In-memory capabilities.
8.	It supports SQL query language.	It does not fully support SQL-standard.
9.	It supports 3 replicas.	It supports replication methods.
10.	It offers ES-Hadoop Connector as Map/Reduce methods.	It does not offer API for user-defined Map/Reduce methods.