Mailing List Archive

Using Lucene to index a DataBase
I've used Verity in Cold Fusion to index Databases. Is this possible with
Lucene? From recent posts, it looks like I would have to write a custom
parser to convert each row into a text document. Am I correct in thinking
this?

Scott

--
To unsubscribe, e-mail: <mailto:lucene-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:lucene-user-help@jakarta.apache.org>
Re: Using Lucene to index a DataBase [ In reply to ]
Not really. A document in Lucene is a logical entity comprising named
fields. So a row in the db would probably be represented as a Lucene
document. Each [searchable] column on the table would be represented as a
field of the document. However, you may find it necessary to build psuedo
fields in Lucene that span multiple columns in the database if you want to
do complex queries across multiple fields since in Lucene you typically need
to preface your search keywords with the field they are located in (eg.
Field1:SearchKey).


----- Original Message -----
From: "Weaver, Scott" <Sweaver@rippe.com>
To: "Lucene Users List" <lucene-user@jakarta.apache.org>
Sent: Thursday, November 29, 2001 11:17 AM
Subject: Using Lucene to index a DataBase


> I've used Verity in Cold Fusion to index Databases. Is this possible with
> Lucene? From recent posts, it looks like I would have to write a custom
> parser to convert each row into a text document. Am I correct in thinking
> this?
>
> Scott
>
> --
> To unsubscribe, e-mail:
<mailto:lucene-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
<mailto:lucene-user-help@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail: <mailto:lucene-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:lucene-user-help@jakarta.apache.org>
RE: Using Lucene to index a DataBase [ In reply to ]
I'm pretty sure that's what Verity/Cold Fusion was doing behind the scenes.
Thanks.

-----Original Message-----
From: Jeff Trent [mailto:jtrent@structsoft.com]
Sent: Thursday, November 29, 2001 11:26 AM
To: Lucene Users List
Subject: Re: Using Lucene to index a DataBase


Not really. A document in Lucene is a logical entity comprising named
fields. So a row in the db would probably be represented as a Lucene
document. Each [searchable] column on the table would be represented as a
field of the document. However, you may find it necessary to build psuedo
fields in Lucene that span multiple columns in the database if you want to
do complex queries across multiple fields since in Lucene you typically need
to preface your search keywords with the field they are located in (eg.
Field1:SearchKey).


----- Original Message -----
From: "Weaver, Scott" <Sweaver@rippe.com>
To: "Lucene Users List" <lucene-user@jakarta.apache.org>
Sent: Thursday, November 29, 2001 11:17 AM
Subject: Using Lucene to index a DataBase


> I've used Verity in Cold Fusion to index Databases. Is this possible with
> Lucene? From recent posts, it looks like I would have to write a custom
> parser to convert each row into a text document. Am I correct in thinking
> this?
>
> Scott
>
> --
> To unsubscribe, e-mail:
<mailto:lucene-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
<mailto:lucene-user-help@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail:
<mailto:lucene-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:lucene-user-help@jakarta.apache.org>

--
To unsubscribe, e-mail: <mailto:lucene-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:lucene-user-help@jakarta.apache.org>
Re: Using Lucene to index a DataBase [ In reply to ]
Yes, that is exactly the approach we have taken with the current project I
am working on using Lucene.

Write some code to retrieve desired rows from the database, then add each
database field as a Lucene field in a new Lucene document, then index,
search etc.

Works very well in our case.

Julian Doherty
Technical Manager, Website Design Projects
Education Review Office



"Weaver,
Scott" To: Lucene Users List <lucene-user@jakarta.apache.org>
<Sweaver@ripp cc:
e.com> Subject: Using Lucene to index a DataBase

30/11/2001
05:17
Please
respond to
"Lucene Users
List"






I've used Verity in Cold Fusion to index Databases. Is this possible with
Lucene? From recent posts, it looks like I would have to write a custom
parser to convert each row into a text document. Am I correct in thinking
this?

Scott

--
To unsubscribe, e-mail: <
mailto:lucene-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <
mailto:lucene-user-help@jakarta.apache.org>





--
To unsubscribe, e-mail: <mailto:lucene-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:lucene-user-help@jakarta.apache.org>