Difference between Amazon DocumentDB and Amazon Redshift
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.|
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.