Oracle ConText Cartridge Administrator's Guide
Release 2.0

A54628_01

Library

Product

Index

Next

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
Command-line
System Administration Tool

Part I ConText Administration

2 Administration Concepts

Administrator Responsibilities
System Administrator
Database Administrator (DBA)
ConText Roles
CTXADMIN Role
CTXAPP Role
CTXUSER Role
Predefined ConText Users
CTXSYS User
CTXDEMO User
ConText Servers
Text Operations
Text Request Queue
Server Log
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
Query Pipe
DDL Pipe
DML Queue
Pending Table (DRQ_PENDING)
In-Progress Table (DRQ_INPROG)
Timestamps
Error Handling
Queue Management
Services Queue
Services Queue Table (CTX_SVCQ)
Error Handling
Queue Management

3 Administering ConText

Managing Users
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 Loading
DDL
DML
Text/Theme Queries
Linguistic Services
Text Columns
Textkeys
Composite Textkeys
Text Loading
Loading Text Strings
Batch Loading
Automated Batch Loading
Error Handling
Text Storage
Direct Storage
External Storage
Master/Detail Storage
External Text
Text Stored as File Names
Text Stored as URLs
Document Access Using HTTP
Text Filtering
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 Updates
Index Log
Index Optimization
Columns with Theme and Text Indexes
Text Indexes
Lexer
Text Indexing Policies
What's in a Text Index
DDL and DML
Theme Indexes
Theme Lexer
Theme Indexing Policies
Linguistic Settings
What's in a Theme Index
Index Fragmentation
DDL and DML
ConText Servers for Theme Indexing and Theme Queries
Base-letter Conversion
Text Indexing
Text Queries
Thesauri
Synonyms
Hierarchical Relationships
Related Terms
Scope Notes
Thesaural Maintenance
Query Expansion

5 Understanding the ConText Data Dictionary

The ConText Data Dictionary
Categories
Data Store Category
Filter Category
Lexer Category
Engine Category
WordList Category
Stoplist Category
Tiles
Indexing Categories
Text Loading Categories
Tile Attributes
Preferences
Preference Components
Predefined Preferences
Default Preferences
Policies
Policy Examples
Multiple Policies on a Column
Policy Attributes
Preferences in Policies
Template Policies
Sources
Source Attributes
Preferences in Sources

6 Setting Up and Managing Text

Loading Text
Using ctxload
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
Virtual memory
Indexing
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
Query Tuning
Result Tables in Two-Step Queries
Matching Servers to Numbers of Users

Part IV Reference

9 Executables and Utilities

ctxsrv/ctxsrvx Executables
Syntax
Examples
ctxctl Utility
Syntax
Examples
ctxload Utility
Text Loading
Thesaurus Importing and Exporting
Syntax
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
Lexer 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
Lexer Category
Engine Category
Wordlist Category
Stoplist Category
Predefined and Default Preferences: Text Loading
Reader Category
Engine Category
Translator Category
Template Policies
DEFAULT_POLICY
TEMPLATE_AUTOB
TEMPLATE_DIRECT
TEMPLATE_LONGTEXT_STOPLIST_OFF
TEMPLATE_LONGTEXT_STOPLIST_ON
TEMPLATE_MD
TEMPLATE_MD_BIN
TEMPLATE_WW6B
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
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Index