IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Thesaurus search

Thesaurus search is a powerful search-term expansion function in DB2 Net Search Extender. The additional terms you search for are taken from a thesaurus that you build yourself, so you have direct control over the terms. For example, a search for "database", and could find terms like "repository" and "DB2".

Use this type of search for specific areas of interest in which you make frequent searches and produce significantly more effective search results.

See Chapter 10, Using a thesaurus to expand search terms for more information and a description of how to build a thesaurus. The following example demonstrates the syntax for using thesaurus expansion.

This example takes the term "product" and expands it, adding all relations of this term found in the thesaurus "nsesamplethes". Here, "marketing" is added to the search.

SELECT CATEGORY, DATE
        FROM DB2EXT.HTMLTAB
        WHERE CONTAINS(HTMLFILE,
           'THESAURUS "nsesamplethes"
           EXPAND RELATED
           TERM OF "product"') = 1

The next example takes the search term "product". The search then expands with all the synonyms of the search term.

SELECT CATEGORY, DATE
        FROM DB2EXT.HTMLTAB
        WHERE CONTAINS(HTMLFILE,
           'THESAURUS "nsesamplethes"
           EXPAND SYNONYM
           TERM OF "product"') = 1


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]