Oracle ConText Cartridge Administrator's Guide
Release 2.0
A54628_01

Contents

Title and Copyright Information

Preface

1 Introduction

What is ConText?

ConText Features

ConText and the Oracle Server

Overview of Administration Tasks

ConText Administration

Text Setup and Management

Linguistics Services Setup

Administration Methods

System Administration Tool

Part I ConText Administration

2 Administration Concepts

Administrator Responsibilities

System Administrator

Database Administrator (DBA)

Predefined ConText Users

ConText Servers

Text Operations

Text Request Queue

Server Shutdown

Personality Masks

Loader (R) Personality

DDL (D) Personality

DML (M) Personality

Query (Q) Personality

Linguistic (L) Personality

DBA Personality

Text Request Queue

Administration Pipes

Pending Table (DRQ_PENDING)

In-Progress Table (DRQ_INPROG)

Queue Management

Services Queue Table (CTX_SVCQ)

Queue Management

3 Administering ConText

Creating ConText Users

Granting ConText Roles to Users

Granting EXECUTE Privileges to Users

Managing ConText Servers

Starting ConText Servers

Viewing the Status of ConText Servers

Changing the Personality Masks of ConText Servers

Shutting down ConText Servers

Managing ConText Queues

Viewing the DML Queue

Viewing the Services Queue

Removing Requests from the Services Queue

Enabling and Disabling Queues

Part II Text Setup and Management

4 Text Concepts

Text Operations

Text/Theme Queries

Linguistic Services

Composite Textkeys

Loading Text Strings

Automated Batch Loading

External Storage

Master/Detail Storage

Text Stored as File Names

Text Stored as URLs

Document Access Using HTTP

Internal Filters

External Filters

Filtering for Single-Format Columns

Filtering for Mixed-Format Columns

ConText Indexes

ConText Index Tables

Stages of ConText Indexing

Index Fragmentation

Memory Allocation

Indexing in Parallel

Index Optimization

Columns with Theme and Text Indexes

Text Indexing Policies

What's in a Text Index

Theme Indexing Policies

Linguistic Settings

What's in a Theme Index

Index Fragmentation

ConText Servers for Theme Indexing and Theme Queries

Base-letter Conversion

Hierarchical Relationships

Thesaural Maintenance

Query Expansion

5 Understanding the ConText Data Dictionary

6 Setting Up and Managing Text

Using ConText Servers for Automated Text Loading

Generating Document Textkeys

Managing Preferences

Creating a Preference

Creating an Engine Preference

Creating a Theme Lexer Preference

Creating a Stoplist Preference

Creating Filter Preferences

Deleting a Preference

Managing Policies

Creating a Column Policy

Creating a Theme Indexing Policy

Using Composite Textkeys in a Policy

Creating a Template Policy

Modifying a Policy

Deleting a Policy

Managing Indexes

Creating an Index

ConText Indexing in Parallel

Indexing Existing Columns (Hot Upgrade)

Updating an Index

Dropping an Index

Optimizing an Index

Resuming Index Creation/Optimization

Managing Thesauri

Creating a Thesaurus

Creating/Updating a Thesaurus Entry

Deleting a Thesaurus

Creating a Thesaurus Output File

Part III Configuration and Tuning

7 Configuring ConText

Resource Considerations

Parallel Processing

Linguistic Services

Client Requirements

ConText Components

Sample ConText Configurations

Consolidated Server Processing

Distributed Server Processing

Optimized Linguistic Services Processing

Reducing I/O Contention

Using Raw Partitions

8 Tuning ConText

Indexing Tuning

Temporary Segment and SORT_AREA_SIZE Size

Memory Allocation

Batch Versus Immediate DML

Parallel Processing

Index Optimization

Network Considerations

Result Tables in Two-Step Queries

Matching Servers to Numbers of Users

Part IV Reference

9 Executables and Utilities

ctxsrv/ctxsrvx Executables

ctxload Utility

Thesaurus Importing and Exporting

Text Load Example

Thesaurus Import Example

Thesaurus Export Example

Structure of Text Load File

Structure of Thesaurus Import File

Loading Text into External Data Store Columns

10 ConText Data Dictionary

Tiles, Tile Attributes, and Attribute Values: Indexing

Data Store Category

Filter Category

Engine Category

Wordlist Category

Stoplist Category

Tiles, Tile Attributes, and Attribute Values: Text Loading

Reader Category

Engine Category

Translator Category

Predefined and Default Preferences: Indexing

Data Store Category

Filter Category

Engine Category

Wordlist Category

Stoplist Category

Predefined and Default Preferences: Text Loading

Reader Category

Engine Category

Translator Category

Template Policies

TEMPLATE_DIRECT

TEMPLATE_LONGTEXT_STOPLIST_OFF

TEMPLATE_LONGTEXT_STOPLIST_ON

TEMPLATE_MD_BIN

Supported Formats for Mixed-Format Columns

11 PL/SQL Packages

CTX_ADM: ConText Administration

CHANGE_MASK

GET_QUEUE_STATUS

RECOVER

SET_QUERY_BUFFER_SIZE

SHUTDOWN

UPDATE_QUEUE_STATUS

CTX_SVC: Services Queue Administration

CANCEL
CANCEL_ALL
CANCEL_USER
CLEAR_ALL_ERRORS
CLEAR_ERROR
CLEAR_INDEX_ERRORS
CLEAR_LING_ERRORS
REQUEST_STATUS

CTX_DDL: Text Setup and Management

CLEAR_ATTRIBUTES
CREATE_INDEX
CREATE_POLICY
CREATE_PREFERENCE
CREATE_SOURCE
CREATE_TEMPLATE_POLICY
DROP_INDEX
DROP_INTTRIG
DROP_POLICY
DROP_PREFERENCE
DROP_SOURCE
OPTIMIZE_INDEX
RESUME_FAILED_INDEX
SET_ATTRIBUTE
UPDATE_POLICY
UPDATE_SOURCE

CTX_DML: ConText Index Update and Management

REINDEX
SYNC
SYNC_QUERY

CTX_THES: Thesaurus Management

CREATE_PHRASE

CREATE_THESAURUS

DROP_THESAURUS

CTX_INFO: Product Information

GET_INFO
GET_STATUS
GET_VERSION

Part V Appendices

A ConText Server and Queue Views

ConText Server Views

CTX_ALL_SERVERS
CTX_SERVERS

ConText Queue Views

CTX_ALL_DML_QUEUE
CTX_ALL_DML_SUM
CTX_ALL_QUEUE
CTX_INDEX_ERRORS
CTX_INDEX_STATUS
CTX_LING_ERRORS
CTX_USER_DML_QUEUE
CTX_USER_DML_SUM
CTX_USER_QUEUE
CTX_USER_SVCQ

B ConText Data Dictionary Views

CTXADMIN Views

CTX_COLUMN_POLICIES
CTX_INDEX_LOG
CTX_POLICIES
CTX_PREFERENCES
CTX_PREFERENCE_ATTRIBUTES
CTX_PREFERENCE_USAGE
CTX_SQES
CTX_TEMPLATE_POLICIES

CTXAPP Views

CTX_CLASS
CTX_OBJECTS
CTX_OBJECT_ATTRIBUTES
CTX_OBJECT_ATTRIBUTES_LOV
CTX_SYSTEM_PREFERENCES
CTX_SYSTEM_PREFERENCE_USAGE
CTX_SYSTEM_TEMPLATE_POLICIES
CTX_USER_COLUMN_POLICIES
CTX_USER_INDEX_LOG
CTX_USER_POLICIES
CTX_USER_PREFERENCES
CTX_USER_PREFERENCE_ATTRIBUTES
CTX_USER_PREFERENCE_USAGE
CTX_USER_SQES
CTX_USER_TEMPLATE_POLICIES

CTXUSER Views

CTX_ALL_THESAURI
CTX_USER_THESAURI

C ConText Index Tables and Indexes

ConText Index Tables

DR_nnnnn_I1Tn
DR_nnnnn_KTB
DR_nnnnn_LST
DR_nnnnn_I1W

Oracle Indexes for ConText Index Tables
SQR Table

DR_nnnnn_SQR
Oracle Index for DR_nnnnn_SQR

Index

Next

Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library
Product
Index