Difference between Amazon Aurora and Amazon SimpleDB
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 SimpleDB :
It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud. It is Amazon is a web service for running queries on structured data in real-time. This database is written in Erlang by Amazon.com. It has the following features – high availability and flexibility, with little or no administrative burden.
Difference between Amazon Aurora and Amazon SimpleDB :
|S.NO.||Amazon Aurora||Amazon SimpleDB|
|1.||Developed By Amazon in 2015.||Developed By Amazon in 2007.|
|2.||It is a MySQL and PostgreSQL compatible cloud service by Amazon.||It is a hosted simple database service by Amazon, with the data stored in the Amazon Cloud.|
|3.||It supports the ACID property.||It does not support the ACID property.|
|4.||Immediate Consistency is used to ensure consistency in a distributed system.||Eventual Consistency and Immediate Consistency is used to ensure consistency in a distributed system.|
|5.||Its Primary database model is Relational DBMS.||Its primary database model is the Key-value store.|
|6.||It supports Server-side scripting.||It does not support the Server-side scripting.|
|7.||The partitioning can be done with horizontal partitioning.||It does not support partitioning methods.|
|8.||It supports SQL query language.||It does not support the SQL query language.|
|9.||It supports only one replication method – Master-slave replication.||It supports replication methods.|
|10.||It provides the concept of Referential Integrity. Hence, no Foreign Keys.||It does not provide the concept of Referential Integrity. Hence, no Foreign Keys.|
|11.||It supports predefined data types such as float or date.||It does not support predefined data types such as float or date.|
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.