storing index in third party database.

[am...@netscape.net]

Hi all

I want to index the datas which I already stored in a thirdparty database table and develop a search facility using lucene. I am thinking of storing this indexes back to the database in another table. I know for this we have to create a 'directory' which do all the indexing operations,

for example

Indexwriter indwriter = new Indexwriter("dirStore",null,create);

where dirStore is the directory, create is boolean.

but I don't know the format to be followed for the directory(dirStore).Please help  me if anybody has done similar thing.
TIA
Amith


__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: storing index in third party database.

[Karl Øie <ka...@gan.no>]

without having investigated the problem much i would think that a SQL 
database would be a very bad match for lucene as most of lucene's working is 
creating key's for words and documents and then creating indexes of these 
keys. for these purposes a SQL database is an unecessary overhead, not even 
talking about the overhead represented by the SQL language parser.

for these kind of indexes a lower-level database would be better suited. I 
have good experiences with BerkeleyDB (http://www.sleepycat.com) and a friend 
of me uses gdbm successfully for such key-pair indexing tasks. the advantage 
of these low-level databasesystems is that they are really much or less 
persistent b-tree/hashtable implementations, and thus created for key-pairing.

they have no SQL layer as you will have to program against them as they are 
more subroutines that applications. but for key-pair indexes i have 
experienced that BerkeleyDB runs circles around any SQL database (including 
db2 and oracle!!!).

Berkeley has a java-api and a b-tree record type that could be a very good 
match for a key-based searchtree, and it's free. take a look at it!

mvh karl øie

(ps: i am not payed by the sleepy cat to write this :-)



On Wednesday 03 April 2002 16:12, you wrote:
> If you want to store indices in a database search the mailing list
> archives for SqlDirectory.
>
> Once I considered using it for one application at work, so I asked its
> author about performance.  The answer was that it doesn't perform all
> that well when the index grows, if I recall correctly.  Consequently,
> we chose to use file-based indices instead.
>
> Otis
>
> --- amithnz@netscape.net wrote:
> > Hi all
> >
> > I want to index the datas which I already stored in a thirdparty
> > database table and develop a search facility using lucene. I am
> > thinking of storing this indexes back to the database in another
> > table. I know for this we have to create a 'directory' which do all
> > the indexing operations,
> >
> > for example
> >
> > Indexwriter indwriter = new Indexwriter("dirStore",null,create);
> >
> > where dirStore is the directory, create is boolean.
> >
> > but I don't know the format to be followed for the
> > directory(dirStore).Please help  me if anybody has done similar
> > thing.
> > TIA
> > Amith
> >
> >
> > __________________________________________________________________
> > Your favorite stores, helpful shopping tools and great gift ideas.
> > Experience the convenience of buying online with Shop@Netscape!
> > http://shopnow.netscape.com/
> >
> > Get your own FREE, personal Netscape Mail account today at
> > http://webmail.netscape.com/
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: storing index in third party database.

[Otis Gospodnetic <ot...@yahoo.com>]

If you want to store indices in a database search the mailing list
archives for SqlDirectory.

Once I considered using it for one application at work, so I asked its
author about performance.  The answer was that it doesn't perform all
that well when the index grows, if I recall correctly.  Consequently,
we chose to use file-based indices instead.

Otis

--- amithnz@netscape.net wrote:
> Hi all
> 
> I want to index the datas which I already stored in a thirdparty
> database table and develop a search facility using lucene. I am
> thinking of storing this indexes back to the database in another
> table. I know for this we have to create a 'directory' which do all
> the indexing operations,
> 
> for example
> 
> Indexwriter indwriter = new Indexwriter("dirStore",null,create);
> 
> where dirStore is the directory, create is boolean.
> 
> but I don't know the format to be followed for the
> directory(dirStore).Please help  me if anybody has done similar
> thing.
> TIA
> Amith
> 
> 
> __________________________________________________________________
> Your favorite stores, helpful shopping tools and great gift ideas.
> Experience the convenience of buying online with Shop@Netscape!
> http://shopnow.netscape.com/
> 
> Get your own FREE, personal Netscape Mail account today at
> http://webmail.netscape.com/
> 
> 
> --
> To unsubscribe, e-mail:  
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>