Oracle8 ConText Cartridge Administrator's Guide
Release 2.3
A58165-01

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

What is ConText?

ConText Features

ConText and the Oracle Server

Overview of Administration Tasks

ConText Administration

Text Setup and Management

Linguistics Setup

Administration Methods

Administration Tools

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)

Waiting Table (DRQ_WAITING)

Batches Table (DRQ_BATCHES)

Queue Management

Services Queue Table (CTX_SVCQ)

Queue Management

3 Administering ConText

Enabling One-step Queries

Setting TEXT_ENABLE for All Users

Setting TEXT_ENABLE for the Session

Creating ConText Users

Granting ConText Roles to Users

Granting EXECUTE Privileges to Application Developers

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

4 ConText Server Executables and Utilities

ctxsrv Executable

5 PL/SQL Packages - Administration

Part II Text Setup and Management

6 Text Concepts

The ConText Data Dictionary

Text Operations

Text/Theme Queries

Linguistics Requests

Supported Datatypes

Composite Textkeys

Plain Text Loading

Automated Batch Loading

External Storage

Master-Detail Storage

Text Stored as File Names

Text Stored as URLs

Document Access Using HTTP or FTP

Internal Filters

External Filters

Filters for Single-Format Columns

Filters for Mixed-Format Columns

Supported External Filter Formats for Mixed-Format Columns

Supplied External Filters

ConText Indexes

ConText Index Tables

Stages of ConText Indexing

Columns with Multiple Indexes

Index Fragmentation

Memory Allocation

Parallel Indexing

Index Optimization

What's in a Text Index?

What's in a Theme Index?

Linguistic Settings

Index Fragmentation

Base-letter Conversion

Thesaural Maintenance

Case-sensitivity

Query Expansion

Types of Thesaural Relationships

Hierarchical Relationships

Document Sections

Startjoin and Endjoin Characters

Document Section Setup

Predefined HTML Section Group and Sections

Section Searching

7 Understanding the ConText Data Dictionary: Indexing

What is a Policy?

Column Policies

Template Policies

Text Indexing Policies

Theme Indexing Policies

Policy Examples

Policy Attributes

Preferences in Policies

Predefined Template Policies

Preferences for Indexing

What is an Indexing Preference?

What is a Tile?

Data Store Predefined Preferences

Filter Predefined Preferences

Lexer Predefined Preferences

Engine Predefined Preferences

Wordlist Predefined Preferences

Stoplist Predefined Preferences

Data Store Tiles

List of Data Store Tiles and Attributes

MASTER DETAIL Tile

MASTER DETAIL NEW Tile

Data Store Example

List of Filter Tiles and Attributes

BLASTER FILTER Tile

FILTER NOP Tile

HTML FILTER Tile

USER FILTER Tile

Filter Examples

List of Lexer Tiles and Attributes

BASIC LEXER Tile

CHINESE V-GRAM LEXER Tile

JAPANESE V-GRAM LEXER Tile

KOREAN LEXER Tile

THEME LEXER Tile

List of Engine Tiles and Attributes

ENGINE NOP Tile

GENERIC ENGINE Tile

List of Wordlist Tiles and Attributes

GENERIC WORD LIST Tile

Wordlist Example

List of Stoplist Tiles and Attributes

GENERIC STOP LIST Tile

Stoplist Example

8 Understanding the ConText Data Dictionary: Text Loading

What is a Source?

Source Attributes

Preferences in Sources

Preferences for Text Loading

What is a Text Loading Preference?

Reader Predefined Preferences

Engine Predefined Preferences

Translator Predefined Preferences

DIRECTORY READER Tile

GENERIC LOADER Tile

Translator Tiles

NULL TRANSLATOR Tile

USER TRANSLATOR Tile

9 Setting Up and Managing Text

Using ConText Servers for Automated Text Loading

Generating Document Textkeys

Updating/Exporting a Document

Managing Preferences

Creating a Preference

Creating an Engine Preference

Creating a Data Store Preference for a Master Table

Creating Filter Preferences

Creating a Theme Lexer Preference

Creating a Stoplist Preference

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 a Case-sensitive Thesaurus

Creating/Updating a Thesaurus Entry

Deleting a Thesaurus

Creating a Thesaurus Output File

Managing Document Sections

Creating a Section Group

Creating a Section

Creating a Wordlist Preference with a Section Group

Creating a Policy for a Section Group

Viewing Sections and Section Groups

Removing a Section from a Section Group

Dropping a Section Group

10 Text Loading Utility

11 PL/SQL Packages - Text Management

Part III Appendices

A Supplied Stoplists

English Stoplist

French Stoplist

German Stoplist

Italian Stoplist

Spanish Stoplist

B ConText Views

ConText Server Views

CTX_ALL_SERVERS

ConText Queue Views

CTX_ALL_DML_QUEUE

CTX_ALL_DML_SUM

CTX_INDEX_ERRORS

CTX_INDEX_STATUS

CTX_LING_ERRORS

CTX_USER_DML_QUEUE

CTX_USER_DML_SUM

ConText Data Dictionary Views

C ConText Index Tables and Indexes

ConText Index Tables

Oracle Indexes for ConText Index Tables

Oracle Index for DR_nnnnn_SQR

Copyright © 1997 Oracle Corporation.
All Rights Reserved.