Denormalization for speed in Redis - Mini Project: Build & Apply

Denormalization for Speed in Redis

📖 Scenario: You are building a simple online store database using Redis. To make product information retrieval faster, you want to denormalize data by storing product details and their category names together.

🎯 Goal: Create Redis data structures to store products and categories separately, then denormalize by adding category names directly into product hashes for faster access.

📋 What You'll Learn

Create Redis hashes for categories with exact IDs and names

Create Redis hashes for products with exact IDs and names

Add a configuration variable for the category ID to denormalize

Update the product hash to include the category name for the given category ID

💡 Why This Matters

🌍 Real World

Denormalization in Redis is used in real online stores and apps to speed up reading product data by storing related info together.

💼 Career

Understanding denormalization helps database engineers and backend developers optimize performance in fast data systems.

1

Create category hashes

Create two Redis hashes with keys category:1 and category:2. Set the field name to "Electronics" for category:1 and "Books" for category:2.

Redis

# Create category hashes with names
# Your code here

Need a hint?

Use the HSET command to create hashes with the field name.

2

Create product hashes

Create two Redis hashes with keys product:101 and product:102. Set the field name to "Smartphone" for product:101 and "Novel" for product:102. Also set the field category_id to 1 for product:101 and 2 for product:102.

Redis

HSET category:1 name "Electronics"
HSET category:2 name "Books"
# Create product hashes with name and category_id
# Your code here

Need a hint?

Use HSET with multiple fields to add product name and category ID.

3

Set category ID to denormalize

Create a Redis string key called denormalize_category_id and set its value to 1 to indicate which category ID to denormalize.

Redis

HSET category:1 name "Electronics"
HSET category:2 name "Books"
HSET product:101 name "Smartphone" category_id 1
HSET product:102 name "Novel" category_id 2
# Set denormalize_category_id to 1
# Your code here

Need a hint?

Use the SET command to store the category ID to denormalize.

4

Denormalize category name into product hash

For the product with key product:101, add a new field category_name and set its value to the category name from category:1 (which is "Electronics").

Redis

HSET category:1 name "Electronics"
HSET category:2 name "Books"
HSET product:101 name "Smartphone" category_id 1
HSET product:102 name "Novel" category_id 2
SET denormalize_category_id 1
# Add category_name field to product:101 with value from category:1 name
# Your code here

Need a hint?

Use HSET to add the category_name field to the product hash.