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.

Excalibur text search types

The 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.

Use the SEARCH_TYPE tuning parameter to indicate what search you want to perform. A tuning parameter is a variable that you use to guide the way in which the text search engine performs a search. You pass this parameter to the search engine as the second input parameter of the Row() constructor of the etx_contains() operator.

The following sections provide examples of different types of searches. The examples use the same videos table described in Overview. Refer to The etx_contains() operator for a full list of supported tuning parameters.