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.
TutorialThis section provides a step-by-step procedure for setting up and performing text searches by using the module.
Create an etx indexTo create an etx index, you specify the etx access method in the USING clause of the CREATE INDEX statement. You specify the operator class right after specifying the indexed column.
Determine the etx index parametersIndex parameters are used to customize etx indexes based on the type of searches you plan to perform. Although they are not required, index parameters can increase performance in cases where you know the types of searches that will be executed, because the etx index can be built to suit a particular type of search.

Determine the etx index parameters

Index parameters are used to customize etx indexes based on the type of searches you plan to perform. Although they are not required, index parameters can increase performance in cases where you know the types of searches that will be executed, because the etx index can be built to suit a particular type of search.

For example, the WORD_SUPPORT index parameter specifies whether you plan on using exact or pattern-matching searches. The PHRASE_SUPPORT parameter indicates what level of phrase searching you want, from full to no support. Use the CHAR_SET parameter to specify what character set your documents use. Use the STOPWORD_LIST parameter to specify a custom stopword list, while the INCLUDE_STOPWORDS parameter indicates that you want the stopwords specified by the STOPWORD_LIST parameter to be included in the index.