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. |
Last Updated :
07 Jul, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...