Oracle8i interMedia Text Oracle interMedia Text Reference

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 (*)

WITHIN

Wildcard Characters

Grouping Characters

Escape Characters

Querying Escape Characters

Reserved Words and Characters

RECOVER

SET_PARAMETER

SHUTDOWN

ADD_FIELD_SECTION

ADD_SPECIAL_SECTION

ADD_STOPCLASS

ADD_STOPTHEME

ADD_STOPWORD

ADD_ZONE_SECTION

CREATE_PREFERENCE

CREATE_SECTION_GROUP

CREATE_STOPLIST

DROP_PREFERENCE

DROP_SECTION_GROUP

DROP_STOPLIST

REMOVE_SECTION

REMOVE_STOPCLASS

REMOVE_STOPTHEME

REMOVE_STOPWORD

SET_ATTRIBUTE

UNSET_ATTRIBUTE

FILTER

GIST

HIGHLIGHT

MARKUP

PKENCODE

THEMES

COUNT_HITS

EXPLAIN

HFEEDBACK

REMOVE_SQE

STORE_SQE

BT

BTG

BTI

BTP

CREATE_PHRASE

CREATE_THESAURUS

DROP_THESAURUS

NT

NTG

NTI

NTP

OUTPUT_STYLE

PT

RT

SYN

TR

TRSYN

ctxsrv

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

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

CTX_QUERY Result Tables

EXPLAIN Table

HFEEDBACK Table

CTX_DOC Result Tables

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

Standard Graphic Formats

High-End Graphic Formats

Presentation Formats

Other

Unsupported Formats

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

English

Danish (DA)

Dutch (NL)

Finnish (FI)

French (FR)

German (DE)

Italian (IT)

Portuguese (PR)

Spanish (ES)

Swedish (SE)

Overview

Enabling Alternate Spelling

Disabling Alternate Spelling

German

Danish

Swedish

Scoring Algorithm for Word Queries

Example

DML and Scoring

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_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_THESAURI

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

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

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction to interMedia Text

2 SQL Commands

3 Indexing

4 Query Operators

5 Special Characters in Queries

6 CTX_ADM Package

7 CTX_DDL Package

8 CTX_DOC Package

9 CTX_QUERY Package

10 CTX_THES Package

11 Executables

A Working with the Extensible Query Optimizer

B Result Tables

C Supported Filter Formats

D Loading Examples

E Supplied Stoplists

F Alternate Spelling Conventions

G Scoring Algorithm

H Views

I Stopword Transformations

J Knowledge Base - Category Hierarchy

Index