Extensions to Informix

The Informix® Excalibur Text Search DataBladeModule provides four kinds of objects to extend your Informix database server: the etx access method, the filter utility, the etx_contains() operator, and text search routines.

The etx access method allows you to call on the Excalibur Text Retrieval Library to create indexes that support sophisticated searches on table columns that contain text. The indexes that you create with the etx access method are called etx indexes.

To take advantage of the etx access method, you must store the data you want to search—called search text—in a column of type IfxDocDesc, BLOB, CLOB, CHAR, VARCHAR, or LVARCHAR. The first data type in this list, IfxDocDesc, is a data type designed specifically for use with text access methods. The most popular data types for large documents are BLOB and CLOB.

When you store your documents in a column, you do not need to convert them from their proprietary format into ASCII when creating an etx index; the Informix Excalibur Text Search DataBlade Module does this for you. One of the components of the Informix Excalibur Text Search DataBlade Module is a filtering utility that recognizes a number of document formats and converts them into ASCII form whenever needed.

You use the etx_contains() operator within SELECT statements to perform searches of etx indexes.

In addition to the etx_contains() operator, the Informix Excalibur Text Search DataBlade Module supplies several routines that you can use to perform tasks such as creating and dropping synonym and stopword lists.

For more information, see the Excalibur Text Search DataBlade Module User's Guide.