You are right. Database usually is in 3NF, while lucene usually works on an array of objects. Different database has different data model. There are quite some efforts to crawl database, create the lucene index, keep it in sync with the database, and rendering the search results. If data model changes or you need to work on another database, duplicating those efforts is not fun.
DBSight is a web server I am working on to save the effort of creating a Lucene search on database tables. It can work on any databases. You can easily adjust search ranking, field weight, analyzers for each field, search result template, etc, just by UI. -- Chris Lu ------------------------- Instant Full-Text Search On Any Database/Application site: http://www.dbsight.net demo: http://search.dbsight.com On 12/12/06, Andrew Hughes <[EMAIL PROTECTED]> wrote:
Hey All, I am very interested in indexing a 3NF Data Structure. Is there any advice that someone can provide with this? From what I have seen Lucene is typically a flat "First Normal Form" (Flat) data structure.... The only way I can see to combine the relational links between multiple indexes is to compare documents. Any Help is Appreciated. --------------------------------------------------------------------- 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]
