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 openvictor@gmail.com
 designates 209.85.214.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=nJyQfbVZkQRSU2gaYafKyLNsrQlWQoQIwz+Ws9sDTuOAJAVTkvP7J7O+nqBsP1U979
         4Vq8oTy3m6bU/KyZ4XCb5LR5sJZhcxICPTKslZhCwnJl/EypUvOP3NnT4SmgcnKue3B1
         kRlg12MYa7Qm3e9CXLIrgo1CkaDBxFQzc5agI=
MIME-Version: 1.0
Date: Wed, 18 May 2011 13:44:30 -0400
Message-ID: <BANLkTimt1etUapzkzj=paSbg9_nTPThh5w@mail.gmail.com>
Subject: Recommandation on how to organize CF
From: openvictor Open <openvictor@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=bcaec51d2246d1fe6304a390701e

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

Hello all,

I know organization is a broad topic and everybody may have an idea on how
to do it, but I really want to have some advices and opinions and I think it
could be interesting to discuss this matter.

Here is my problem: I am designing a messaging system internal to a website.
There are 3 big structures which are Message, MessageList, MessageBox. A
message/messagelist is identified only by an UUID; a MessageBox is
identified by a name(utf8 string). A messagebox has a set of MessageList in
it and a messagelist has a set of message in it, all of them being UUIDs.
Currently I have only two CF : message and message_time. Message is a
UTF8Type (cassandra 0.6.11, soon going for 0.8) and message_time is a
TimeUUIDType.

For example if I want to request all message in a certain messagelist I do :
message_time['messagelist:uuid(messagelist)']
If I want information of a mesasge I do message['message:uuid(message)']
If I want all messagelist for a certain messagebox ( called nameofbox for
user openvictor for this example) I do :
message_time['messagebox:openvictor:nameofbox']

My question to Cassandra users is : is it a good idea to regroup all those
things into two CF ? Is there some advantages / drawbacks of this two CFs
and for long term should I change my organization ?

Thank you,
Victor

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

Hello all,<br><br>I know organization is a broad topic and everybody may ha=
ve an idea on how to do it, but I really want to have some advices and opin=
ions and I think it could be interesting to discuss this matter.<br><br>
Here is my problem: I am designing a messaging system internal to a website=
. There are 3 big structures which are Message, MessageList, MessageBox. A =
message/messagelist is identified only by an UUID; a MessageBox is identifi=
ed by a name(utf8 string). A messagebox has a set of MessageList in it and =
a messagelist has a set of message in it, all of them being UUIDs.<br>
Currently I have only two CF : message and message_time. Message is a UTF8T=
ype (cassandra 0.6.11, soon going for 0.8) and message_time is a TimeUUIDTy=
pe.<br><br>For example if I want to request all message in a certain messag=
elist I do : message_time[&#39;messagelist:uuid(messagelist)&#39;]<br>
If I want information of a mesasge I do message[&#39;message:uuid(message)&=
#39;]<br>If I want all messagelist for a certain messagebox ( called nameof=
box for user openvictor for this example) I do : message_time[&#39;messageb=
ox:openvictor:nameofbox&#39;]<br>
<br>My question to Cassandra users is : is it a good idea to regroup all th=
ose things into two CF ? Is there some advantages / drawbacks of this two C=
Fs and for long term should I change my organization ?<br><br>Thank you,<br=
>
Victor<br>

--bcaec51d2246d1fe6304a390701e--