You are viewing a plain text version of this content. The canonical link for it is here.
Posted to java-user@lucene.apache.org by "Niranjan Soni (sent by Nabble.com)" <li...@nabble.com> on 2005/09/30 17:57:06 UTC

Implementing Lucene Search on DB2

Hello all

I am new to Lucene and evaluating this software for a search engine that we would like to build for our e-commerce website.

Our existing website is using DB2 database and using DB2 Text Extender for search functionality. We would use Lucene Search Engine instead of DB2 Text Extender. I would like to get some more information about how/best way to implement Lucene Search on DB2.

Our existing search module creates/updates indexes on 4 fields from 3 database tables each. And the search is performed using combination of these 3 tables and 4 fields from each of these 3 tables.

We would like to implement a similar solution using Lucene. Can anyone provide me with any kind of information how we can achieve this?

Thanks & Regards
Niranjan Soni
--
Sent from the Lucene - Java Users forum at Nabble.com:
http://www.nabble.com/Implementing-Lucene-Search-on-DB2-t362576.html#a1004118

Re: Implementing Lucene Search on DB2

Posted by Ian Soboroff <ia...@nist.gov>.
You should look to the various papers by Ophir Frieder, David
Grossman, Abdur Chowdhury and others from IIT.  They developed a whole
IR system in SQL.

http://ir.iit.edu/irwebsiteserv/IRViewer?docid=159
http://ir.iit.edu/irwebsiteserv/IRViewer?docid=132

Grossman and Frieder have a recent textbook on IR, as well.

Ian

"Niranjan Soni (sent by Nabble.com)" <li...@nabble.com> writes:

> Hello all
>
> I am new to Lucene and evaluating this software for a search engine that we would like to build for our e-commerce website.
>
> Our existing website is using DB2 database and using DB2 Text Extender for search functionality. We would use Lucene Search Engine instead of DB2 Text Extender. I would like to get some more information about how/best way to implement Lucene Search on DB2.
>
> Our existing search module creates/updates indexes on 4 fields from 3 database tables each. And the search is performed using combination of these 3 tables and 4 fields from each of these 3 tables.
>
> We would like to implement a similar solution using Lucene. Can anyone provide me with any kind of information how we can achieve this?
>
> Thanks & Regards
> Niranjan Soni
> --
> Sent from the Lucene - Java Users forum at Nabble.com:
> http://www.nabble.com/Implementing-Lucene-Search-on-DB2-t362576.html#a1004118


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


Re: Implementing Lucene Search on DB2

Posted by Chris Lu <ch...@gmail.com>.
We have a product, DBSight, just to extract database content and
render search results. DB2 is one of the supported databases.
Many features can be found on the website.

For your case, DBSight can easily select all your data you needed and
create an index to search on.
At least you can very quickly to get it running.

Let us know the performance difference you experienced, DB2 Text
Extender vs. Lucene.

Chris
------------------------
Lucene RAD on Any Databases
http://www.dbsight.net


On 9/30/05, Niranjan Soni (sent by Nabble.com) <li...@nabble.com> wrote:
>
> Hello all
>
> I am new to Lucene and evaluating this software for a search engine that we would like to build for our e-commerce website.
>
> Our existing website is using DB2 database and using DB2 Text Extender for search functionality. We would use Lucene Search Engine instead of DB2 Text Extender. I would like to get some more information about how/best way to implement Lucene Search on DB2.
>
> Our existing search module creates/updates indexes on 4 fields from 3 database tables each. And the search is performed using combination of these 3 tables and 4 fields from each of these 3 tables.
>
> We would like to implement a similar solution using Lucene. Can anyone provide me with any kind of information how we can achieve this?
>
> Thanks & Regards
> Niranjan Soni
> --
> Sent from the Lucene - Java Users forum at Nabble.com:
> http://www.nabble.com/Implementing-Lucene-Search-on-DB2-t362576.html#a1004118
>
>

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