lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vasily Borisov <vas...@kadme.com>
Subject Re: searching oracle databse records using apache Lucene
Date Tue, 01 Aug 2006 13:32:23 GMT
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
View raw message