I don't want to advertise DBSight there to polute the mailing list. But this recurring lucene database question often comes out. So here is the reply. And Tony, these questions you can contact us directly later.
What you asked is exactly what DBSight does. And all you need to do to get it up and running is to write simply SQL selects. Your main table is a fact table, formed a list of Documents in Lucene's term. You write your SQL to select all main table records, and other SQLs to retreive data from all other lookup tables. DBSight will retrieve all the data, create an lucene index. Check the step by step example and you will understand more. http://wiki.dbsight.com/index.php?title=Step_by_step And you can use DBSight to schedule data sync, configure search result templates, and much more. That's another story. It's easier to have DBSight setup, create your index, have your content website up and running like Google or Yahoo search, than reading all the marketing materials. Chris Lu ----------------------------------------- Full-Text Search on Any Databases http://www.dbsight.net Faster to setup than reading marketing materials. On 4/13/06, Tony Qian <[EMAIL PROTECTED]> wrote: > Chris, > > Thanks for your reply. I'm currently evaluating different products for full > text search. I visited DBSight web site briefly. Basically, I have a main > table which has a number of fields for Ids from look-up tables, for example > category_id, brand_id, product_id etc. Main table also has a description and > detail columns. After user types a number of keywords in a text box. My > query needs to search category table, brand table, product table, main table > etc. to see if anything matches. If matching, need to retrieve the record > from main table. > > I didn't see this kind of example at DBsight web site. I'm just wondering if > DBSight can do that. > > Thanks, > Tony > > > > > >From: "Chris Lu" <[EMAIL PROTECTED]> > >Reply-To: java-user@lucene.apache.org > >To: java-user@lucene.apache.org > >Subject: Re: full text search using Lucene > >Date: Mon, 10 Apr 2006 22:18:44 -0700 > > > >Hi, Tony, > > > >DBSight, like SearchBlox, Nutch, Solr, is using Lcuene to search. It > >just makes it super easy and flexible to create a search on any > >databases. Lucene's implementation is far more superior and flexible > >to MySql's full text search. > > > >Try it and you will know what I am talking about. Actually, I think > >it'll be faster to setup DBSight, have it running, see the results, > >than reading through marketing materials. :) > > > >Right now, no funding for us. We need to sell it at a meager price. > >Otherwise, we would be very willing to donate it to open source. > > > >Chris Lu > >----------------------------------------- > >Full-Text Search on Any Databases > >http://www.dbsight.net > >Faster to setup than reading marketing materials. > > > >On 4/10/06, Tony Qian <[EMAIL PROTECTED]> wrote: > > > All, > > > > > > I'm working on a project which requires full text search on multiple > >tables > > > in MySql database. Although, MySql supports full text search, it only > > > supports full text search on signle table. I'm wondering if Lucene can > >help > > > me to do full text search against MySql database. (I noticed that > >DBSight is > > > built on top of Lucene.) > > > > > > Any suggestion and links pointing to examples and tutorial are > >appreaciated. > > > > > > Tony > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
