ArcSDE XML columns require you install the Excalibur Text Search (ETX) DataBlade Module, which is available for Informix Dynamic Server (IDS) Version 9.4 and above. You then create XML columns, create text indexes on the columns, set up a metadata service user account, and configure the database.
After everything is set up, you need to maintain the text index and text tag indexes.
These steps are described in the following sections.
To enable text indexing and metadata services, you must register three DataBlade Modules in your Informix database. These modules are as follows:
- Large Object Locator (LLD) DataBlade module
- Text Descriptor (TXT) DataBlade module
- Excalibur Text Search (ETX) DataBlade module
orBasic Text Search (BTS) DataBlade module
The first two modules must be registered prior to registering either the Excalibur Text Search DataBlade module or the Basic Text Search module.
For further information on installation and configuration of the Excalibur Text Search DataBlade module or Basic Text Search DataBlade module, please review that product's user's guide and release notes.
Once the necessary DataBlade modules are installed and registered in your database, text indexes are created anytime the SQL CREATE INDEX statement includes an etx value. For example,
CREATE INDEX myxmldoc1 ON sde_xml_doc1 (xml_doc_val etx_clob_ops) USING etx ( CHAR_SET='ISO',PHRASE_SUPPORT='MEDIUM' ) IN mylsbspace
The following three configuration parameters must be set to perform text indexing and use a metadata service:
- XML_IDX_FULLTEXT_TYPE
- XML_IDX_FULLTEXT_PARAMS
- XML_IDX_FULLTEXT_STORAGE
The Smart BLOB space you specify for the XML_IDX_FULLTEXT_STORAGE parameter must be logged. If such a Smart BLOB space does not exist, you must create one.
You can optionally specify storage information for the other XML configuration parameters. However, if you don't set values for the DATA_DICTIONARY parameters (XML_INDEX_TAGS_INDEX and XML_INDEX_TAGS_TABLE) prior to creating the ArcSDE geodatabase, the index tags table and index get created in the same DBspace as the geodatabase.
For a description of all the XML configuration parameters for geodatabases in Informix, see
Informix dbtune configuration parameters.
