Difference between Amazon CloudSearch and Amazon Redshift

1. Amazon CloudSearch :
It is a scalable cloud-based search service that forms part of Amazon Web Services. It is hosted search engine service by Amazon with data stored in Amazon cloud. This Database supports 34 languages and its features are as follows highlighting, autocomplete, and geospatial search.

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 Amazon CloudSearch and Amazon Redshift :

S.No.	Amazon CloudSearch	Amazon Redshift
1.	It is developed By Amazon in 2012.	It is developed By Amazon in 2012.
2.	It is hosted search engine service by Amazon with data stored in Amazon cloud.	It is large scale data warehouse service for use with business intelligence tools.
3.	It does not support ACID property.	It supports ACID property.
4.	It does not provide concept of Referential Integrity. Hence, no Foreign Keys.	It provides concept of Referential Integrity. Hence, there are Foreign Keys.
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 supports automatic partitioning methods.	It supports partitioning methods with Sharding.
8.	It does not support SQL query language.	It supports SQL query language. But it does not fully support SQL-standard.
9.	It supports replication methods that are managed transparently by AWS.	It supports replication methods.
10.	It supports secondary indexes.	It supports restricted secondary indexes.