Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Excalibur Text Search DataBlade® Module User's GuideThese topics describe the module and how to access and use its components.
ConceptsThis section describes the different types of searches you can perform with the module and characterizes how the text search engine assigns word scores and document scores.
Perform fuzzy searchesA fuzzy search is a search for text that matches your clue closely instead of exactly. Fuzzy searches can also be referred to as pattern searches. Fuzzy searches help you return results of interest even when the search terms themselves are misspelled in the documents you are searching.
Limit the number of rows a fuzzy search returnsAt times, you might find that the search engine returns more information than you require. Use the MAX_MATCHES and WORD_SCORE tuning parameters to limit the number of rows that the search engine returns.
The WORD_SCORE tuning parameterYou can also limit the number of pattern matches with the WORD_SCORE tuning parameter. Word score determines whether words are considered hits.

The WORD_SCORE tuning parameter

You can also limit the number of pattern matches with the WORD_SCORE tuning parameter. Word score determines whether words are considered hits.

Assigning a high value to WORD_SCORE results in fewer hits; assigning a low value to WORD_SCORE results in more, less exact matches. You can specify a high word score standard to limit the number of words that are considered matches, as shown in an earlier example and repeated here:

SELECT id, description FROM videos
    WHERE etx_contains ( description,
    Row('multimedia document editor' , 
        'PATTERN_TRANS & PATTERN_SUBS & WORD_SCORE = 85'));

For a multiword clue, however, you have no way of knowing what the word score is for any one of the clues, so you might get unexpected results.