Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of manirajv06@gmail.com designates
 209.85.213.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=uGp775tPwU82kCQE/u+XUAe8WsjjOftF5L8sli9ItqlE9RD5BYyzsj9Lg3usdH4qJV
         fCR6RdN6aw3zAKJ348RX9L5KH/InHnfWt+EVti5eGf203PpNBx9WspEwzEAPx33BnPh5
         q9CyM8SnWNrMA2CiVmIluIq/VODSZpDymOPfQ=
MIME-Version: 1.0
Date: Wed, 1 Sep 2010 12:39:27 +0530
Message-ID: <AANLkTikL-M-cRZUOh=8JGgTOPC7G6GfkeGvqxe8eLPc2@mail.gmail.com>
Subject: Need help in cassandra data model..
From: Manikandan R <manirajv06@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0015174becfcd8fa6a048f2d6050

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

Hello Everyone,

I am doing study on cassandra to make use of it for the below problem -

My current system has many components. To complete any transaction(request),
it has to pass through all the components. While it passes through, there is
no clear visibility to know what is happening behind each component at any
given point.

Trying to create a new component using cassandra, which receives the status
of the transaction(request) from other components for any given
transaction(request) id, so that it can viewed online in real time.

Here is the model, I have in my mind:

Transactions: {

    100: { //transaction id as key

         t1: { //Say, at time t1

              status: "Received the request. Doing validation";
              mode: "debug";
         };

         t2 : { // Say, at time t2

             status: "dropped:1000|absent=2000";
             dropped: 1000;
             absent: 2000;
             mode: "info";
         };


    101: { //transaction id as key

         t1: { //Say, at time t1

              status: "Doing External Verification..."
              mode: "debug";
         };

         t2 : { // Say, at time t2

             status: "valid:2000|invalid:1000";
             valid: 1000;
             invalid: 1000;
             mode: "info";
         };
}

Status can delivered to the users depending on the SLA. Based on the mode,
it can be displayed to users. Users who has access to see detailed status,
can see all the mode's status, where as, user who want to see only reports,
can see the mode with "info".

Please let me know your thoughts.

Thanks,
Mani

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

Hello Everyone,<br><br>I am doing study on cassandra to make use of it for =
the below problem - <br><br>My
 current system has many components. To complete any=20
transaction(request), it has to pass through all the components. While=20
it passes through, there is no clear visibility to know what is=20
happening behind each component at any given point.<br>
<br>Trying to create a new component using cassandra, which receives the
 status of the transaction(request) from other components for any given=20
transaction(request) id, so that it can viewed online in real time.<br><div=
><div class=3D"im">

<br>Here is the model, I have in my mind:<br><br>Transactions: {<br><br>=A0=
=A0=A0 100: { //transaction id as key<br><br>=A0=A0=A0=A0=A0=A0=A0=A0 t1: {=
 //Say, at time t1<br><br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 status: &=
quot;Received the request. Doing validation&quot;;<br>


=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 mode: &quot;debug&quot;;<br>=A0=A0=
=A0=A0=A0=A0=A0=A0 };<br><br>=A0=A0=A0=A0=A0=A0=A0=A0 t2 : { // Say, at tim=
e t2<br>=A0 =A0 =A0 =A0 =A0 <br>=A0 =A0 =A0 =A0 =A0 =A0=A0 status: &quot;dr=
opped:1000|absent=3D2000&quot;;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 dro=
pped: 1000;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 absent: 2000;<br>


=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 mode: &quot;info&quot;;<br>=A0=A0=A0=
=A0=A0=A0=A0=A0 };<br><br><br>
<br>
=A0=A0=A0 101: { //transaction id as key<br>
<br>
=A0=A0=A0=A0=A0=A0=A0=A0 t1: { //Say, at time t1<br>
<br>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 status: &quot;Doing External Verifi=
cation...&quot;<br>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 mode: &quot;debu=
g&quot;;<br>
=A0=A0=A0=A0=A0=A0=A0=A0 };<br>
<br>
=A0=A0=A0=A0=A0=A0=A0=A0 t2 : { // Say, at time t2<br>
=A0 =A0 =A0 =A0 =A0 <br>
=A0 =A0 =A0 =A0 =A0 =A0=A0 status: &quot;valid:2000|invalid:1000&quot;;<br>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 valid: 1000;<br>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 invalid: 1000;<br>=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0 mode: &quot;info&quot;;<br>
=A0=A0=A0=A0=A0=A0=A0=A0 };<br>}<br><br>Status can delivered to the users d=
epending on=20
the SLA. Based on the mode, it can be displayed to users. Users who has=20
access to see detailed status, can see all the mode&#39;s status, where as,=
=20
user who want to see only reports, can see the mode with &quot;info&quot;. =
<br>
<br>Please let me know your thoughts.<br><br>Thanks,<br>Mani
</div></div>

--0015174becfcd8fa6a048f2d6050--