Oracle8 ConText Cartridge Administrator's Guide
Release 2.4

A63820-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

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

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 Data Dictionary
ConText Servers
Text Operations
Server Log
Server Shutdown
Personalities
Personality Masks
Loader (R) Personality
DDL (D) Personality
DML (M) Personality
Query (Q) Personality
Linguistic (L) Personality
DBA Personality
Text Request Queue
Query Pipe
DDL Pipe
DML Queue
Services Queue

3 Administering ConText

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

4 ConText Server Executable and Utility

ctxsrv Executable
Syntax
Examples
ctxctl Utility
Syntax
Examples

5 PL/SQL Packages - Administration

CTX_ADM: ConText Administration
CTX_SVC: Services Queue Administration
CTX_INFO: Product Information

Part II Text Setup and Management

6 Text Concepts

Text Operations
Automated Text Loading
DDL
DML
Text/Theme Queries
Linguistics Requests
Text Columns
Supported Datatypes
Textkeys
Composite Textkeys
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 Creation
Index Fragmentation
Memory Allocation
Index Log
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
Thesauri in Queries
Case-sensitivity
Default Thesaurus
Supplied Thesaurus
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

7 Automated Text Loading

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
DIRECTORY READER
Translator Tiles
NULL TRANSLATOR
USER TRANSLATOR
Engine Tiles
GENERIC LOADER

8 ConText Indexing

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
DIRECT
MASTER DETAIL
MASTER DETAIL NEW
OSFILE
URL
Data Store Preference Example
Filtering
Internal Filters
External Filters
Filters for Single-Format Columns
Filters for Mixed-Format Columns
Filter Tiles
BLASTER FILTER
FILTER NOP
HTML FILTER
USER FILTER
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
Stemming
Fuzzy Matching
Soundex
Wordlist Tiles
GENERIC WORD LIST
Wordlist Preference Example
Stop Words
Stop Words in Queries
Case-sensitivity
Stoplist Tiles
GENERIC STOP LIST
Stoplist Preference Example

9 Setting Up and Managing Text

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

10 Text Loading Utility

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

11 PL/SQL Packages - Text Management

CTX_DDL: Text Setup and Management
CTX_DML: ConText Index Update
CTX_THES: Thesaurus Management

Part III Appendices

A Supplied Stoplists

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)

B ConText 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
ConText Data Dictionary Views
CTX_ALL_PREFERENCES
CTX_ALL_SECTIONS
CTX_ALL_SECTION_GROUPS
CTX_ALL_THESAURI
CTX_CLASS
CTX_COLUMN_POLICIES
CTX_INDEX_LOG
CTX_OBJECTS
CTX_OBJECT_ATTRIBUTES
CTX_OBJECT_ATTRIBUTES_LOV
CTX_POLICIES
CTX_PREFERENCES
CTX_PREFERENCE_ATTRIBUTES
CTX_PREFERENCE_USAGE
CTX_SOURCE
CTX_SQES
CTX_SYSTEM_PREFERENCES
CTX_SYSTEM_PREFERENCE_USAGE
CTX_SYSTEM_TEMPLATE_POLICIES
CTX_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_SECTIONS
CTX_USER_SECTION_GROUPS
CTX_USER_SOURCES
CTX_USER_SQES
CTX_USER_TEMPLATE_POLICIES
CTX_USER_THESAURI

C ConText Index Tables and Indexes

ConText Index Tables
DR_nnnnn_I1Tn
DR_nnnnn_KTB
DR_nnnnn_LST
DR_nnnnn_NLT
DR_nnnnn_I1W
Oracle Indexes for ConText Index Tables
SQR Table
DR_nnnnn_SQR
Oracle Index for DR_nnnnn_SQR

D External Filter Specifications

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

Index



Next
Oracle
Copyright © 1998 Oracle Corporation.

All Rights Reserved.

Library

Product

Index