Understanding Full Text Search in SQL Server 2005: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Understanding Full Text Search in SQL Server 2005

page 3 of 7

by Uday Denduluri
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 21547/ 438

Article Contents:

Architecture

Let us identify different components of Full text search before going ahead with understanding the architecture.

· The Microsoft Full-Text Engine for SQL Server (MSFTESQL)

· The Microsoft Full-Text Engine Filter Daemon (MSFTEFD) that comprises the following:

1. Filter

2. Protocol handler

3. Word breaker

MSFTESQL is a windows service that is a tightly integrated component of SQL Server 2005 which is used as a search engine. This is built on the (MSSearch) technology. MSFTESQL service is mainly involved in providing three functionalities.

· Implementing full-text catalogs and indexes for database

· Querying the database with words, phrases and words in close proximity [meaning of a word]

· Managing the full-text catalogs that are stored in SQL servers

MSSearch is a process in windows system that is responsible for doing the cataloguing and indexing. This file name is mssearch.exe. This process will be used by MSFTESQL service to implement the indexing and full-text catalogs.

« (Page 2)

View Entire Article

(Page 4) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 2 and 7 and type the answer here:

User Comments

Title: Understanding Full Text Search in SQL Server 2005
Name: Sanjeev
Date: 11/13/2008 12:24:53 PM
Comment:
Good article for Beginers , Thanks for sharing .
Please explain other advanced topics soon in full text .

Thanks

Title: make it simple
Name: Neela
Date: 11/1/2008 12:26:48 AM
Comment:
want to make catalogue for differant cat.please explain in simple language

Title: Try to explain more next time....
Name: WebEye
Date: 9/5/2008 11:48:52 PM
Comment:
Try to explain more next time....

Title: Mr.
Name: Hitesh
Date: 7/30/2008 12:37:47 PM
Comment:
Good Article.

Title: Usless
Name: Programmer
Date: 7/8/2008 5:02:18 AM
Comment:
More details please

Title: Mr
Name: Prasad
Date: 5/7/2008 2:34:49 PM
Comment:
Good Article for beginers

Title: Mr
Name: khodor
Date: 4/21/2008 4:52:41 PM
Comment:
it is a good in general but i want more example about freetext table and containstable

Title: SQL Full Text Search - storage
Name: Jack Kangas
Date: 12/24/2007 3:46:39 PM
Comment:
You mention that section on MSFTESQL (a windows service) - manages "the full text catalogs taht are stored within SQL Server"

I just created an index and there is now 75 meg of files in a catalog folder on the machine. What is in those .ci, .dir and .wid files?

I am asking because I am concerned about security on the words that are in the full text index. If anyone could read the words in those files (that are external to SQL Server's normal MDB, NDB, and LDB files.

Title: SQL Full Text Search
Name: Saurabh Sharma
Date: 12/9/2007 11:52:07 PM
Comment:
Another gr8 one article.

Title: SQL Full Text Search
Name: SAuarbh Sharma Software Engineer.
Date: 12/9/2007 11:50:47 PM
Comment:
It's Really Helpful and gr8 article. Thanx.

Title: SQL Full Text Search
Name: Nitin Sharma Software Engineer
Date: 12/3/2007 10:53:50 PM
Comment:
Great one..!!