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.

Phrase searches

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

The module search supports two types of phrase searches: exact phrase search and approximate phrase search.

Important: Exact and approximate phrase searches can be performed only on columns whose etx indexes were created with the PHRASE_SUPPORT index parameter. You encounter an error if you search for a phrase in a column whose index was not created with PHRASE_SUPPORT.