Return-Path: Delivered-To: apmail-incubator-cassandra-user-archive@minotaur.apache.org Received: (qmail 53616 invoked from network); 17 Dec 2009 18:49:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 17 Dec 2009 18:49:16 -0000 Received: (qmail 27985 invoked by uid 500); 17 Dec 2009 18:49:15 -0000 Delivered-To: apmail-incubator-cassandra-user-archive@incubator.apache.org Received: (qmail 27967 invoked by uid 500); 17 Dec 2009 18:49:15 -0000 Mailing-List: contact cassandra-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cassandra-user@incubator.apache.org Delivered-To: mailing list cassandra-user@incubator.apache.org Received: (qmail 27958 invoked by uid 99); 17 Dec 2009 18:49:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Dec 2009 18:49:15 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dmartin.pro@gmail.com designates 209.85.219.220 as permitted sender) Received: from [209.85.219.220] (HELO mail-ew0-f220.google.com) (209.85.219.220) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Dec 2009 18:49:13 +0000 Received: by ewy20 with SMTP id 20so718423ewy.20 for ; Thu, 17 Dec 2009 10:48:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=Dykk4egJ1jq16C3j8droOVTVuveoa2Ir+WansciLIKw=; b=wg2EJ/mcjdgmAjCOwdOcjuzXfOsqXavN1Mhy89mgQMafYWtituHc0E03zp36iEhwfb Ojx4vxi8vOFGcFN2b4Va66oo181/K+8Ig97O1D4npcGfbNfhBLcFbD2vQXTsJfTUgOVT LYgyu5jye1f32PNsm+F09rSDuWARKsZrQU9Go= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=qC10o3D6ScwOZk0cuQnkMXP4SHv5QEhS9cdnHLarVeOOJQZDE80yHgUEdraRULVaA3 AzmENlbyLuKW6w25OkdFad6KgYJ918MW101rP+cRLJUYmZf0d1BbH6MtSq5Xku0x5jEe uiWmL+Yz+fXj7EUqzg84u/n22TOUC8ze2llk0= MIME-Version: 1.0 Received: by 10.216.85.17 with SMTP id t17mr1011597wee.178.1261075731737; Thu, 17 Dec 2009 10:48:51 -0800 (PST) In-Reply-To: <5ae3b19e0912171010v67960f1aq5af812faad8047c5@mail.gmail.com> References: <54eb108f0912170912u5a336572rb65fa34ec4767e95@mail.gmail.com> <5ae3b19e0912171010v67960f1aq5af812faad8047c5@mail.gmail.com> Date: Thu, 17 Dec 2009 19:48:51 +0100 Message-ID: <54eb108f0912171048r57246e6t423b337cb9c3dc07@mail.gmail.com> Subject: Re: Is Cassandra suitable for multi criteria search engine From: David MARTIN To: cassandra-user@incubator.apache.org Content-Type: text/plain; charset=ISO-8859-1 Hi, That's what I was thinking. And I'm glad to read Apache solr in your answer as it is one of my main leads. David 2009/12/17, Tim Underwood : > It's not obvious to me how you'd do this in Cassandra but it sounds like a > Apache Solr might be a good fit. It lets you index documents with fields > and then allows you to query the documents based on field values and/or > ranges. > > -Tim > > On Thu, Dec 17, 2009 at 9:12 AM, David MARTIN wrote: > >> Hi everyone, >> >> That's a quite simple question : I have a big set of objects (around 3 >> millions) each containing several fields (> 20). Fields are just short >> strings, other can be larger strings (several hundreds characters, not so >> huge so), integers, ... >> >> I'd like to be able to look for objects based on one or more fields value >> or range. >> >> Is Cassandra as a nosql solution suitable for this kind of need or do I >> have to stay stuck to a database (using a denormalized approach) ? >> >> If Cassandra is suitable, what kind of data structure(s) do I need to >> adopt >> ? >> >> Thank you. >> >> David >> >