Why TTL use cases (sessions, logs, cache) in DynamoDB? - Purpose & Use Cases

The Big Idea

What if your database could clean up old data all by itself, saving you hours of work?

The Scenario

Imagine you run a website that keeps user sessions, logs, and cache data all in one big file or table. Over time, this file grows huge because old sessions and logs never get removed. You have to manually check and delete expired data to keep things tidy.

The Problem

Manually cleaning expired data is slow and boring. It's easy to forget or make mistakes, leaving old data that wastes space and slows down your system. This can cause your website to lag or even crash when the data gets too big.

The Solution

TTL (Time To Live) automatically deletes data after a set time. You just tell the database when each item should expire, and it removes it for you. This keeps your data fresh and your system fast without any extra work.

Before vs After

✗ Before

Scan table for expired items
Delete each expired item one by one

✓ After

Set TTL attribute on items
DynamoDB auto-deletes expired items

What It Enables

TTL lets your database clean itself, so you can focus on building features instead of managing old data.

Real Life Example

For example, a shopping website uses TTL to automatically remove user sessions after 30 minutes of inactivity, clear logs older than 7 days, and expire cached product info after 1 hour to keep data fresh.

Key Takeaways

Manual data cleanup is slow and error-prone.

TTL automates removal of expired sessions, logs, and cache.

This keeps your database efficient and your app running smoothly.

Practice

1. What is the main purpose of TTL (Time To Live) in DynamoDB?

easy

A. Automatically delete items after a specified time to save storage

B. Encrypt data for security

C. Backup data to another region

D. Increase read capacity automatically

Solution

1. Step 1: Understand TTL functionality

   TTL marks items with an expiration timestamp to delete them automatically after that time.

2. Step 2: Identify the main benefit

   This automatic deletion helps save storage and keeps data fresh without manual cleanup.

3. Final Answer:

   Automatically delete items after a specified time to save storage -> Option A

4. Quick Check:

   TTL = automatic deletion [OK]

Hint: TTL deletes expired data automatically to save space [OK]

Common Mistakes:

• Confusing TTL with encryption
• Thinking TTL backs up data
• Assuming TTL changes capacity settings

2. Which attribute type must the TTL attribute have in a DynamoDB table?

easy

A. String representing a date

B. Boolean indicating expiration

C. Binary data

D. Number representing epoch time in seconds

Solution

1. Step 1: Check TTL attribute requirements

   DynamoDB TTL requires a Number attribute that stores the expiration time as epoch time in seconds.

2. Step 2: Eliminate other types

   String, Boolean, or Binary types are not valid for TTL expiration timestamps.

3. Final Answer:

   Number representing epoch time in seconds -> Option D

4. Quick Check:

   TTL attribute = epoch seconds number [OK]

Hint: TTL attribute must be a number with epoch seconds [OK]

Common Mistakes:

• Using string dates instead of numbers
• Setting TTL attribute as Boolean
• Using binary data for TTL

3. Given a DynamoDB table with TTL enabled on attribute expireAt, what happens to an item with expireAt set to a timestamp 10 minutes in the past?

medium

A. The item is automatically deleted by DynamoDB

B. The item remains until manually deleted

C. The item is archived automatically

D. The item is updated with a new timestamp

Solution

1. Step 1: Understand TTL expiration behavior

   Items with TTL timestamps in the past are marked for deletion by DynamoDB automatically.

2. Step 2: Confirm deletion timing

   DynamoDB deletes expired items typically within 48 hours after expiration, often sooner.

3. Final Answer:

   The item is automatically deleted by DynamoDB -> Option A

4. Quick Check:

   Expired TTL item = auto delete [OK]

Hint: Expired TTL items get deleted automatically [OK]

Common Mistakes:

• Thinking expired items stay forever
• Assuming items get archived
• Believing TTL updates timestamps automatically

4. You enabled TTL on attribute sessionExpiry but items are not being deleted after expiration. What is the most likely cause?

medium

A. TTL only works on string attributes

B. The table has no primary key defined

C. The sessionExpiry attribute is missing or not a number

D. DynamoDB does not support TTL

Solution

1. Step 1: Check TTL attribute correctness

   TTL requires the attribute to exist and be a number representing epoch time; missing or wrong type prevents deletion.

2. Step 2: Verify other options

   Tables must have primary keys, but that doesn't affect TTL. TTL does not work on strings. DynamoDB supports TTL.

3. Final Answer:

   The sessionExpiry attribute is missing or not a number -> Option C

4. Quick Check:

   TTL attribute missing or wrong type = no deletion [OK]

Hint: TTL attribute must exist and be a number [OK]

Common Mistakes:

• Assuming TTL works on strings
• Ignoring missing TTL attribute
• Thinking DynamoDB lacks TTL support

5. You want to use TTL to automatically expire cached items after 1 hour. Which approach correctly sets the TTL attribute cacheExpire when inserting an item?

hard

A. Set cacheExpire to current date string plus 1 hour

B. Set cacheExpire to current epoch time plus 3600 seconds

C. Set cacheExpire to Boolean true

D. Do not set cacheExpire attribute

Solution

1. Step 1: Calculate TTL expiration timestamp

   TTL requires a number representing epoch time in seconds, so add 3600 seconds (1 hour) to current epoch time.

2. Step 2: Confirm correct attribute setting

   Setting a string or Boolean won't work; omitting the attribute disables TTL for that item.

3. Final Answer:

   Set cacheExpire to current epoch time plus 3600 seconds -> Option B

4. Quick Check:

   TTL = current time + seconds [OK]

Hint: TTL value = current epoch seconds + expiration seconds [OK]

Common Mistakes:

• Using date strings instead of epoch seconds
• Setting TTL as Boolean
• Not setting TTL attribute at all