lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prashant Saraf" <>
Subject RE: Use of Lucene for DB Search
Date Thu, 10 Apr 2008 14:28:06 GMT
Thanks I will check this out

Thanks and Regards
       प्रशांत सराफ
(Prashant Saraf)
Cross Country Infotech
Ext : 72543

-----Original Message-----
From: Erick Erickson [] 
Sent: Thursday, April 10, 2008 7:35 PM
Subject: Re: Use of Lucene for DB Search

As always, "It depends". What is it you really want to do? Lucene excels at
searching text, NOT at doing RDBM sorts of operations. So if you have large
amounts of text in columns in your DB, you can certainly put them in a
Lucene index and search. But as soon as you find yourself trying to make
Lucene to a join, you should re-think your approach, possibly flattening
your data.

That said, search the archive for anything written by Marcelo Ochoa. He's
written quite a bit about embedding Lucene in Oracle (as I remember). I
confess that I don't really understand what he's doing as it doesn't apply
to problems I face, but it sure looked interesting and may apply to your

Here's a copy of his latest e-mail that was quite recent that should get
you started...

Hi all:
 I just released a new version of Oracle-Lucene integration
implemented as a Domain Index.
 Binary distribution have a very straightforward installation and
testing step, downloads are at web site:
 Updated documentation is available as Google Document at:
 Source is available with public CVS access at:
 As consequence of reading many mails with feedback and development
tips from this list this new version have a lot performance
improvement by using a rowid<->lucene doc id cache, usage of
LoadFirstFieldSelector class to prevent Lucene from loading a complete
doc if only we need the rowid.
 Many thanks to all for sharing the experience.
 A complete list of changes is at:
 Best regards, Marcelo.

PD: I have a plan to a make a new version of Oracle-Lucene integration
synchronized with Lucene 2.3.1 ASAP.

On Thu, Apr 10, 2008 at 9:57 AM, Prashant Saraf <> wrote:

>  Hi,
>              We are planning to provide search functionality in the a web
> base application. Can we use Lucene for it to search data from database like
> oracle and MS-Sql?
> Thanks and Regards
>        प्रशांत सराफ
> (Prashant Saraf)
> Cross Country Infotech
> Ext : 72543
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:
View raw message