Oracle8
i inter
Media Text Reference
Release 2 (8.1.6)
A77063-01
Library
Product
Index
Contents
Title and Copyright Information
Send Us Your Comments
Preface
1 Introduction to
inter
Media Text
What is Oracle8i interMedia Text?
Building Your Text Application
Code Samples Directory
inter
Media 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
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Index