Re: forum application data model conversion

2010-06-28 Thread Jonathan Ellis
The principle in Cassandra modeling is that for each query, you should denormalize your data at write time such that you can get the data for that query from a single row. The best explanation so far is at http://www.rackspacecloud.com/blog/2010/05/12/cassandra-by-example/ On Tue, Jun 22, 2010

Re: forum application data model conversion

2010-06-23 Thread S Ahmed
Any thoughts? On Tue, Jun 22, 2010 at 2:13 PM, S Ahmed sahmed1...@gmail.com wrote: 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

forum application data model conversion

2010-06-22 Thread S Ahmed
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