Open In App
Related Articles

Difference between Amazon DocumentDB and Amazon Redshift

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
1. Amazon DocumentDB : It is fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. It is currently available in California, Oregon, North Virginia and Ireland regions of AWS. It implements Apache 2.0 open source MongoDB 3.6 API by emulating responses. 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 DocumentDB and Amazon Redshift :
S.NO. Amazon DocumentDB Amazon Redshift
1. It is developed By Amazon in 2019. It is developed By Amazon in 2012.
2. It is fast, scalable, highly available, and fully managed MongoDB-compatible database service. It is large scale data warehouse service for use with business intelligence tools.
3. It supports Atomic single-document operations. It supports ACID property.
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 model is Document 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. It does not support partitioning methods. It supports partitioning methods with Sharding.
8. It supports SQL query language. It supports SQL query language. But it does not fully support SQL-standard.
9. It supports Multi-availability zones for high availability. It supports replication methods.
10. 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.

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