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 dmitriid@gmail.com designates
 72.14.220.156 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
         :content-transfer-encoding;
        b=DpKm8k0p4gMIjnf5IYO4D4Fna1fCORTDvl2fgJ8ioPdqV4m/5meEX4ByZTBFjnznV9
         DkzN5guzaXPe8/AMm5t+Ezy6VyX7f+OV81VRr67+1PNbZfFaXdfs3XKr9xPgUvmL7Xj4
         72Hd/kkT7Ys1E3JF22dfYZ+8EDsJ/yLYIoYXY=
MIME-Version: 1.0
Sender: dmitriid@gmail.com
In-Reply-To: <18611.150.140.17.75.1277388041.squirrel@webmail.ceid.upatras.gr>
References: <F0D33D81-18FA-4650-AC92-55B62ECC1B08@gmail.com>
	<18611.150.140.17.75.1277388041.squirrel@webmail.ceid.upatras.gr>
Date: Thu, 24 Jun 2010 18:19:33 +0300
Message-ID: <AANLkTikG_cusqm06vaArJEoUCW38SJsOqHfxRY6cEGF0@mail.gmail.com>
Subject: Re: Questions about data modeling
From: Dmitrii Dimandt <dmitrii@dmitriid.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Indeed. So simple it didn't even cross my mind :) Thank you!

On Thu, Jun 24, 2010 at 5:00 PM,  <altanis@ceid.upatras.gr> wrote:
> About the most popular item, you could probably store the k most popular
> items in a ColumnFamily with appropriate columns, and every time someone
> casts a vote, check whether they need updating/replacement.
>
> Alexander
>
>> I'm currently trying to wrap my head around Cassandra which is definitel=
y
>> not easy for a mind deeply entrenched in SQL :)
>>
>> I see how blogs/tweets etc. can be modeled in Cassandra. However, I have=
 a
>> sightly different problem.
>>
>> Let's say we let the user see a random
>> item(article/picture/recipe/you-name-it) and vote for it. We should show
>> the most popular items, the last articles/pictures the user has voted fo=
r
>> etc.
>>
>> 1. How can I show the most popular items?
>> 2. How can I present the user with a random item he hasn't seen yet?
>>
>> For the first question I figured I could have a <ColumnFamily
>> CompareWith=3D"LongType" =A0Name=3D"Rating"/> and store lists of items p=
er each
>> rating, updating them as necessary. Can't figure out a way to correctly
>> implement question number 2.
>>
>
>