cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tamar Fraenkel <ta...@tok-media.com>
Subject Re: data model question
Date Sun, 11 Mar 2012 10:15:22 GMT
Hi!
Thanks for the response.
>From what I read, secondary indices are good only for columns with few
possible values. Is this a good fit for my case? I have unique facebook id
for every user.
Thanks

*Tamar Fraenkel *
Senior Software Engineer, TOK Media

[image: Inline image 1]

tamar@tok-media.com
Tel:   +972 2 6409736
Mob:  +972 54 8356490
Fax:   +972 2 5612956





On Sun, Mar 11, 2012 at 11:48 AM, Marcel Steinbach <msteinba@gmail.com>wrote:

> Either you do that or you could think about using a secondary index on the
> fb user name in your primary cf.
>
> See http://www.datastax.com/docs/1.0/ddl/indexes
>
> Cheers
>
> Am 11.03.2012 um 09:51 schrieb Tamar Fraenkel <tamar@tok-media.com>:
>
>  Hi!
> I need some advise:
> I have user CF, which has a UUID key which is my internal user id.
> One of the column is facebook_id of the user (if exist).
>
> I need to have the reverse mapping from facebook_id to my UUID.
> My intention is to add a CF for the mapping from Facebook Id to my id:
>
> user_by_fbid = {
>   // key is fb Id, column name is our User Id, value is empty
>   100003101876963: {
>     f94f6b20-161a-4f7e-995f-0466c62a1b6b : ""
>   }
> }
>
> Does this makes sense.
> This CF will be used whenever a user log in through Facebook to retrieve
> the internal id.
> Thanks
>
> *Tamar Fraenkel *
> Senior Software Engineer, TOK Media
>
> <tokLogo.png>
>
>
> tamar@tok-media.com
> Tel:   +972 2 6409736
> Mob:  +972 54 8356490
> Fax:   +972 2 5612956
>
>
>
>

Mime
View raw message