Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of sahmed1020@gmail.com
 designates 74.125.82.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=dWu+yUIVKQA291GhjlRyhxY5Y/Y4EuzyABUkYCaNxN0KMTg92b0MV/Wz4ZZg5R68p3
         QiugYUApo2KypP+UQNKsOxXgj7cRuYB2i7SVE13XMwjpjv9i+AJoNn3BWmr7b46IDpkR
         tYNtF5EHjO6cbYIdY1LfKYa386WbNUKKaqslM=
MIME-Version: 1.0
In-Reply-To: <AANLkTimHuXQvYQ774lPCJYCtaGeFSJu1yAzdtP7IarLy@mail.gmail.com>
References: <AANLkTimHuXQvYQ774lPCJYCtaGeFSJu1yAzdtP7IarLy@mail.gmail.com>
Date: Wed, 23 Jun 2010 21:49:45 -0400
Message-ID: <AANLkTimJ8HY-xi6vv24tGzm7rc6cWObjJuQIVnTSin4v@mail.gmail.com>
Subject: Re: forum application data model conversion
From: S Ahmed <sahmed1020@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0016e6d77cc876e3ce0489bcde5f

--0016e6d77cc876e3ce0489bcde5f
Content-Type: text/plain; charset=ISO-8859-1

Any thoughts?

On Tue, Jun 22, 2010 at 2:13 PM, S Ahmed <sahmed1020@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 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.
>
>
>

--0016e6d77cc876e3ce0489bcde5f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Any thoughts?<br><br><div class=3D"gmail_quote">On Tue, Jun 22, 2010 at 2:1=
3 PM, S Ahmed <span dir=3D"ltr">&lt;<a href=3D"mailto:sahmed1020@gmail.com"=
>sahmed1020@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_q=
uote" style=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 2=
04, 204); padding-left: 1ex;">
Converting a Forum application to cassandra&#39;s data model.<br><br>Tables=
:<br><br>Posts [postID, threadID, userID, subject, body, created, lastmodif=
ied]<br><br>So this table contains the actual question subject and body.<br=
>

<br>When a user logs in, they want to see a list of their questions, and al=
so order by the last-modified date (to see if people responed to their ques=
tion).<br><br>How would you do this best in Cassandra, seeing as the questi=
on/answer text is stored in another table.<br>

<br>I know you could make a CF like:<br><br>userID { postID1, postID2, ...}=
<br><br>And somehow order by last-modified, but then on the actual web page=
 you would have to first query for postID&#39;s owned by the user, and orde=
rd by last-modified.<br>

<br>THEN you would have to fetch the post data from the posts collection.<b=
r><br>Is this the only way?=A0 I mean other than repeating the post subject=
+body in the user-to-postID index CF.<br><br><br>
</blockquote></div><br>

--0016e6d77cc876e3ce0489bcde5f--