Transactions vs atomic document writes in MongoDB - Hands-On Comparison

Transactions vs Atomic Document Writes in MongoDB

📖 Scenario: You are managing a small online bookstore database using MongoDB. You want to understand how to safely update book stock counts either by updating a single document atomically or by using transactions when multiple documents need to be updated together.

🎯 Goal: Build a MongoDB script that first sets up a collection with book documents, then configures a threshold for low stock, applies atomic updates to single documents, and finally uses a transaction to update multiple documents safely.

📋 What You'll Learn

Create a collection named books with three book documents having fields _id, title, and stock with exact values.

Create a variable lowStockThreshold set to 5 to identify low stock books.

Write an atomic update to decrease the stock of a single book with _id 1 by 2 units.

Write a transaction that decreases the stock of books with _id 2 and 3 by 1 unit each.

💡 Why This Matters

🌍 Real World

Managing inventory in an online bookstore requires safe updates to stock counts to avoid overselling or inconsistent data.

💼 Career

Understanding atomic updates and transactions in MongoDB is essential for backend developers and database administrators to ensure data integrity in multi-document operations.

1

DATA SETUP: Create the books collection with initial documents

Create a collection called books and insert exactly these three documents: { _id: 1, title: 'Learn MongoDB', stock: 10 }, { _id: 2, title: 'Mastering NoSQL', stock: 8 }, and { _id: 3, title: 'Database Basics', stock: 6 }.

MongoDB

// Insert the three book documents into the books collection
// Your code here

Need a hint?

Use db.books.insertMany() with an array of the three exact book documents.

2

CONFIGURATION: Define the low stock threshold

Create a variable called lowStockThreshold and set it to 5 to mark books with stock less than or equal to this as low stock.

MongoDB

db.books.insertMany([
  { _id: 1, title: 'Learn MongoDB', stock: 10 },
  { _id: 2, title: 'Mastering NoSQL', stock: 8 },
  { _id: 3, title: 'Database Basics', stock: 6 }
])

// Define the low stock threshold
// Your code here

Need a hint?

Use const lowStockThreshold = 5 to create the variable.

3

CORE LOGIC: Atomically update stock of a single book

Write a MongoDB update command to atomically decrease the stock of the book with _id 1 by 2 units using updateOne and the $inc operator.

MongoDB

db.books.insertMany([
  { _id: 1, title: 'Learn MongoDB', stock: 10 },
  { _id: 2, title: 'Mastering NoSQL', stock: 8 },
  { _id: 3, title: 'Database Basics', stock: 6 }
])

const lowStockThreshold = 5

// Atomically decrease stock of book with _id 1 by 2
// Your code here

Need a hint?

Use db.books.updateOne({ _id: 1 }, { $inc: { stock: -2 } }) to atomically decrease stock.

4

COMPLETION: Use a transaction to update multiple books' stock

Write a MongoDB transaction that decreases the stock of books with _id 2 and 3 by 1 unit each. Use session.startTransaction(), two updateOne calls with $inc, and session.commitTransaction().

MongoDB

db.books.insertMany([
  { _id: 1, title: 'Learn MongoDB', stock: 10 },
  { _id: 2, title: 'Mastering NoSQL', stock: 8 },
  { _id: 3, title: 'Database Basics', stock: 6 }
])

const lowStockThreshold = 5

db.books.updateOne({ _id: 1 }, { $inc: { stock: -2 } })

// Start a session and transaction to update stock of books with _id 2 and 3
// Your code here

Need a hint?

Use session.startTransaction(), update both documents with updateOne passing the session option, then session.commitTransaction().