Re: Free format text searches ?

"Steven Wort" <SWort@globalnet.co.uk> wrote: >Can anyone tell me how to do free format text searches across multiple >columns and tables. > >What I am looking for is the ability to automatically generate a keyword >index on textual data as it is entered to the DB, so that subsequent >searches to are very fast? > >I have done something in MS SQL server using a keyword index generated on >an overnight process, but would like something that is a little more "built >in", that would be kept up to date as data is entered. > >Thanks >-- >Steve Wort We have implemented this in 6.4 for searching against serial titles and publisher addresses. We use a set of rules against each column to be indexed, calling a DBP to break the string down and insert rows into a keyword table and into a keyword-record table. The table is searched using a set of three single-column temporary tables to store the result set for the keyword and the latest combined result set. So far the system allows single or truncated keywords to be entered and 'AND'ed together. Performance on our 600,000 title database is acceptable on sensible searches, but slows down rather on words like 'JOURNAL' - 8s. This should improve on OI1.2 using in memory temporary tables. If more details are required, please contact me. Mark Crowder The British Library