Open In App
Related Articles

Difference between Amazon Aurora and Amazon Redshift

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
1. Amazon Aurora : It is a fully managed relational database engine from Amazon Web Services that are compatible with MySQL and PostgreSQL. It is approx five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. Features of Aurora have distributed fault-tolerant and self-healing storage system. 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 Amazon Aurora and Amazon Redshift :
S.NO. Amazon Aurora Amazon Redshift
1. Developed By Amazon in 2015. Developed By Amazon in 2012.
2. It is MySQL and PostgreSQL compatible cloud service by Amazon. It is large scale data warehouse service for use with business intelligence tools.
3. It supports secondary indexes. It supports restricted secondary indexes.
4. It supports XML Format. It does not support XML Format.
5. Its Primary database model is Relational DBMS. Its primary database model is Relational DBMS.
6. It supports Server-side scripting. It supports user-defined functions for Server-side scripting in python.
7. The partitioning can be done with horizontal partitioning. It supports partitioning methods with Sharding.
8. It supports SQL query language. It does not fully support SQL-standard.
9. It supports only one replication method – Master-slave replication. It also supports replication methods.

Last Updated : 29 Jul, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads