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]