Oracle8 ConText Cartridge

What is ConText?

ConText Features

ConText and the Oracle Server

Overview of ConText Functions

ConText Administration

Text Loading

Indexing

Administration Methods

Command-line

Administration Tools

Administrator Responsibilities

System Administrator

Database Administrator (DBA)

ConText Roles

CTXADMIN Role

CTXAPP Role

CTXUSER Role

Predefined ConText Users

CTXSYS User

CTXDEMO User

ConText Data Dictionary

ConText Servers

Personalities

Loader (R) Personality

DDL (D) Personality

DML (M) Personality

Query (Q) Personality

Linguistic (L) Personality

DBA Personality

Text Request Queue

Enabling One-step Queries

Setting TEXT_ENABLE for All Users

Setting TEXT_ENABLE for the Session

Managing Users

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

ctxsrv Executable

ctxctl Utility

CTX_ADM: ConText Administration

CTX_SVC: Services Queue Administration

CTX_INFO: Product Information

Text Operations

Automated Text Loading

DDL

DML

Text Columns

Text Loading

Individual Row Insert/Update/Export

Batch Load

Automated Text Load

Client-side Insert/Update/Export

ConText Indexes

Text Indexes

Theme Indexes

ConText Index Tables

Columns with Multiple Indexes

Index Updates (DML)

Immediate Vs. Batch Update

Deferred Deletion

Index Optimization

Compaction of Index Fragments

Removal of Obsolete Document References

Piecewise Optimization

When to Optimize

Thesauri

Thesaurus Creation and Maintenance

Thesaurus Entries and Relationships

Synonyms

Hierarchical Relationships

Related Terms

Scope Notes

Document Sections

Section Searching

Sentences and Paragraphs as Sections

User-Defined Sections

Section Groups

Setup Process for Section Searching

Overview of Automated Loading

ConText Servers

Text Loading Utility (ctxload)

Error Handling

Sources

Preferences for Text Loading

What is a Text Loading Preference?

Reader Predefined Preferences

Translator Predefined Preferences

Engine Predefined Preferences

Reader Tiles

Translator Tiles

Engine Tiles

Overview of Indexing

Policies

What is a Policy?

Policy Examples

Predefined Template Policies

Preferences for Indexing

What is an Indexing Preference?

Data Store Predefined Preferences

Filter Predefined Preferences

Lexer Predefined Preferences

Engine Predefined Preferences

Wordlist Predefined Preferences

Stoplist Predefined Preferences

Data Storage

Direct Storage

Master-Detail Storage

External Storage (Operating System Files)

External Storage (URLs)

Data Store Tiles

URL

Data Store Preference Example

Filtering

Internal Filters

External Filters

Filters for Single-Format Columns

Filters for Mixed-Format Columns

Filter Tiles

Filter Preference Examples

Lexers

Text Lexers

Theme Lexer

Base-letter Conversion

NLS Compliance

Composite Word Indexing

Lexer Tiles

BASIC LEXER

CHINESE V-GRAM LEXER

JAPANESE V-GRAM LEXER

KOREAN LEXER

THEME LEXER

Lexer Preference Examples

Indexing Engine

Engine Tiles

ENGINE NOP

GENERIC ENGINE

Engine Preference Example

Advanced Query (Wordlist) Options

Wordlist Tiles

Wordlist Preference Example

Stop Words

Stop Words in Queries

Case-sensitivity

Stoplist Tiles

GENERIC STOP LIST

Stoplist Preference Example

Loading Text

Using ctxload

Using ConText Servers for Automated Text Loading

Generating Document Textkeys

Updating/Exporting a Document

Managing Policies

Creating a Template Policy

Creating a Column Policy

Creating a Column Policy for an Object Table

Creating a Column Policy for Theme Indexing

Using Composite Textkeys in a Column Policy

Modifying a Policy

Deleting a Policy

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 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 the Supplied Thesaurus

Creating/Updating a Thesaurus Entry

Deleting a Thesaurus

Creating a Thesaurus Output File

Managing User-defined 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

Overview of ctxload

Text Loading

Document Updating/Exporting

Thesaurus Importing and Exporting

Command-line Syntax

Mandatory Arguments

Optional Arguments

Usage Notes

Command-line Examples

Text Load Example

Document Update Example

Document Export Examples

Thesaurus Import Example

Thesaurus Export Example

Structure of Text Load File

Load File Structure

Load File Syntax

Example of Embedded Text in Load File

Example of File Name Pointers in Load File

Structure of Thesaurus Import File

Alternate Hierarchy Structure

Import File Structure for Terms

Import File Structure for Relationships

Examples of Import Files

CTX_DDL: Text Setup and Management

CTX_DML: ConText Index Update

CTX_THES: Thesaurus Management

Creating a Supplied Stoplist

Editing the Scripts

Running the Scripts

English

Danish (DA)

Dutch (NL)

Finnish (FI)

French (FR)

German (DE)

Italian (IT)

Portuguese (PR)

Spanish (ES)

Swedish (SE)

ConText Server Views

CTX_ALL_SERVERS

CTX_SERVERS

ConText Queue Views

ConText Data Dictionary Views

ConText Index Tables

Oracle Indexes for ConText Index Tables

SQR Table

DR_nnnnn_SQR

Oracle Index for DR_nnnnn_SQR

Supported Formats for Mixed-Format Columns

Supplied External Filters

Availability of Filters

List of Filters

Supplied External Filters Installation

Supplied External Filter Setup

Supplied External Filter Usage

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

Part I ConText Administration

2 Administration Concepts

3 Administering ConText

4 ConText Server Executable and Utility

5 PL/SQL Packages - Administration

Part II Text Setup and Management

6 Text Concepts

7 Automated Text Loading

8 ConText Indexing

9 Setting Up and Managing Text

10 Text Loading Utility

11 PL/SQL Packages - Text Management

Part III Appendices

A Supplied Stoplists

B ConText Views

C ConText Index Tables and Indexes

D External Filter Specifications

Index