Combining text search + relational search
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]
Re: Combining text search + relational search
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]
Re: Combining text search + relational search
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.caLucene 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]
Re: Combining text search + relational search
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.caLucene 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]