1) Because database mainly uses B-tree to index records' some columns. Lucene or other full text search software uses to analyze the content of each document and saved to inverted index. "Lucene's index falls into the family of indexes known as an inverted index. This is because it can list, for a term, the documents that contain it. This is the inverse of the natural relationship, in which documents list terms."
Oracle has it's full-text search, ultrasearch. But you need to pay a lot extra for it. 2) It'll work. But that will lose the unique information for each column. And you may want to assign different weight to each filed. I(working for DBSight) recommend you to take a look at http://www.DBSight.net. It will help you to understand Lucene with databases better. Chris Lu -------------- Full-Text Search on Any Databases http://www.dbsight.net On 1/17/06, Vikas Khengare <[EMAIL PROTECTED]> wrote: > Hi Friends, > > I have very basic question that > > 1] Why we use Lucene for Database search like Oracle / Sybase ? > 2] For that first we have to convert all records one bye one in > string then build lucene document and then index it ? > > Thanks > > From, > [ [EMAIL PROTECTED] ] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
