Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / July 2005

Tip: Looking for answers? Try searching our database.

SQL 2005 CTP - How can I get a full Thesaurus

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
wkbia - 21 Jul 2005 15:26 GMT
How can I get and install a full Thesaurus into SQL Server 2005 CTP?

Thanks in advance!

Wayne
Hilary Cotter - 21 Jul 2005 17:08 GMT
there is no full thesaurus. Basically many people would be upset if they
started getting unexpected results coming back in their searches. So MS
hands you a sample and has you customize it.

You can find it at C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\FTData

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> How can I get and install a full Thesaurus into SQL Server 2005 CTP?
>
> Thanks in advance!
>
> Wayne
wkbia - 22 Jul 2005 02:26 GMT
That's a lot of work; can't expect a developer to be a grammer grad as well.
It would be nice if they supplied a full English thesarus that could be put
online and modified as needed as I think more people are upset that they are
not getting the results they expect from a thesarus search, this is why
they're doing it. Inflectional searches seem to be fully functional and
releasing a full-text thesarus search should be fully functional as well.

I think I seen a post from you stating that you could get a thesarus from
Word. Is this true and if so, can you tell me how I can obtain and install it.

Thank you Hilary. I seen a lot of replies from you and I'm sure there are
many who appreciate that you are doing this as I do.

With best regards,

Wayne

> there is no full thesaurus. Basically many people would be upset if they
> started getting unexpected results coming back in their searches. So MS
[quoted text clipped - 8 lines]
> >
> > Wayne
Hilary Cotter - 22 Jul 2005 03:27 GMT
Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> That's a lot of work; can't expect a developer to be a grammer grad as well.
> It would be nice if they supplied a full English thesarus that could be put
[quoted text clipped - 25 lines]
> > >
> > > Wayne
wkbia - 23 Jul 2005 04:47 GMT
I tried updating the tsENG.xml file but can't seem to get a thesaurus search
to return a result other then the key word. car returns car, auto returns
auto. Can you recommend anthing?

The query:

SELECT name
   FROM dbo.categories
   WHERE freetext(name, 'car')

SELECT name
   FROM dbo.categories
   WHERE contains(name, 'FORMSOF(THESAURUS, "car")')

Niether query works.

Here's the xml file.

<XML ID="Microsoft Search Thesaurus">

   <thesaurus xmlns="x-schema:tsSchema.xml">
    <diacritics_sensitive>0</diacritics_sensitive>

       <expansion>
           <sub>Internet Explorer</sub>
           <sub>IE</sub>
           <sub>IE5</sub>
       </expansion>
       <replacement>
           <pat>NT5</pat>
           <pat>W2K</pat>
           <sub>Windows 2000</sub>
       </replacement>
       <expansion>
           <sub>run</sub>
           <sub>jog</sub>
       </expansion>
       <expansion>
           <sub>car</sub>
           <sub>auto</sub>
       </expansion>
   </thesaurus>

</XML>

Thanks again.

> there is no full thesaurus. Basically many people would be upset if they
> started getting unexpected results coming back in their searches. So MS
[quoted text clipped - 8 lines]
> >
> > Wayne
Hilary Cotter - 23 Jul 2005 11:52 GMT
this is the list for UK English, I think you want tsENU.xml  as you seem to
be in AZ.

I tried your xml file and it works for me.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>
> I tried updating the tsENG.xml file but can't seem to get a thesaurus search
[quoted text clipped - 56 lines]
> > >
> > > Wayne
wkbia - 24 Jul 2005 18:39 GMT
I actually found this out after my post. I also just found out that you need
to use the language argument in the sp_fulltext_column procedure as it
doesn't default. Dropping the argument, the procedure seemed to execute
correctly as there was no warning, but it hadn't.

Got it working now... Thank you.

Wish I had a somewhat complete thesarus though, or at least one that I could
modify. Do you or anyone else no where I could get one and preferably free
since I have no capitol at this time.

Thanks again and in advance.

Wayne

> this is the list for UK English, I think you want tsENU.xml  as you seem to
> be in AZ.
[quoted text clipped - 61 lines]
> > > >
> > > > Wayne
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.