Redis Cache With Data Sources, Users, and Queries

Question

I am starting to use Redis as a cache and I am not sure of the best structure for my application. The overall structure is below:

Some things I need to be able to do are:

Flushing everything for a data source (all users and all queries).
Flushing everything for a particular user (e.x: I would need to remove user 1 and it's queries from data source 1 and data source 2).

Everything listed in the tree is meant to be a part of the key to accessing the results of running the query for the user on the specific data source. I am new to Redis and have been going back and forth between using Hashes and Sets.

Option 1 (Sets):

DataSource1 => user1, user2, user3, user4
DataSource1:user1 => Query1, Query2, Query3
DataSource1:user1:Query1 => Results

Flushing things would be expensive because I would have to find all keys that match user1 or DataSource1.

Partial Option 2 (Hashes):

users:user1 DataSource1:Query1 Results1 DataSource2:Query1 Results2

Still not sure how flushing data sources or users would work here.

Does anyone have other thoughts/modifications?

Chris Tanner · Accepted Answer · 2017-01-12 14:58:35Z

1

Based on the information I would have a set with DataSource -> Users,and a hash for users -> queries. That way flushing users is just deleting the hash, and flushing a data source (which you probably do less) is looping through the set and deleting users, then deleting the datasource -> user set.

If you go with the first option of sets then it'll be more operations every time you flush queries from users, but it really depends on the the data is accessed.

Also depending on how many queries you store per user, hashes are more efficient than sets.

answered Jan 12, 2017 at 14:58

Chris Tanner

1,6701 gold badge12 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Special Character Over a year ago

I like this solution. It is clean and straightforward. Thanks!

Collectives™ on Stack Overflow

Redis Cache With Data Sources, Users, and Queries

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related