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.|