Difference between Amazon DynamoDB and Amazon Redshift

1. Amazon DynamoDB :
Amazon DynamoDB is a fully-managed database and supports both document and key-value data models. Features are as follows – fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is hosted, scalable database service by Amazon with data stored in Amazon cloud.

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

S.No. Amazon DynamoDB Amazon Redshift
1. It was developed by Amazon in 2012. It was developed by Amazon in 2012.
2. It is hosted, scalable database 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 SQL query language. It supports SQL query language. But it does not fully support an SQL-standard.
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 models are Document store and Key-value store. 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. Eventual Consistency and Immediate Consistency are used to ensure consistency in distributed system. Immediate Consistency is used to ensure consistency in distributed system.
8. It does not offers API for user-defined Map/Reduce methods. But maybe implemented via Amazon Elastic MapReduce. It does not offer API for user-defined Map/Reduce methods.
9. It supports secondary indexes. It supports restricted secondary indexes.

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.