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 score field of etx_ReturnTypeYou can also limit the number of rows returned by setting a document score standard in the score field of the etx_ReturnType.

The score field of etx_ReturnType

You can also limit the number of rows returned by setting a document score standard in the score field of the etx_ReturnType.

The following query specifies that only those documents that have a document score of 85 or better are to be returned:

SELECT rc.score, id, description FROM videos
    WHERE etx_contains ( description,
    Row('multimedia document editor' , 
        'PATTERN_TRANS & PATTERN_SUBS'),
    rc # etx_ReturnType) AND
    rc.score > 85 ;

See Document scoring for fuzzy searches for an additional example of how to rank rows using the rc.score SLV and an ORDER BY clause.