Difference between Amazon Aurora and Amazon Redshift

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.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Small things always make you to think big

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.