cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From S Ahmed <sahmed1...@gmail.com>
Subject forum application data model conversion
Date Tue, 22 Jun 2010 18:13:10 GMT
Converting a Forum application to cassandra's data model.

Tables:

Posts [postID, threadID, userID, subject, body, created, lastmodified]

So this table contains the actual question subject and body.

When a user logs in, they want to see a list of their questions, and also
order by the last-modified date (to see if people responed to their
question).

How would you do this best in Cassandra, seeing as the question/answer text
is stored in another table.

I know you could make a CF like:

userID { postID1, postID2, ...}

And somehow order by last-modified, but then on the actual web page you
would have to first query for postID's owned by the user, and orderd by
last-modified.

THEN you would have to fetch the post data from the posts collection.

Is this the only way?  I mean other than repeating the post subject+body in
the user-to-postID index CF.

Mime
View raw message