Difference between Amazon DynamoDB and Amazon SimpleDB
1. 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 a hosted, scalable database service by Amazon with the data stored in the Amazon cloud.
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 DynamoDB and Amazon SimpleDB :
S.NO. | Amazon DynamoDB | Amazon SimpleDB |
---|---|---|
1. | Developed By Amazon in 2012. | Developed By Amazon in 2007. |
2. | It is a hosted, scalable database service by Amazon with the data stored in the Amazon cloud. | 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. | It supports predefined data types such as float or date | It does not support predefined data types such as float or date |
5. | Its Primary database model is Document store and Key-value store. | Its primary database model is the Key-value store. |
6. | It does not offers an API for user-defined Map/Reduce methods. But maybe implemented via Amazon Elastic MapReduce (Amazon EMR). | It does not offer an API for user-defined Map/Reduce methods. |
7. | It supports sharding as a partitioning method. | It does not support partitioning methods. |
8. | It supports secondary indexes. | It also supports secondary indexes and all columns are indexed automatically. |
9. | The programming languages supported are .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, and Ruby. | The programming languages supported are .Net, C, Erlang, C++, Java, PHP, Python, Scala, and Ruby. |