In the expansion set, you can specify a group of substitutions that are synonyms of each other.įor example, you can edit the expansion section to treat the substitutions "writer", "author", and "journalist" as synonyms. Within this element, you specify one or more substitutions in a element. The thesaurus is defined in a element that contains samples of the child elements that define the diacritics setting, expansion sets, and replacement sets.Ī typical empty thesaurus file contains the following XML text: Įach expansion set is enclosed within an element. However, if a term is already part of a match in the language specific thesaurus file, the term is ineligible for matching in the global thesaurus.Įach thesaurus file defines an XML container whose ID is Microsoft Search Thesaurus, and a comment,, that contains a sample thesaurus. These steps are then repeated for the global thesaurus.The query is expanded to include the language-specific synonyms specified by the expansion set and replacement set rules in the thesaurus file. First, the query looks up the language-specific file and loads it for processing (unless it is already loaded).How full-text queries use the thesaurusĪ thesaurus query uses both a language-specific thesaurus and the global thesaurus. This value can be changed by administrators only. The global thesaurus file corresponds to the Neutral language with LCID 0. HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\\MSSearch\Language\\TsaurusFile For each language, the location of the thesaurus file is specified in the following value in the registry: You can change the location and names of a thesaurus file by changing its registry key. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\\MSSearch\Īn empty global thesaurus file, tsGlobal.xml. The name of the thesaurus file for a given language is specified in the registry in the following value: The default file names of the thesaurus files use following format: A system administrator can customize these files. A separate file is provided for each supported language. Setup installs empty thesaurus files in the above location. This default location contains the following files: The default location of the thesaurus files is: They contain only the top-level XML structure that is common to all SQL Server thesauruses and a commented-out sample thesaurus. SQL Server provides a set of XML thesaurus files, one for each supported language. By default, a thesaurus is accent-insensitive. If the thesaurus is accent-sensitive, full-text search replaces only the pattern "café". If the thesaurus is accent-insensitive, full-text search replaces the patterns "café" and "cafe". For example, suppose you specify the pattern "café" to be replaced by other patterns in a full-text query. For an example, see the section XML Structure of a Replacement Set later in this topic.įor a given thesaurus, all search patterns are either sensitive or insensitive to diacritical marks such as a tilde ( ~), acute accent mark ( ´), or umlaut ( ¨) (that is, accent sensitive or accent insensitive). Queries that contain a match for any synonym in an expansion set are expanded to include every other synonym in the expansion set.įor more information, see XML Structure of an Expansion Set later in this topic.Ī replacement set contains a text pattern to be replaced by a substitution set. Each thesaurus must be manually configured to define the following:Īn expansion set contains a group of synonyms such as "writer", "author", and "journalist" that are substituted for one another by a full-text query. What's in a thesaurusīefore full-text search queries can look for synonyms in a given language, you have to define thesaurus mappings (that is, synonyms) for that language. Thesaurus matching occurs for all FREETEXT and FREETEXTABLE queries and for any CONTAINS and CONTAINSTABLE queries that specify the FORMSOF THESAURUS clause.Ī Full-Text Search thesaurus is an XML text file. By developing a thesaurus tailored to your full-text data, you can effectively broaden the scope of full-text queries on that data. Each thesaurus defines a set of synonyms for a specific language.
SQL Server Full-Text Search queries can search for synonyms of user-specified terms through the use of a Full-Text Search thesaurus. Applies to: SQL Server (all supported versions)
0 kommentar(er)
