cassandra-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Is this possible with cassandra
Date Fri, 29 Jan 2010 18:06:28 GMT
On Fri, Jan 29, 2010 at 9:09 AM, Mehar Chaitanya
<meharchaitanya@gmail.com> wrote:
>   1. This would lead to enourmous amount of duplication of data, in short
>   if I now want to view the data from IS_PUBLISHED dimenstion then my database
>   size would scale up tremendously.

Yes.  But disk space is so cheap it's worth using a lot of it to make
other things fast.

>   2. Above way of reprensting the data would suffice if I want to retrieve
>   something like, get me all the articles whose category is WORLDNEWS. But
>   what if I want to find out something like: Get me all the articles whose
>   Section is BASEBALL and Category is WORLDNEWS. For addressing queries taht
>   depend on multiple parameter how do we do it? Hope I am clear with my
>   problem statement :(

You have to do the intersection client-side (or use something like
http://github.com/tjake/Lucandra to do it for you).

-Jonathan

Mime
View raw message