I agree completely. I was mostly responding to what appeared to be an
attempt to use lucene to actually execute a database query, which is
entirely different from restructing legacy data into a more-usable form as
you point out, and in which case all bets are off.

Erick

On 8/1/06, Vasily Borisov <[EMAIL PROTECTED]> wrote:

Eric,
I'm sure that is entirely true. E.g. in E&P industry we have a bunch of
legacy relational databases that are tremendously complex.
Therefore the presentation layer for them is never good since
the user is exposed to the data model complexity every time he uses this
database.

So, giving up on the structured API idea, flattening out the content and
indexing is seems to be not a bad idea at all. Especially if you are
facing the problem of integrating results from several legacy databases
or integrating the flat file store with a database.

Regards,
     Vasily


On Tue, 2006-08-01 at 09:18 -0400, Erick Erickson wrote:
> You're absolutely right, lucene is a text searching tool, not a database
> tool. There's no point in trying to jump through hoops to use lucene if
your
> database already works for you.
>
> If you're trying to do text searches, particularly if want to ask
questions
> like "find the words biggest and large within 5 words of each other",
then
> you might want to think about lucene. Or even if you want to just make
> simple searches over text.
>
> But to select rows from a database table, there's no reason to try to
use
> lucene. Use a database API instead.
>
> Best
> Erick
>
> On 8/1/06, Sandip <[EMAIL PROTECTED]> wrote:
> >
> >
> > Hi All,
> >
> > I am confused with Apache Lucene.
> >
> > I want to search my databse table records using apache lucene.
> > But what i found is that Lucene is full-text search engine.This means
is
> > it
> > only used to search documents text or anything else ?
> >
> > I want to search my databse like e.g.
> >
> > select * from tableName where username="abc";
> > using apache lucene.
> >
> > I am using Oracle 9i/Java for this.
> > Any idea/link/suggessions will be very much appreciable.
> >
> > Thanks in advance
> > Sandip Patil.
> > --
> > View this message in context:
> >
http://www.nabble.com/searching-oracle-databse-records-using-apache-Lucene-tf2032743.html#a5591986
> > Sent from the Lucene - Java Users forum at Nabble.com.
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
---------------------------------------------------
Vasily Borisov
Director Business Development
Kadme AS
Tel: +47 51 87 42 54
Fax: + 47 51 87 42 51
Mob: +47 45 20 40 42

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Reply via email to