Rick - I'm not familiar with Oracle's Context search capabilities. The MS
Search Service can work with inflectional forms of a word (generation term),
prefix term, proximity term, simple term and weighted term via the CONTAINS
keyword. It is true that the indexes are not maintained on the fly. In
fact they're actually stored outside of SQL Server in NTFS full-text
catalogs. Indexes can be maintained via full or incremental repopulations.
You can find out more about the full text search capabilities by viewing the
following white papers
http://www.microsoft.com/sql/bizsol/textsearch.htm
and additional information at
http://www.microsoft.com/sql/DeployAdmin/filedata.htm and the SQL Server
Books On-Line.
--
HTH
--
Jerry Spivey
MCT, MCSE, MCSD
Senior SQL Instructor - Consultant
ARIS Corporation Bellevue, WA
(Please reply to the newsgroup only, not by email.)
Quote:> Are there any advantages that MS' Full-Text searching has over Oracle's
> Context search capabilities?
> I've never used Oracle, but as I understand, one of the stronger points of
> the Oracle product is the ability to use a lexicon to associate words so
> that a search on 'dogs' would return rows containing 'poodle' or
'chiuaua'.
> I understand that another strength of the Oracle product is that the
indexes
> are kept up-to-date in realtime so that a row added to the db would
> immediately be searchable. My understanding of MS Full-Text is that it's
> not kept up-to-date and requires periodic re-indexing to allow find new
> content.
> Any help justifying the MS side of the debate would be appreciated.
> - Rick -
by