cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohammad Kermani <>
Subject Cassandra data modeling for a social network
Date Mon, 30 May 2016 11:41:44 GMT
We are using Cassandra for our social network and we are designing/data
modeling tables we need, it is confusing for us and we don't know how to
design some tables and we have some little problems!

*As we understood for every query we have to have different tables*, and
for example user A is following user C and B.

Now, in Cassandra we have a table that is posts_by_user:

user_id      |  post_id       |  text  |  created_on  |  deleted  |

likes_count  |  comments_count  |  user_full_name

And we have a table according to the followers of users, we insert the
post's info to the table called user_timeline that when the follower users
are visiting the first web page we get the post from database from
user_timeline table.
And here is user_timeline table:

follower_id      |      post_id      | user_id (who posted)  |  likes_count  |

comments_count   |   location_name   |  user_full_name

*First, Is this data modeling correct for follow base (follower, following
actions) social network?*

And now we want to count likes of a post, as you see we have number of
likes in both tables*(user_timeline, posts_by_user)*, and imagine one user
has 1000 followers then by each like action we have to update all 1000 rows
in user_timeline and 1 row in posts_by_users; And this is not logical!
*Then, my second question is How should it be? I mean how should like
(favorite) table be?*

Thank you
I wish I can get answer

View raw message