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.
Excalibur text search typesThe module supports various searches, such as keyword, Boolean, proximity, pattern (or fuzzy), and phrase. Phrase searching can be classified into two types: exact and approximate.
Phrase searchesA phrase is any clue that contains more than one word. In a phrase search, the text search engine treats the whole phrase as a single unit.
Approximate phrase searchesAn approximate phrase search returns all phrases in the search text that contain words that are approximately the same as the words you specify in the clue.

Approximate phrase searches

An approximate phrase search returns all phrases in the search text that contain words that are approximately the same as the words you specify in the clue.

To execute an approximate phrase search, set the SEARCH_TYPE tuning parameter to PHRASE_APPROX, as shown in the following example:

SELECT * FROM videos
    WHERE etx_contains(description,
    Row ('document editor','SEARCH_TYPE = PHRASE_APPROX'));

Use an approximate phrase search when you want to search for a phrase, but you do not know or remember all the words in a phrase. Use an exact phrase search with pattern matching if you know all of the words in a phrase, but are not sure how one or more of the words in the phrase is spelled.

Restriction: Do not set SEARCH_TYPE to PHRASE_APPROX and pass the PATTERN_BASIC or PATTERN_ALL tuning parameters for the same search. The resulting query might perform poorly.