Oracle Context Option Administrator's Guide | ![]() Library |
![]() Product |
![]() Contents |
![]() Index |
The topics covered in this chapter are:
By installing ConText Option with an Oracle server, client tools such as SQL*Plus, Oracle Forms, and Pro*C are able to retrieve and manipulate text in an Oracle database. Most tools which can call an Oracle stored procedure can perform text queries and other text operations.
ConText Option manages textual data in concert with traditional datatypes in an Oracle database. When text is inserted, updated, or deleted, ConText Option automatically manages the change.
ConText Option can be used in both dedicated server (one server process for each user process) and multi-threaded server environments (dispatcher, shared server, and background processes).
For more information about the Oracle server model, see Oracle7 Server Concepts.
Figure 1. Example of the ConText Option Process Model
Figure 1 shows ConText servers and the Text Request Queue working in concert with an Oracle server process in a dedicated server environment.
In the standard Oracle server model, when a user process connects to the database, it spawns a dedicated server process which handles all incoming requests from the user process.
With ConText Option, if a request comes in that includes a text operation, the text operation portion of the request is sent to the Text Request Queue for processing by the next available ConText server processes.
For example, a query is submitted for both structured data and text. The query is picked up by the Oracle server process via the Request Queue. The Oracle server process divides up the query, sends the text query portion to the Text Request Queue, and processes the structured data portion.
The first available ConText server picks up the text query from the Text Request Queue and processes it. The results from the text query are combined with the results from the structured data query and returned to the user process as a single set of results.
Figure 2. ConText Option Administration Tasks
Administration is divided into three areas:
The tasks in the three areas may be performed by a single user or may be divided between different users/responsibilities.
For more information about each of the text setup and management tasks, see "Setting Up and Managing Text (Chapter 5)."
For example, loading text into the database requires access to the appropriate tables.
In addition, creating indexes requires ConText servers to be running with the appropriate designation and only ConText Option administrators can manage ConText servers.
However, some tasks, such as defining policies and preferences, may be performed by application developers because the options used to create a index have an effect on how an application retrieves text.
Text setup and management includes the following tasks:
For more information about the Linguistic Services, see Oracle ConText Option Application Developer's Guide
For example, the ConText Option administrator may be responsible for setting up all of the preferences and policies in the system, including policies that are used for theme indexing or requesting the Linguistic Services for documents.
On the other hand, application developers may be responsible for creating custom setting configurations as part of the process of creating linguistic output for use in applications.
Most of the administration tasks can be accomplished using either method; however, some tasks can only be accomplished using one or the other method.
For example, custom setting configurations for the ConText Option Linguistic Services can only be created/modified in the administration tool. As a result, if you want to use custom settings for the Linguistic Services, you must use both the administration tool and the command-line to administer ConText Option.
All remaining ConText Option administration tasks, such as shutting down ConText servers, managing queues, and creating indexes, can be performed in SQL*Plus or PL/SQL, either on the server machine or on any other machine that has SQL*Plus and PL/SQL and is connected to the server machine through SQL*Net.
The administration tool is distributed with the Oracle ConText Option Workbench, which can be installed on any PC running Microsoft Windws NT or Windows 95.
![]() ![]() Prev Next |
![]() Copyright © 1996 Oracle Corporation. All Rights Reserved. |
![]() Library |
![]() Product |
![]() Contents |
![]() Index |