Solved

Full-text INFLECTIONAL not corresponding people/person

Posted on 2004-04-07
8
290 Views
Last Modified: 2006-11-17
I have a full-text indexed table and am able to pull a query using INFLECTIONAL that successfully pairs up louse/lice, mouse/mice. woman,women.  It's not finding person/people, however.  I imagine there's a dictionary lookup table within SQL server where it is simply missing this relationship.  I'm wondering if anyone knows where that table is or how I can find out.

Thanks,
Meg
0
Comment
Question by:mwidholm
  • 5
  • 3
8 Comments
 
LVL 3

Expert Comment

by:jayrod
ID: 10778692
A suggestion would be to use profiler to see where it is..

if there is not a query to a dictionary somewhere than I would look for an xml file under the mssql/data/ directory containing words and data for full text searches
0
 

Author Comment

by:mwidholm
ID: 10784449
Thanks jayrod.  I had never used profiler before, so I went in and it seems that where it's referencing the dictionary must be happening in the stored procedure, "sp_fulltext_data" and that's all the detail it's giving me.  Are these stored procedures viewable by sa?  I'm a dbo and I don't see it, but I can ask my boss to take a look.  He's very busy right now, so gaining access to stuff has been a pain.  

I had already looked under mssql/data, but the only xml files I found were 1kb.

Thanks for your help.
0
 
LVL 3

Expert Comment

by:jayrod
ID: 10784803
I couldn't find it either.. so not sure where to look from here.. I'll keep lookin tho
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:mwidholm
ID: 10785037
Well, I found "sp_fulltext_getdata" under the extended stored procedures in the master database.  However, I guess we can't see the code on those extended stored procedures and I'm back at square one.  I've been kind of poking at the system tables in the master now to see if any of them seem dictionary-esque.  I'm starting to feel like I'm reverse-engineering to fix a bug, which is probably incredibly impractical.  I'm so curious now though...
0
 
LVL 3

Accepted Solution

by:
jayrod earned 500 total points
ID: 10785083
I kind of guessed they may be extended stored procedures... so ya.. kind of hard to fix it or change it
0
 

Author Comment

by:mwidholm
ID: 10785672
I'm new here and don't entirely understand the point system.  While we didn't come to a solution, I appreciate your help tremendously and would like to give you the points- is that ok by the rules?
0
 
LVL 3

Expert Comment

by:jayrod
ID: 10785701
not sure.. you can ask for a refund of points after a certain amount of time if there aren't any answeres.

I'd leave it open for a while maybe let some others have a chance at giving some helpful information.

Come back in a few days and if no one has either posted some feedback or hints then you can close the question by assigning points or a refund.

either way it's all good :)
0
 
LVL 3

Expert Comment

by:jayrod
ID: 11053137
Hope you're still subscribed.. I finally found it. The thesaurus used for full text inflectional querying is found in:

c:\program files\microsoft sql server\ftdata\sqlserver\config

the thesaurus is in an xml file there. This is also where all of the noise words are stored.  As of service pack 2 the thesaurus option was implemented but disabled.

I found this data from sql Server 2k unleashed.

hope that helps ya..

although I just looked in that directory and I couldn't make heads or tails of the xml file. :P
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question