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.
Database Extensions User's GuideThe HCL OneDB™ Database Extensions User's Guide explains how to use the database extensions that come with HCL OneDB™: Large Object Locator, MQ messaging, binary data types, basic text search, node data type, HCL OneDB™ web feature service for Geospatial Data, and SQL packages.
Basic Text SearchYou can perform basic text searching for words and phrases in a document repository stored in a column of a table.
Preparing for basic text searchingBefore you can perform basic text searching, you must prepare the server environment and create the bts index. Review the requirements and restrictions.
Creating a bts indexYou create a bts index by using the bts access method and specifying index parameters and other options.
bts access method syntaxThe bts access method is a secondary access method to create indexes that support basic text search queries.
field_token_max index parameterIf you have large documents, you can increase the maximum number of tokens that are indexed by setting the field_token_max index parameter to a positive integer up to 2 000 000 000. By default, 10 000 tokens are indexed in a document. If the average word has 5 characters, approximately 50-60 KB of the document is indexed.

field_token_max index parameter

If you have large documents, you can increase the maximum number of tokens that are indexed by setting the field_token_max index parameter to a positive integer up to 2 000 000 000. By default, 10 000 tokens are indexed in a document. If the average word has 5 characters, approximately 50-60 KB of the document is indexed.

Example

For example, the following statement creates a bts index that creates up to 500 000 tokens per document:

CREATE INDEX books_bts ON books(book_data bts_lvarchar_ops) 
USING bts(field_token_max="500000") IN bts_sbspace;