Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction to interMedia Text

What is Oracle8i interMedia Text?

Building Your Text Application

Code Samples Directory

interMedia Text Users and Roles

CTXSYS User

CTXAPP Role

Loading Documents

Supported Column Types

Supported Document Formats

Loading Methods

Indexing

General Defaults for All Languages

Language Specific Defaults

Index Maintenance

Querying

Word Query Example

ABOUT Query Example

Optimizing Query for Response Time

Other Query Features

Document Presentation and Highlighting

2 SQL Commands

ALTER INDEX

DROP INDEX

CONTAINS

CREATE INDEX

SCORE

3 Indexing

Overview

Creating Preferences

Datastore Objects

DIRECT_DATASTORE

DETAIL_DATASTORE

FILE_DATASTORE

URL_DATASTORE

USER_DATASTORE

NESTED_DATASTORE

Filter Objects

CHARSET_FILTER

INSO_FILTER

NULL_FILTER

USER_FILTER

Lexer Objects

BASIC_LEXER

MULTI_LEXER

CHINESE_VGRAM_LEXER

JAPANESE_VGRAM_LEXER

KOREAN_LEXER

Wordlist Object

BASIC_WORDLIST

Storage Objects

BASIC_STORAGE

Section Group Types

Section Group Examples

Stoplists

Creating Stoplists

Modifying the Default Stoplist

System-Defined Preferences

Data Storage

Filter

Lexer

Section Group

Stoplist

Storage

Wordlist

System Parameters

General

Default Index Parameters

4 Query Operators

Operator Precedence

Group 1 Operators

Group 2 Operators and Characters

Procedural Operators

Precedence Examples

Altering Precedence

ABOUT

ACCUMulate ( , )

AND (&)

Broader Term (BT, BTG, BTP, BTI)

EQUIValence (=)

fuzzy (?)

MINUS (-)

Narrower Term (NT, NTG, NTP, NTI)

NEAR (;)

NOT (~)

OR (|)

Preferred Term (PT)

Related Term (RT)

soundex (!)

stem ($)

Stored Query Expression (SQE)

SYNonym (SYN)

threshold (>)

Translation Term (TR)

Translation Term Synonym (TRSYN)

Top Term (TT)

weight (*)

wildcards (% _)

Right-Truncated Queries

Left- and Double-Truncated Queries

WITHIN

5 Special Characters in Queries

Grouping Characters

Escape Characters

Querying Escape Characters

Reserved Words and Characters

6 CTX_ADM Package

RECOVER

SET_PARAMETER

SHUTDOWN

7 CTX_DDL Package

ADD_ATTR_SECTION

ADD_FIELD_SECTION

ADD_SPECIAL_SECTION

ADD_STOPCLASS

ADD_STOP_SECTION

ADD_STOPTHEME

ADD_STOPWORD

ADD_SUB_LEXER

ADD_ZONE_SECTION

CREATE_PREFERENCE

CREATE_SECTION_GROUP

CREATE_STOPLIST

DROP_PREFERENCE

DROP_SECTION_GROUP

DROP_STOPLIST

OPTIMIZE_INDEX

REMOVE_SECTION

REMOVE_STOPCLASS

REMOVE_STOPTHEME

REMOVE_STOPWORD

SET_ATTRIBUTE

SYNC_INDEX

UNSET_ATTRIBUTE

8 CTX_DOC Package

FILTER

GIST

HIGHLIGHT

MARKUP

PKENCODE

SET_KEY_TYPE

THEMES

9 CTX_OUTPUT Package

END_LOG

LOGFILENAME

START_LOG

10 CTX_QUERY Package

BROWSE_WORDS

COUNT_HITS

EXPLAIN

HFEEDBACK

REMOVE_SQE

STORE_SQE

11 CTX_THES Package

ALTER_PHRASE

ALTER_THESAURUS

BT

BTG

BTI

BTP

CREATE_PHRASE

CREATE_RELATION

CREATE_THESAURUS

DROP_PHRASE

DROP_RELATION

DROP_THESAURUS

NT

NTG

NTI

NTP

OUTPUT_STYLE

PT

RT

SN

SYN

THES_TT

TR

TRSYN

TT

12 Executables

ctxsrv

Syntax

Examples

Notes

Related Topics

ctxload

Thesaurus Importing and Exporting

Text Loading

Document Updating/Exporting

ctxload Syntax

Examples

Knowledge Base Extension Compiler (ctxkbtc)

Syntax

Usage Notes

Constraints on Thesaurus Terms

Constraints on Thesaurus Relations

Linking New Terms to Existing Terms

Order of Precedence for Multiple Thesauri

Size Limits

A Query Tuning

Optimizing Queries with Statistics

Collecting Statistics

Re-Collecting Statistics

Deleting Statistics

Disabling and Enabling the Extensible Query Optimizer

Optimizing Queries for Response Time

Better Response Time with FIRST_ROWS

Better Response Time with CHOOSE

Optimizing Queries for Throughput

CHOOSE and ALL ROWS Modes

FIRST_ROWS Mode

Tuning Queries with Blocking Operations

B Result Tables

CTX_QUERY Result Tables

EXPLAIN Table

HFEEDBACK Table

CTX_DOC Result Tables

Filter Table

Gist Table

Highlight Table

Markup Table

Theme Table

CTX_THES Result Tables and Data Types

EXP_TAB Table Type

C Supported Filter Formats

About Inso Filtering Technology

Supported Platforms

Environment Variable Locations

Considerations for UNIX Platforms

OLE2 OBJECT SUPPORT

Supported Document Formats

Word Processing - Generic

Word Processing - DOS

Word Processing - International

Word Processing - Windows

Word Processing - Macintosh

Spreadsheets Formats

Databases Formats

Display Formats

Presentation Formats

Standard Graphic Formats

Other

Unsupported Formats

D Loading Examples

SQL INSERT Example

SQL*Loader Example

Creating the Table

Issuing the SQL*Loader Command

Structure of ctxload Thesaurus Import File

Alternate Hierarchy Structure

Usage Notes for Terms in Import Files

Usage Notes for Relationships in Import Files

Examples of Import Files

Structure of ctxload Text Load File

Load File Structure

Load File Syntax

Example of Embedded Text in Load File

Example of File Name Pointers in Load File

E Supplied Stoplists

English

Danish (DA)

Dutch (NL)

Finnish (FI)

French (FR)

German (DE)

Italian (IT)

Portuguese (PR)

Spanish (ES)

Swedish (SE)

F Alternate Spelling Conventions

Overview

Enabling Alternate Spelling

Disabling Alternate Spelling

German

Danish

Swedish

G Scoring Algorithm

Scoring Algorithm for Word Queries

Example

DML and Scoring

H Views

Overview

CTX_CLASSES

CTX_INDEXES

CTX_INDEX_ERRORS

CTX_INDEX_OBJECTS

CTX_INDEX_VALUES

CTX_OBJECTS

CTX_OBJECT_ATTRIBUTES

CTX_OBJECT_ATTRIBUTE_LOV

CTX_PARAMETERS

CTX_PENDING

CTX_PREFERENCES

CTX_PREFERENCE_VALUES

CTX_SECTIONS

CTX_SECTION_GROUPS

CTX_SERVERS

CTX_SQES

CTX_STOPLISTS

CTX_STOPWORDS

CTX_SUB_LEXERS

CTX_THESAURI

CTX_USER_INDEXES

CTX_USER_INDEX_ERRORS

CTX_USER_INDEX_OBJECTS

CTX_USER_INDEX_VALUES

CTX_USER_PENDING

CTX_USER_PREFERENCES

CTX_USER_PREFERENCE_VALUES

CTX_USER_SECTIONS

CTX_USER_SECTION_GROUPS

CTX_USER_SQES

CTX_USER_STOPLISTS

CTX_USER_STOPWORDS

CTX_USER_SUB_LEXERS

CTX_USER_THESAURI

I Stopword Transformations

Understanding Stopword Transformations

Word Transformations

AND Transformations

OR Transformations

ACCUMulate Transformations

MINUS Transformations

NOT Transformations

EQUIValence Transformations

NEAR Transformations

Weight Transformations

Threshold Transformations

WITHIN Transformations

J Knowledge Base - Category Hierarchy

Branch 1: science and technology

Branch 2: business and economics

Branch 3: government and military

Branch 4: social environment

Branch 5: geography

Branch 6: abstract ideas and concepts

Index