Create a Lucene index from data in DB, and make sure to include PKs in one of the fields (use Field.Keyword). Then query your RDBMS and get back the ResultSet. Then get the PK from each ResultSet and use it to construct a Lucene BooleanQuery, which should include your original query string AND returned PKs combined with OR.
That is, if I understand what yo uare trying to do :) Otis --- [EMAIL PROTECTED] 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? > > Thanks > Mike > > > > > > > > > Stephane James > > Vaucher > > <[EMAIL PROTECTED] > To > qc.ca> Lucene Users List > > > <[EMAIL PROTECTED]> > 04/28/2004 10:38 > cc > AM > > > Subject > Re: Combining text search + > > Please respond to relational search > > "Lucene Users > > List" > > <[EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
