Started working on a marketplace application and we are looking to intensely track user activity, store it in some DB so that the Data/AI team can use it later to model better recommendations. We want to track every request as well as other things such as a user expanding a description or stopping at a certain point (presumably interested in that item).
The format of how we store the data hasn't yet been decide on but it will be something standard and easy to query on a user level for the AI model.
What do you recommend for the backend:
- Own Lambda function -> call to Db to store data
- AWS Glue
- AWS CloudTrail
- Other service and why
What do you recommend for the database:
- Some SQL
- DynamoDb
- CassandraDb
- Other database and why