lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Erick Erickson" <erickerick...@gmail.com>
Subject Re: searching oracle databse records using apache Lucene
Date Tue, 01 Aug 2006 13:54:32 GMT
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 <vasily@kadme.com> 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 <meet_sap123@rediffmail.com> 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: java-user-unsubscribe@lucene.apache.org
> > > For additional commands, e-mail: java-user-help@lucene.apache.org
> > >
> > >
> ---------------------------------------------------
> 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: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message