[prev in list] [next in list] [prev in thread] [next in thread] 

List:       lucene-user
Subject:    Re: Combining text search + relational search
From:       Tatu Saloranta <tatu () hypermall ! net>
Date:       2004-04-29 4:17:09
Message-ID: 200404282217.09461.tatu () hypermall ! net
[Download RAW message or body]

On Wednesday 28 April 2004 11:00, Mike_Belasco@fws.gov wrote:
> Bascially I want to limit the results of the text search by the rows that
> are returned in a relational search of other attribute data related to the
> document. The text of the document is just like any other attribute it just
> needs to be queried differently. Does that make sense?

Yes. But why not just store textual content in one Lucene field, and metadata 
in one or more separate fields? You can then easily build queries to combine 
searches. And as long as metadata values are normalized, added index size is 
probably insignificant compared to full indexed text content.

-+ Tatu +-

>
> Thanks
> Mike
>
>
>
>
>
>
>
>              Stephane James
>              Vaucher
>              <vauchers@cirano.                                          To
>              qc.ca>                    Lucene Users List
>                                        <lucene-user@jakarta.apache.org>
>              04/28/2004 10:38                                           cc
>              AM
>                                                                    Subject
>                                        Re: Combining text search +
>              Please respond to         relational search
>                "Lucene Users
>                    List"
>              <lucene-user@jaka
>               rta.apache.org>
>
>
>
>
>
>
> I'm a bit confused why you want this.
>
> As far as I know, but relational db searches will return exact
> matches without a mesure of relevancy. To mesure relevancy, you need a
> search engine. For your results to be coherent, you would have to put
> everything in the lucene index.
>
> As for memory consumption, for searching, if the index is on disk, then
> the memory footprint depends on the type of queries you use. For indexing,
> it depends if you use tmp RAMDirectory to do merges, otherwise, memory
> consumption is minimal.
>
> HTH
> sv
>
> On Wed, 28 Apr 2004 Mike_Belasco@fws.gov wrote:
> > I need to somehow aloow users to do a text search and query relational
> > database attributes at the same time. The attributes are basically
>
> metadata
>
> > about the documents that the text search will be perfomed on. I have the
> > text of the documents indexed in Lucene. Does anyone have any advice or
> > examples. I also need to make sure I don't garble up all the memory on
>
> our
>
> > server
> >
> > Thanks
> > Mike
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: lucene-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: lucene-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: lucene-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: lucene-user-help@jakarta.apache.org
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: lucene-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: lucene-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: lucene-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: lucene-user-help@jakarta.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]