Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Application (audit) logging using AWS - Timestream vs DynamoDB

1

We have a large CMS application that produces quite a large amount of log data (upto 100,000 records per day). We want to be able to store the audit log, something like this -

'timestamp, entity type, entity ID, operation <ADD/EDIT/DELETE>, <change made>, userID'

So, for example, if we want to store information about who edited a page and when, entity type and entity Id would be 'page' and the page ID respectively. We would like to hold about 6-12 months of audit history and would like to be able to search the logs to satisfy queries like:

  • For Page A, give me all events

  • For Page A, give me all events where timestamp is between 10 days ago and now()

  • For Page A, give me all events where operation=EDIT and timestamp is between 10 days ago and 5 days ago

Between AWS Timestream and DynamoDB, which one would be a more optimal choice for this specific use case? How do these two services compare in terms of meeting the requirements?

Topics
Database
Tags
Amazon TimestreamAmazon DynamoDB
Language
English

asked 3 years ago978 views

1 Answer
2

DynamoDB is by far the the better service for this use-case, you are only needing key-value lookups and don't require the additional features that Timestream offers, like running analytical queries over a given time period.

It's a simple design for DynamoDB where you can efficiently perform your access patterns and you can also use TTL to delete data older than 12 months free of charge.

AWS
EXPERT

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content