Amazon SimpleDB Developer Guide电子书

Amazon SimpleDB Developer Guide

Table of Contents

Amazon SimpleDB Developer Guide

Credits

Foreword

About the Authors

About the Reviewers

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Getting to Know SimpleDB

Experimenting with SimpleDB

How does SimpleDB work?

Domain

Item

Attributes

Values

How do I interact with SimpleDB?

How is SimpleDB priced?

Free tier

Why should I use SimpleDB?

Make your applications simpler to architect

Build flexibility into your applications

Create high-performance web applications

Take advantage of lower costs

Scale your applications on demand

Architect for the cloud

Summary

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

Exploring SimpleDB with Java

Creating a domain with Java

Listing domains with Java

Manipulating items with Java

Deleting a domain with Java

Basic operations with PHP

Exploring SimpleDB with PHP

Creating a domain with PHP

Listing domains with PHP

Manipulating items with PHP

Deleting a domain with PHP

Basic operations with Python

Introducing boto

Exploring SimpleDB with Python

Creating a domain with Python

Retrieving a domain with Python

Creating items with Python

Summary

3. SimpleDB versus RDBMS

No normalization

No joins

No schemas

Simpler SQL

Only strings

Eventual consistency

Flash: February 24, 2010 — consistent read added

Scalability

Low maintenance

Advantages of the SimpleDB model

Disadvantages of the SimpleDB model

Summary

4. The SimpleDB Data Model

Domains

Domains with Java

Domains with PHP

Domains with Python

Exploring the metadata for a domain and costs

Retrieving domain metadata

Retrieving domain metadata with Java

Retrieving domain metadata with PHP

Retrieving domain metadata with Python

Components of a domain's metadata

SimpleDB domain constraints

Items

Adding attributes to an item with Java

Adding attributes to an item with PHP

Adding attributes to an item with Python

Constraints on SimpleDB items

Attributes

Attributes with Java

Attributes with PHP

Attributes with Python

Constraints on SimpleDB item attributes

Values

Storing multiple values in a single attribute with Java

Storing multiple values in a single attribute with PHP

Storing multiple values in a single attribute with Python

Constraints on values of a SimpleDB item

Consistent Read and Conditional Put / Delete announcement

ConsistentRead = true for getAttributes and Select

Conditional Put / Delete

Summary

5. Data Types

What is lexicographical comparison?

Storing numeric values

Storing numeric values with Java

Storing numeric values with PHP

Storing numeric values with Python

Storing date values

Storing date values with Java

Storing date values with PHP

Storing date values with Python

Storing Boolean values

Storing Boolean values with Java

Storing Boolean values with PHP

Storing Boolean values with Python

XML-restricted characters

Using base64 values with Java

Using base64 values with PHP

Using base64 values with Python

Summary

6. Querying

Sample data

Loading the sample data

Importing the sample data with Java

Importing the sample data with PHP

Importing the sample data with Python

Using Select

Simple select with Java

Simple select with PHP

Simple select with Python

Quoting values in Select expressions

Predicates in Select expressions

Simple predicate query with Java

Simple predicate query with PHP

Simple predicate query with Python

Comparison operators

Queries with Select

Comparison operators

Greater than

LIKE

NOT LIKE

BETWEEN

IN

IS NULL

IS NOT NULL

EVERY()

Combining expressions

INTERSECTION

NOT

OR

Sorting

Counting the results

COUNT()

Queries on multi-valued attributes

Querying for multi-valued attributes

getAttribute

getAttributes in Java

getAttributes in PHP

getAttributes in Python

Summary

7. Storing Data on S3

Amazon S3

Buckets

Objects

Keys

Pricing for S3

Plan of action

Creating an S3 bucket

Creating an S3 bucket with Java

Creating an S3 bucket with PHP

Creating an S3 bucket with Python

Creating additional metadata

Creating additional metadata with Java

Creating additional metadata with PHP

Creating additional metadata with Python

Uploading the songs to S3

Uploading the songs to S3 with Java

Uploading the songs to S3 with PHP

Uploading the songs to S3 with Python

Retrieving the files from S3

Retrieving the files from S3 with Java

Retrieving the files from S3 with PHP

Retrieving the files from S3 with Python

Summary

8. Tuning and Usage Costs

BoxUsage

Computing costs using BoxUsage

Usage reports

BoxUsage — Java

Cost of Select

BoxUsage — PHP

Cost of NextToken

Cost of Select

Cost of creating a domain

Cost of creating items

BoxUsage — Python

Partitioning

Summary

9. Caching

Caching

Memcached

Memcached and security

Installing memcached

Installing memcached client

Memcached client in Java

Memcached client in PHP

Memcached client in Python

Storing and retrieving data from memcached

Storing and retrieving data from memcached in Java

Storing and retrieving data from memcached in PHP

Storing and retrieving data from memcached in Python

Cache_Lite

Logic flow for using caching with SimpleDB

Using memcached with SimpleDB in Java

Using Cache_Lite with SimpleDB in PHP

Using memcached with SimpleDB in Python

Summary

10. Parallel Processing

BatchPutAttributes

BatchPutAttributes in Java

BatchPutAttributes in PHP

BatchPutAttributes in Python

Serialized SimpleDB requests

Parallelizing SimpleDB requests

Parallelizing SimpleDB requests in Java

Parallelizing SimpleDB requests in PHP

Parallelizing SimpleDB requests in Python

Simple threading

Threading with queues

Threading with workerpool

Concurrency and SimpleDB

Summary

Index