ArcGIS Server Banner

Configuring a database to support XML columns

Configuring a database to support XML columns

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
One reason to set up full-text indexing in your database is to use ArcSDE XML columns such as with an ArcIMS Metadata Service. The database indexes and searches XML documents using its text indexing capabilities.

Beginning with 9.3, ArcSDE XML columns are supported in DB2 (except on z/OS), Informix, Oracle, PostgreSQL, and SQL Server. Each database requires text indexing functionality to be installed and configured to create an XML column.

In addition to enabling full text indexing, there are other DBTUNE configuration settings that need to be considered that will affect the language, storage, searching, and maintenance of an ArcSDE XML column. Definitions for these parameters can be found in the configuration parameter topics for each DBMS. Once an XML column has been created, many of its configuration settings can't be changed. Use the links below to learn about configuring a database to support text indexing and text searches.

If the XML column will store documents written in a language other than the default for your DBMS, both the database text indexing components and the DBTUNE settings must be properly configured for your language. The following information can be found in the DBMS-specific "Configuring <DBMS> database to support XML" topics.


DB2 Installing and configuring Net Search Engine
Informix Installing text search DataBlade modules

Configuring the database to search the contents of an XML column
Oracle Installing and configuring the text component for Oracle

Configuring the database to search the contents of an XML column
PostgreSQL Configuring the database to search the contents of an XML column
SQL Server Installing and configuring the full-text search engine in SQL Server 2000

Installing and configuring the full-text search engine in SQL Server 2005

Installing and configuring the full-text search engine in SQL Server 2005 Express licensed for ArcGIS Server Enterprise

Installing and configuring the full-text search engine in SQL Server 2005 Express licensed for ArcGIS Server Workgroup

Configuring the database to search the contents of an XML column

Managing database text indexes

See Also

  • XML columns in the geodatabase