Thursday, January 10, 2013

What is Amazon SimpleDB?

Amazon SimpleDB

  • structured data (key/value pairs) in the cloud
  • highly available, scalable non-relational data store
  • eventually consistent reads (consistent read option available)
  • automatic, geo-redundant replication (within same region)
  • maximum of 10GB of storage per domain (for >10GB, you can partition your data across multiple SimpleDB domains)


Example usage:

Consider the situation when you need to store millions of images in the cloud. You can store these images in EBS or S3 and store the image locations in SimpleDB.


Pricing - http://aws.amazon.com/simpledb/pricing/


Based on data storage (per GB-month), data transfer (per GB-month), and machine hours (per month) associated with PUT and GET operations


Anti-Patterns

Prewritten application tied to a relational database - use RDS or EBS

Joins, complex transactions - use RDS or EBS

BLOb - use EBS or S3 and use SimpleDB to keep track of the locations

numeric data - use EBS or RDS

large dataset - use EBS or RDS

1 comment:

  1. Amazon SimpleDB can be useful for those who need a non-relational database for storage of smaller, non-structural data. Amazon SimpleDB has restricted storage size to 10GB per domain. Amazon SimpleDB offers simplicity and flexibility. SimpleDB automatically indexes all data. Amazon SimpleDB pricing is based on your actual box usage. You can store any UTF-8 string data in Amazon SimpleDB.

    SDB Explorer provides an industry-leading and intuitive Graphical User Interface (GUI) to explore Amazon SimpleDB service in a thorough manner, and in a very efficient and user friendly way.

    ReplyDelete