Using Oracle Text

The ora:contains() function is easy to use but not a good choice for large datasets or frequent full-text queries because run-time full-text analysis is a very resource-intensive process. Instead, for a large XML dataset, you need to create a full-text index using Oracle Text. Oracle Text is known as Oracle InterMedia Text in Oracle8i. One of the Oracle Text indexes, the CONTEXT index, can be used to enable full-text search.

Image

FIGURE 10-1. Oracle Text indexing process

Figure 10-1 illustrates the Oracle Text indexing process. Each step in the process is configurable.

First, the data is fetched from database tables or external ...

Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial