Oracle8i interMedia Text Reference
Release 8.1.5

A67843-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction to interMedia Text

Overview
System-Defined Roles
Loading Documents
Column Types
Document Formats
Loading Methods
Indexing Text
General Defaults for All Languages
Language Specific Defaults
Index Maintenance
Querying
Word Query Example
ABOUT Query Example
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
Filter Objects
NULL_FILTER
INSO_FILTER
USER_FILTER
CHARSET_FILTER
Lexer Objects
BASIC_LEXER
CHINESE_VGRAM_LEXER
JAPANESE_VGRAM_LEXER
KOREAN_LEXER
Wordlist Object
BASIC_WORDLIST
Storage Objects
BASIC_STORAGE
Section Group Types
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 (*)
WITHIN

5 Special Characters in Queries

Wildcard Characters
Grouping Characters
Escape Characters
Querying Escape Characters
Reserved Words and Characters

6 CTX_ADM Package

RECOVER
SET_PARAMETER
SHUTDOWN

7 CTX_DDL Package

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

8 CTX_DOC Package

FILTER
GIST
HIGHLIGHT
MARKUP
PKENCODE
THEMES

9 CTX_QUERY Package

COUNT_HITS
EXPLAIN
HFEEDBACK
REMOVE_SQE
STORE_SQE

10 CTX_THES Package

BT
BTG
BTI
BTP
CREATE_PHRASE
CREATE_THESAURUS
DROP_THESAURUS
NT
NTG
NTI
NTP
OUTPUT_STYLE
PT
RT
SYN
TR
TRSYN
TT

11 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 Working with the Extensible Query Optimizer

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

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

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
Standard Graphic Formats
High-End Graphic Formats
Presentation 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_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

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



Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Index