Transaction vs batch comparison in DynamoDB - Hands-On Comparison

Transaction vs Batch Operations in DynamoDB

📖 Scenario: You are managing an online bookstore's inventory using DynamoDB. You need to update multiple book records either as a single atomic transaction or as a batch operation.

🎯 Goal: Build two DynamoDB operations: one using a transaction to update multiple items atomically, and another using a batch write to update multiple items without atomicity.

📋 What You'll Learn

Create a list called books with three book items, each having BookID and Stock attributes.

Create a variable called transaction_items that prepares a transaction update for all books to increase stock by 10.

Create a variable called batch_write_items that prepares a batch write request to update all books to increase stock by 10.

Add a final configuration variable called transaction_params that wraps transaction_items for the DynamoDB transact write API.

💡 Why This Matters

🌍 Real World

Managing inventory updates in an online bookstore where some updates must be atomic and others can be batched for efficiency.

💼 Career

Understanding DynamoDB transactions and batch operations is essential for backend developers working with AWS databases to ensure data consistency and performance.

1

DATA SETUP: Create the initial list of books

Create a list called books with these exact dictionaries: {'BookID': 'B001', 'Stock': 5}, {'BookID': 'B002', 'Stock': 3}, and {'BookID': 'B003', 'Stock': 8}.

DynamoDB

# Create the list called books with three book dictionaries
# Your code here

Need a hint?

Use a Python list with three dictionaries exactly as shown.

2

CONFIGURATION: Prepare transaction update items

Create a variable called transaction_items that is a list of dictionaries. Each dictionary should have a Update key with Key using BookID from each book, UpdateExpression to add 10 to Stock, and TableName set to 'BooksTable'.

DynamoDB

books = [
    {'BookID': 'B001', 'Stock': 5},
    {'BookID': 'B002', 'Stock': 3},
    {'BookID': 'B003', 'Stock': 8}
]
# Create transaction_items list with update dictionaries
# Your code here

Need a hint?

Use a list comprehension to create update dictionaries for each book.

3

CORE LOGIC: Prepare batch write update items

Create a variable called batch_write_items that is a list of dictionaries. Each dictionary should have a PutRequest key with Item containing BookID and Stock increased by 10 from each book.

DynamoDB

books = [
    {'BookID': 'B001', 'Stock': 5},
    {'BookID': 'B002', 'Stock': 3},
    {'BookID': 'B003', 'Stock': 8}
]

transaction_items = [
    {
        'Update': {
            'TableName': 'BooksTable',
            'Key': {'BookID': book['BookID']},
            'UpdateExpression': 'SET Stock = Stock + :inc',
            'ExpressionAttributeValues': {':inc': 10}
        }
    } for book in books
]

# Create batch_write_items list with PutRequest dictionaries
# Your code here

Need a hint?

Use a list comprehension to create PutRequest dictionaries for each book with updated stock.

4

COMPLETION: Wrap transaction items in parameters

Create a variable called transaction_params that is a dictionary with key TransactItems set to the transaction_items list.

DynamoDB

books = [
    {'BookID': 'B001', 'Stock': 5},
    {'BookID': 'B002', 'Stock': 3},
    {'BookID': 'B003', 'Stock': 8}
]

transaction_items = [
    {
        'Update': {
            'TableName': 'BooksTable',
            'Key': {'BookID': book['BookID']},
            'UpdateExpression': 'SET Stock = Stock + :inc',
            'ExpressionAttributeValues': {':inc': 10}
        }
    } for book in books
]

batch_write_items = [
    {
        'PutRequest': {
            'Item': {
                'BookID': book['BookID'],
                'Stock': book['Stock'] + 10
            }
        }
    } for book in books
]

# Create transaction_params dictionary with TransactItems key
# Your code here

Need a hint?

Wrap the transaction_items list inside a dictionary with key 'TransactItems'.