Free Sample
+ Collection

Amazon SimpleDB Developer Guide

Prabhakar Chaganti, Rich Helms

Scale your application's database on the cloud using Amazon SimpleDB with this book and eBook
RRP $23.99
RRP $39.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781847197344
Paperback252 pages

About This Book


  • Offload the time, effort, and capital associated with architecting and operating a simple, flexible, and scalable web database
  • A complete guide that covers everything from installation to advanced features aimed at optimizing your application
  • Examine SimpleDB and the relational database model and review the Simple DB data model
  • Packed with examples in Java, PHP, and Python and screenshots to illustrate key concepts allowing you to focus application development

Who This Book Is For

If you are a developer wanting to build scalable web-based database applications using SimpleDB, then this book is for you. You do not need to know anything about SimpleDB to read and learn from this book, and no basic knowledge is strictly necessary. This guide will help you to start from scratch and build advanced applications.

Table of Contents

Chapter 1: Getting to Know SimpleDB
Experimenting with SimpleDB
How does SimpleDB work?
How do I interact with SimpleDB?
How is SimpleDB priced?
Why should I use SimpleDB?
Chapter 2: Getting Started with SimpleDB
Creating an AWS account
Enabling SimpleDB service for AWS account
Query API and authentication
SimpleDB libraries
SDBtool — Firefox plugin
Sample outline — performing basic operations
Basic operations with Java
Basic operations with PHP
Basic operations with Python
Chapter 3: SimpleDB versus RDBMS
No normalization
No joins
No schemas
Simpler SQL
Only strings
Eventual consistency
Low maintenance
Advantages of the SimpleDB model
Disadvantages of the SimpleDB model
Chapter 4: The SimpleDB Data Model
Exploring the metadata for a domain and costs
Consistent Read and Conditional Put / Delete announcement
Chapter 5: Data Types
What is lexicographical comparison?
Storing numeric values
Storing date values
Storing Boolean values
XML-restricted characters
Chapter 6: Querying
Sample data
Comparison operators
Queries with Select
Combining expressions
Counting the results
Queries on multi-valued attributes
Querying for multi-valued attributes
Chapter 7: Storing Data on S3
Amazon S3
Pricing for S3
Plan of action
Chapter 8: Tuning and Usage Costs
Chapter 9: Caching
Memcached and security
Installing memcached
Installing memcached client
Storing and retrieving data from memcached
Logic flow for using caching with SimpleDB
Chapter 10: Parallel Processing
Serialized SimpleDB requests
Parallelizing SimpleDB requests
Concurrency and SimpleDB

What You Will Learn


  • Explore several SimpleDB operations with the easy-to-use Boto library on Java, PHP, and Python consoles
  • Encode and decode various data types into string data using Lexicographical comparison with precise instructions
  • Query, sort, and count data using SELECT syntax
  • Store large binary objects in Amazon S3 while using SimpleDB as the metadata store
  • Tune SimpleDB queries using the box usage value
  • Avoid excessive SimpleDB requests by using a cache
  • Optimize your application's performance using parallel operations

In Detail

SimpleDB is a highly scalable, simple-to-use, and inexpensive database in the cloud from Amazon Web Services. But in order to use SimpleDB, you really have to change your mindset. This isn't a traditional relational database; in fact it's not relational at all. For developers who have experience working with relational databases, this may lead to misconceptions as to how SimpleDB works.

This practical book aims to address your preconceptions on how SimpleDB will work for you. You will be quickly led through the differences between relational databases and SimpleDB, and the implications of using SimpleDB. Throughout this book, there is an emphasis on demonstrating key concepts with practical examples for Java, PHP, and Python developers.
You will be introduced to this massively scalable schema-less key-value data store: what it is, how it works, and why it is such a game-changer. You will then explore the basic functionality offered by SimpleDB including querying, code samples, and a lot more. This book will help you deploy services outside the Amazon cloud and access them from any web host.

You will see how SimpleDB gives you the freedom to focus on application development. As you work through this book you will be able to optimize the performance of your applications using parallel operations, caching with memcache, asynchronous operations, and more.


Read More