Difference between Amazon Aurora and Amazon DynamoDB
1. Amazon Aurora :
Amazon Aurora is a fully managed relational database engine from Amazon Web Services that are compatible with MySQL and PostgreSQL. It is approx five times faster than standard MySQL databases and three times faster than standard PostgreSQL databases. Features of Aurora have distributed fault-tolerant and self-healing storage system.
2. 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.
Difference between Amazon Aurora and Amazon DynamoDB :
|S.No.||Amazon Aurora||Amazon DynamoDB|
|1.||It was developed by Amazon in 2015.||It was developed by Amazon in 2012.|
|2.||It is MySQL and PostgreSQL compatible cloud service by Amazon.||It is hosted, scalable database service by Amazon with data stored in Amazon cloud.|
|3.||It provides concept of Referential Integrity. Hence, no Foreign Keys.||It does not provide concept of Referential Integrity. Hence, no Foreign Keys.|
|4.||Immediate Consistency is used to ensure consistency in distributed system.||Eventual Consistency and Immediate Consistency are used to ensure consistency in distributed system.|
|5.||Its Primary database model is Relational DBMS.||Its Primary database models are Document store and Key-value store.|
|6.||It supports Server-side scripting.||It does not support Server-side scripting.|
|7.||Partitioning can be done with horizontal partitioning.||It supports sharding as partitioning method.|
|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 replication methods.|
|10.||It does not offers API for user-defined Map/Reduce methods.||It does not offers API for user-defined Map/Reduce methods. But maybe implemented via Amazon Elastic MapReduce.|
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.