Full Text Search -- Architecture and Implementation

Full Text Search --

 Architecture –

-          Microsoft full text engine for sql server (MSFTESQL)

-          Microsoft Full text engine filter daemon(MSFTEFD) – that compromise the following s

     Filter

     Protocol handler

     Word breaker

-          MSFTESQL is a window services that is tightly integrated component of SQL Server 2005 which is used as a search engine. Its providing three functionality.

-          Implementing full text catalogs and indexes for the database

-          Querying the database with words, phrases and words with close approximately.

-          Managing the full text catalogs that are stored in SQL Server

Implementing Full text search –

n  Adding Full text catalog

-          Management studio -> storage node -> full text catalog -> add a new catalog

n  Adding Full text indexing table

-          Select database -> select table -> Right click option of full text index and define full text index ->full text indexing wizard

-          - Full text indexing wizard-> Select unique index -> next step ->select the column -> select option how to track the change ---- Automatic – For full population of indexing / Do not track change – for avoid a population and clean the start full population when index is created check box - > Add catalog or create new catalog -> create a table scheduler and catalog scheduler and scheduler them in the time.

Four Type of predicated used in SQL Server

1.       Free text – Similar meaning word not the exacting word

2.       Free text Table

3.       Contains – it can search for a word prefix of a word, synonyms of a word, word formed from another word.

4.       Contains Table

SELECT
FROM Production.ProductReviewWHERE CONTAINS(Comments, ' "learning curve" '); Comments