Mailing-List: contact cassandra-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cassandra-dev@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates
 209.85.219.212 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :cc:content-type:content-transfer-encoding;
        b=ap9dbuHRRXon/udK9+Rc8Kj7JJoSsyvM/7AADFxqR3VS/aeQr/Y6tBww5/GB1OKSxb
         HaW3xf+NH/a6ZP7HGPhXuVseXaspi7cfb7CI1DuWtrWcaz2ERyHWv2aJIftLs6JgXM/8
         lWMXTnGEbTMIZWHdKp0Q+GEThFnZRALkf2Xoc=
MIME-Version: 1.0
In-Reply-To: <2d864a8c1001290709t6bf9afd1hb0c3f26eabccfacd@mail.gmail.com>
References: <2d864a8c1001290416g723270efxb79ac1831c159c9@mail.gmail.com>
	<e06563881001290630y71d372d6u6d0dbf9f75b017b@mail.gmail.com>
	<2d864a8c1001290709t6bf9afd1hb0c3f26eabccfacd@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Fri, 29 Jan 2010 12:06:28 -0600
Message-ID: <e06563881001291006y2c104a8aqd6634f77dd9db4ca@mail.gmail.com>
Subject: Re: Is this possible with cassandra
To: cassandra-dev@incubator.apache.org
Cc: Susheel Zaveri <susheel.zaveri@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Fri, Jan 29, 2010 at 9:09 AM, Mehar Chaitanya
<meharchaitanya@gmail.com> wrote:
> =A0 1. This would lead to enourmous amount of duplication of data, in sho=
rt
> =A0 if I now want to view the data from IS_PUBLISHED dimenstion then my d=
atabase
> =A0 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.

> =A0 2. Above way of reprensting the data would suffice if I want to retri=
eve
> =A0 something like, get me all the articles whose category is WORLDNEWS. =
But
> =A0 what if I want to find out something like: Get me all the articles wh=
ose
> =A0 Section is BASEBALL and Category is WORLDNEWS. For addressing queries=
 taht
> =A0 depend on multiple parameter how do we do it? Hope I am clear with my
> =A0 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