Amazon Simpledb

A webservice for running queries on structured data in real-time.

1. Presented By
Biswajeet Dasmajumdar

2. Amazon SimpleDB is a hosted database as a service that
enables developers to store and query structured data items
via Web services requests.
SimpleDB is a key-value store that runs within the Amazon
Web Services (AWS) cloud.

3. What is Amazon SimpleDB cont...
Amazon SimpleDB
1. Requires no schema
2. Automatically indexes your data
3. API’s for storage and access.
This eliminates the
1. Administrative burden of data modeling
2.Index maintenance
3.Performance tuning

4. Traditional clustered relational database can do the work of
SimpleDB but
1. It requires a DBA to maintain and administer.
2. Brings more complexity
On the other hand Amazon simpleDB
1. Is easy to use
2. Provides real time lookup
3. Provides simple querying without any complexity
RDBMS vs SIMPLE DB

5. BASIC EXAMPLE

6. FEATURES

8. KEY -VALUE STRUCTURE

9. SIMPLE DB - DATA VIEW

10. Facts

12. Simple
Flexible
Scalable
Fast
Reliable
Inexpensive

13. CONS
Data integrity is not guaranteed
Inconsistency
Aggregate operations will require more coding
Complicated reports, and ad hoc queries require a lot more
coding.
Aggregate operations will be much slower.
Complex data schemas are not supported

14. ADVANTAGES
1.Optimized to provide high availability and flexibility, with little
or no administrative burden.
2.It creates and manages multiple geographically distributed
replicas of our data automatically to enable high availability and
data durability.
3.The service charges you only for the resources actually
consumed in storing your data and serving your requests.
4. Change your data model on the fly
5. Data is automatically indexed
6.Designed for use with other Amazon web services

15. Create an account (http://aws.amazon.com/)
click the “Sign up for This Web Service” button on the
Amazon SimpleDB detail page.
Get an Access Key and the Secret Key.
Access from “http://www.s3.amazonaws.com/bucket/key”
Within a few minutes, you will be able to create your
domain and begin storing and querying your data!

20. DATA

21. Range queries

22. Simple queries

23. Multiple attribute queries

24. sort

25. limit

26. Keywords

27. Netflix is the world’s leading Internet television network with
more than 48 million streaming members in more than 40
countries.
 It has successfully shifted its business model from DVDs by
mail to online media .

28. CASE STUDY( contd...)
Traditional relational database technologies were not built to
accommodate large volumes of data, neither from a cost-
effective perspective nor regarding the needs for continuous
availability and flexibility.
In 2010, Netflix began moving its data to Amazon Web Services
(AWS) to offer subscribers more flexibility across devices.

29. CASE STUDY( contd...)
Netflix decided to migrate from Cassandra to DataStax
Enterprise for its enterprise-level security and production.
About 95% of Netflix’s non-program data is stored in DataStax
Enterprise.
Includes customer account information, movie ratings,
bookmarks and logs, and viewing history services.
 

30. Case STUDY( contd...)
Performed immense amounts of customer viewing and log data to
improve subscribers’ searching and streaming experiences.
Multiple geographically dispersed data centers and processing
capacity.
Netflix decided to migrate its applications to Amazon’s AWS
cloud.
Netflix migrated core parts of its database from Oracle
to Amazon’s SimpleDB data store.
 Added customer value rather than nationwide data centers.

31. aws.amazon.com/simpledb/
https://s3.amazonaws.com/
Sdb php api http://thetalecrafter.wordpress.com/
s3 php api
http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/
cloudfront/lib/S3.php?view=auto&revision=1.1
Oreilly Programming Amazon Web Services S3 EC2 SQS
FPS and SimpleDB Mar 2008
http://itsinthecloud.com/2008/04/22/overview-of-amazon-s3/
http://www.ryanpark.org/2008/04/top-10-avoid-the-simpledb-
hype.html

32. END OF SLIDES

33. QUESTIONS ???