Difference between Amazon Redshift and Amazon SimpleDB

1. 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 the larger cloud-computing platform Amazon Web Services.

2. Amazon SimpleDB :
It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud. It is Amazon is a web service for running queries on structured data in real-time. This database is written in Erlang by Amazon.com. It has the following features – high availability and flexibility, with little or no administrative burden.



Difference between Amazon Redshift and Amazon SimpleDB :

S.NO. Amazon Redshift Amazon SimpleDB
1. Developed By Amazon in 2012. Developed By Amazon in 2007.
2. It is a large scale data warehouse service for use with business intelligence tools. It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud.
3. It supports the ACID property. It does not support the ACID property.
4. It provides the concept of Referential Integrity. Hence, there are Foreign Keys. It does not provide the concept of Referential Integrity. Hence, no Foreign Keys.
5. Its primary database model is Relational DBMS. Its primary database model is the Key-value store.
6. It supports user-defined functions for Server-side scripting in python. It does not support the Server-side scripting.
7. It supports partitioning methods with Sharding. It does not support partitioning methods.
8. It supports SQL query language. But it does not fully support an SQL-standard. It does not support the SQL query language.
9. It supports the ACID property. It does not support the ACID property.
10. It supports predefined data types such as float or date. It does not supports predefined data types such as float or date.

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

Check out this Author's contributed articles.

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.