OmniRim > OmniCare Support > Knowledge Base
KB Article #: 82 R & D Ref #:
Version:
ALL VERSIONS
Category: Database
Keywords:
Database, Search, Exclude, Noise, Words
Issue:
How to modify your search to exclude unwanted "noise" words
Description:
How to configure your OmniRIM installation so that the Search functionality ignores unwanted words like "a" or "to" or "and"....etc.
Cause:
Solution:
Microsoft SQL Server:
SQL Server can be modified to include/exclude certain noise words:
http://technet.microsoft.com/en-us/library/ms142551.aspx
To alter the noise word file for SQL Server please do the following:
1. on the database server, open a command window (Start > Run > cmd) and do a “net stop mssearch”
2. make changes to your noise word file
3. restart the mssearch service “net start mssearch”
Note that you’ll need to edit 6 files:
1. C:\MSSQL\FTDATA\SQLServer\Config\noise.eng
2. C:\MSSQL\FTDATA\SQLServer\Config\noise.enu
3. C:\MSSQL\FTDATA\SQLServer\Config\noise.dat
4. C:\WINDOWS\system32\noise.eng
5. C:\WINDOWS\system32\noise.enu
6. C:\WINDOWS\system32\noise.dat
FYI: if you are using American English, your noise word list is noise.enu, and for the Queens English/British use noise.eng. The noise.dat is for neutral word breakers.
After editing all the files and restarting the mssearch service, run a FULL Population on the Full Text Catalogue.
Oracle:
- Overview - http://www.sugarcrm.com/wiki/index.php?title=Overview_of_Full_Text_Stop_Words
-English StopList: http://download-west.oracle.com/docs/cd/B12037_01/text.101/b10730/astopsup.htm#sthref2381
-Viewing a Stop List: http://download-west.oracle.com/docs/cd/B12037_01/text.101/b10730/aviews.htm#sthref2505
-Overview of StopLists http://download-west.oracle.com/docs/cd/B12037_01/text.101/b10730/cdatadic.htm#sthref799
|
