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 rajkumar.w93@gmail.com
 designates 209.85.161.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type;
        b=d76aWbETnTT9cgzPDrtp2ah32ywnGY158GVVqUPfqNWttgx7IxiJBPHpuaaY08T+4H
         oUqK6LOvrUgyuWyT5lZbALt96GZqzv24NPig/hT+BR19FrFHQbd0+fICdnUV4b3tWtEj
         8flc1bZYhG1gXOAIB0Kp/7nbBwvhcc11VS8zI=
MIME-Version: 1.0
Sender: rajkumar.w93@gmail.com
In-Reply-To: <BANLkTinhmXaNNT75iokinNA=Rj_NMHE1yQ@mail.gmail.com>
References: <BANLkTinhmXaNNT75iokinNA=Rj_NMHE1yQ@mail.gmail.com>
Date: Wed, 18 May 2011 23:12:20 +0530
Message-ID: <BANLkTinABrT9U-ARkf1rrYe2gneEHDZEBA@mail.gmail.com>
Subject: Re: Design for 'Most viewed Discussions' in a forum
From: Aditya Narayan <adynnn@gmail.com>
To: user <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=0022158c0b511cb27a04a3906952

--0022158c0b511cb27a04a3906952
Content-Type: text/plain; charset=ISO-8859-1

I would arrange for memtable flush period in such a manner that the time
period for which these most viewed discussions are generated equals the
memtable flush timeperiod, so that the entire row of most viewed discussion
on a topic is in one or maximum two memtables/ SST tables.
This would also help minimize several versions of the same column in the row
parts in different SST tables.


On Wed, May 18, 2011 at 11:04 PM, Aditya Narayan <adynnn@gmail.com> wrote:

> *************
> For a discussions forum, I need to show a page of most viewed discussions.
>
> For implementing this, I maintain a count of views of a discussion & when
> this views count of a discussion passes a certain threshold limit, the
> discussion Id is added to a row of most viewed discussions.
>
> This row of most viewed discussions contains columns with Integer names &
> values containing serialized lists of Ids of all discussions whose views
> count equals the Integral name of this column.
>
> Thus if the view count of a discussion increases I'll need to move its 'Id'
> from serialized list in some column to serialized list in another column
> whose name represents the updated views count on that discussion.
>
> Thus I can get the most viewed discussions by getting the appropriate no of
> columns from one end of this Integer sorted row.
>
> ************
>
> I wanted to get feedback from you all, to know if this is a good design.
>
> Thanks
>
>
>
>
>
>

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

I would arrange for memtable flush period in such a manner that the time pe=
riod for which these most viewed discussions are generated equals the memta=
ble flush timeperiod, so that the entire row of most viewed discussion on a=
 topic is in one or maximum  two memtables/ SST tables. <br>
This would also help minimize several versions of the same column in the ro=
w parts in different SST tables.<br><br><br><div class=3D"gmail_quote">On W=
ed, May 18, 2011 at 11:04 PM, Aditya Narayan <span dir=3D"ltr">&lt;<a href=
=3D"mailto:adynnn@gmail.com">adynnn@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">*************<br>For a discussions forum, I=
 need to show a page of most viewed discussions.<br><br>For implementing th=
is, I maintain a count of views of a discussion &amp; when this views count=
 of a discussion passes a certain threshold limit, the discussion Id is add=
ed to a row of most viewed discussions. <br>

<br>This row of most viewed discussions contains columns with Integer names=
 &amp; values containing serialized lists of Ids of all discussions whose v=
iews count equals the Integral name of this column.<br><br>Thus if the view=
 count of a discussion increases I&#39;ll need to move its &#39;Id&#39; fro=
m serialized list in some column to serialized list in another column whose=
 name represents the updated views count on that discussion.<br>

<br>Thus I can get the most viewed discussions by getting the appropriate n=
o of columns from one end of this Integer sorted row.<br><br>************<b=
r><br>I wanted to get feedback from you all, to know if this is a good desi=
gn.<br>

<br>Thanks<br><br><br><br><br><br>
</blockquote></div><br>

--0022158c0b511cb27a04a3906952--