Oracle 11g Release 1 (11.1) Oracle Text Application Development

Content

• Introduction
• Document Collection Application
• Directory Information Application
• Document Classification Application
• XML search application
• Summary
• References

Introduction

Oracle full-text search allows you to create text query applications and document classification applications. It provides indexing, text and topic search, and document browsing.

To design an Oracle full-text retrieval application, you must first determine what kind of query you want to perform so as to select the most appropriate index.

Therefore, using Oracle full-text search, we have created the following three applications:

• Document Collection Application
• Directory Information Application
• Document Classification Application

 

Document collection applications

The text query application allows users to search for a document set, such as a Web site, a digital library, or a document repository. This document set is usually static. After the index is initially created, the content does not change significantly. Documents can be any size, any format of HTML, PDF and MS Word documents. These documents are stored in tables. Search by index.

Generally, a query is composed of words or phrases. Users can specify the logical relationship between words AND phrases through such as or and. Other query operators, such as stemming, proximity searching, and wildcarding, are used to improve search results.

An important factor in this type of application is to search for relevant documents as much as possible. The most relevant documents must be listed in the result list.

CONTEXTIndexes provide the best support for such applications. If you search for this indexSELECTStatementWHEREClauseCONTAINSOperator.

Figure 1 text query application

In the document set, a typical text query application allows users to enter a query. The application entersCONTAINSQuery, and return a list that meets the query, called "Hit List )". Results are usually arranged by correlation. Applications allow users to browse one or more documents in the hit list.

For example, an application creates an index for the URLs (HTML file) on WWW and provides the query function through the index set. The hit list returned by an application query is composed of URLs accessible to users.

Describes the process of a text search application for an online e-store:

1. Enter a query.
2. The application runs one program.CONTAINSQuery.
3. The application implements a hit list.
4. Select a document from the hit list.
5. The application displays the document to be viewed.

Figure 2 text search application process

1 2 3 4 Next Page