[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Full-text INFLECTIONAL not corresponding people/person

Posted on 2004-04-07
8
Medium Priority
?
312 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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 1500 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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.

650 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