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.
Word scoring for fuzzy searchesIf you have created an index with the WORD_SUPPORT = PATTERN index parameter, the search engine considers words that match your clue approximately and that match your clue exactly. The search engine uses fuzzy logic to determine whether a pattern match is considered a hit. It assigns a word score to candidate matches based on its internal rules.
Substitution and transpositionThis section discusses the simplest example of a fuzzy search: a search that takes into account misspellings in both the clue and the search text.

Substitution and transposition

This section discusses the simplest example of a fuzzy search: a search that takes into account misspellings in both the clue and the search text.

Misspellings most frequently occur when letters in a word are mistakenly substituted or transposed. Misspelling editor as editer is an example of substitution; misspelling multimedia as mulitmedia is an example of transposition. Transposition means switching the order of two adjacent characters.