DynamoDB Applied Design Patterns电子书

DynamoDB Applied Design Patterns

Table of Contents

DynamoDB Applied Design Patterns

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

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. Data Modeling with DynamoDB

Data model

Efficient use of primary keys

Basics of indexes

Default or primary indexes

Secondary indexes

DynamoDB data types

Summary

2. DynamoDB Interfaces

The management console

Managing the DynamoDB table

Managing DynamoDB table items

The Eclipse plugin

The command-line interface

Summary

3. Tools and Libraries of AWS DynamoDB

Creating your first SDK project

Java SDK operations

DynamoDB Local

Summary

4. Working with Secondary Indexes

Secondary indexes

Projection

Local secondary index

Global secondary index

Item sharding

Ideal item writing

Best practices with secondary indexes

Distributing the load by choosing the correct key

Making use of the sparse index

Using the global secondary index for quicker retrieval

Creating a read replica

Using indexes sparingly

Choosing projections carefully

Optimizing frequent queries to avoid fetches

Watching for expanding item collections

Summary

5. Query and Scan Operations in DynamoDB

Querying tables

Consistency

Exclusive start key

Scanning tables

Parallel scanning

Summary

6. Working with the DynamoDB API

Data format

HTTP requests

Request header

Request body

Response header

Error handling

Client-side error with status code 400 - retry not needed

AccessDeniedException

ConditionalCheckFailedException

IncompleteSignatureException

LimitExceededException

MissingAuthenticationTokenException

ResourceInUseException

ResourceNotFoundException

ValidationException

Client-side error with status code 400 - retry possible

ProvisionedThroughputExceededException

ItemCollectionSizeLimitExceededException

ThrottlingException

UnrecognizedClientException

Client-side error with status code 413

Server-side error with status code 500

InternalFailure and InternalServerError

ServiceUnavailableException

Error retry and exponential back off

Operations in DynamoDB

CreateTable

PutItem

UpdateItem

GetItem

Query

Scan

DeleteItem

DescribeTable

UpdateTable

DeleteTable

ListTables

BatchGetItem

BatchWriteItem

Summary

7. Distributed Locking with DynamoDB

Distributed locking

Solutions available to solve distributed writes

Java high-level API

Optimistic locking

Importance of distributed locking

Summary

8. DynamoDB with Redshift, Data Pipeline, and MapReduce

Loading data from DynamoDB into Redshift

Importing and exporting data between DynamoDB and S3

Creating Data Pipeline

Exporting, importing, querying, and joining tables using AWS MapReduce

Exporting data from DynamoDB to S3

Exporting the DynamoDB table to HDFS

Importing data to DynamoDB

Querying data in DynamoDB

Joining two DynamoDB tables

Summary

9. DynamoDB – Best Practices

DynamoDB use cases

Schema-less-ISH

Batch applications

Stating attributes using the :select option

Synchronization

Real-time problem statements and their solutions

Problem statement – 1

Solution

Problem statement – 2

Solution

Problem statement – 3

Solution

Problem Statement – 4

Solution

Problem statement – 5

Solution

AWS DynamoDB on mobile

Storing data in the table

Android

iOS

Updating a record

Android

iOS

Deleting a record

Android

iOS

Uniform workload

Time series tables

When to use and when not to use DynamoDB

Summary

A. Comparing DynamoDB

DynamoDB versus MongoDB

DynamoDB versus Cassandra

DynamoDB versus S3

DynamoDB versus Redis

Index