1. Amazon Aurora :
It is a fully managed relational database engine from Amazon Web Services that is compatible with PostgreSQL and MySQL. It is up to five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. The features of Aurora are distributed, fault-tolerant and self-healing storage systems.
2. Amazon DocumentDB :
It is a commercial licensed database that has the following features as it is a 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 the Apache 2.0 open-source MongoDB 3.6 API by emulating the responses.
Difference between Amazon Aurora and Amazon DocumentDB :
|S.NO.||Amazon Aurora||Amazon DocumentDB|
|1.||It was developed by Amazon in 2015.||It was developed by Amazon in 2019.|
|2.||It is a MySQL and PostgreSQL compatible cloud service by Amazon.||It is a fast, scalable, highly available, and fully managed MongoDB-compatible database service.|
|3.||The license of Amazon Aurora is commercial.||The license of Amazon DocumentDB is also commercial.|
|4.||In Amazon Aurora there are hosted server operating systems.||In Amazon DocumentDB there are hosted server operating systems.|
|5.||Its primary database model is Relational DBMS.||Its primary database model is Document Store.|
|6.||It supports the Server-side scripting.||It does not support the Server-side scripting.|
|7.||The partitioning can be done with horizontal partitioning.||It does not support the partitioning methods.|
|8.||It supports SQL query language.||It does not support SQL query language.|
|9.||It supports only one replication method : Master-Slave Replication.||It supports multi-availability zones for high availability.|
|10.||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. But may be implemented via Amazon Elastic MapReduce.|
|11.||It does not offer any API for user-defined Map/Reduce methods.||It also does not offer any API for user-defined Map/Reduce methods. But may be implemented via Amazon Elastic MapReduce.|
|12.||It supports ACID properties.||It supports atomic single-document operations.|
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.