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 sdmnix@gmail.com designates
 209.85.160.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=eoNnYN9/mWbsVMPO7M5aMbegnDs+dsJem+4o2EO63+UIpCqGTf1QY+uzrbQ4h/vqAw
         RKIip9FAuKav8nemMyd2vu+5Lli4XQpWXAbc4JyCxt+Yt8RpWwusF1zuE8XkkhXq9fzv
         c+HOSUxjpu69WY4SHDJetlC3hxB5RZE5wHjrk=
MIME-Version: 1.0
Date: Thu, 22 Jul 2010 10:56:38 -0600
Message-ID: <AANLkTikxj6V3GFDEYGmtnjwNjxUJK5Pk7artCtszFz7V@mail.gmail.com>
Subject: Requesting data model suggestions
From: Scott Mann <sdmnix@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hello,

Although,  I've done a bit of reading about Cassandra's data model and
I've set up a Cassandra pair, I'm still unsure as to what might be
best for my purposes.

Briefly, I've got a set of strings A, B, and C. If needed, A could be
represented as an integer. Each A is associated with exactly one B or
C (but not both). A also has a number of parameters associated with it
which change over time. These changes, however, are reported with the
B or C identifier.

Currently, in mysql, I have three tables, A', B', and C' each using A,
B, and C as keys. When an update arrives, the code searches for the
key (B or C) in the appropriate table, determines the associated A
(using a foreign key), and then updates the values in the table row in
A' with key=A.

Anyone have ideas about how to model this in Cassandra?

Thanks!

-- 
-Scott