You are viewing a plain text version of this content. The canonical link for it is here.
Posted to java-user@lucene.apache.org by Sandip <me...@rediffmail.com> on 2006/08/01 12:30:41 UTC
searching oracle databse records using apache Lucene
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
Re: searching oracle databse records using apache Lucene
Posted by karl wettin <ka...@gmail.com>.
On Tue, 2006-08-01 at 15:32 +0200, Vasily Borisov wrote:
> the presentation layer for them is never good since the user is
> exposed to the data model complexity
Isn't that why we have facades?
---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
Re: searching oracle databse records using apache Lucene
Posted by Erick Erickson <er...@gmail.com>.
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 <va...@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 <me...@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
>
>
Re: searching oracle databse records using apache Lucene
Posted by Vasily Borisov <va...@kadme.com>.
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 <me...@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
Re: searching oracle databse records using apache Lucene
Posted by Erick Erickson <er...@gmail.com>.
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 <me...@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
>
>