Index

concepts in knowledge catalog, J-1

CONTAINS operator

syntax, 2-8

context indextype, 2-10

continuation attribute, 3-14

control file example

SQL*Loader, D-3

COUNT_HITS procedure, 9-2

CREATE INDEX, 2-10

default parameters, 3-28

example, 1-6, 2-13

CREATE_PHRASE procedure, 10-11

CREATE_PREFERENCE procedure, 7-14

CREATE_SECTION_GROUP procedure, 7-17

CREATE_STOPLIST procedure, 7-19

CREATE_THESAURUS function, 10-13

CTX_ADM package

RECOVER, 6-2

SET_PARAMETER, 6-3

SHUTDOWN, 6-5

CTX_CLASSES view, H-4

CTX_DDL package

ADD_FIELD_SECTION, 7-3

ADD_SPECIAL_SECTION, 7-6

ADD_STOPCLASS, 7-8

ADD_STOPTHEME, 7-9

ADD_STOPWORD, 7-10

ADD_ZONE_SECTION, 7-12

CREATE_PREFERENCE, 7-14

CREATE_SECTION_GROUP, 7-17

CREATE_STOPLIST, 7-19

DROP_PREFERENCE, 7-21

DROP_SECTION GROUP, 7-22

DROP_STOPLIST, 7-23

REMOVE_SECTION, 7-24

REMOVE_STOPCLASS, 7-26

REMOVE_STOPTHEME, 7-27

REMOVE_STOPWORD, 7-28

SET_ATTRIBUTE, 7-29

UNSET_ATTRIBUTE, 7-30

GIST, 8-4

CTX_FEEDBACK_ITEM_TYPE type, B-6

CTX_FEEDBACK_TYPE type, 9-7, B-6

CTX_INDEX_ERRORS view, H-5

CTX_INDEX_OBJECTS view, H-5

CTX_INDEX_VALUES view, H-6

CTX_INDEXES view, H-4

CTX_OBJECT_ATTRIBUTE_LOV view, H-7

CTX_OBJECT_ATTRIBUTES view, H-7

CTX_OBJECTS view, H-6

CTX_PARAMETERS view, 3-27, H-8

CTX_PENDING view, H-9

CTX_PREFERENCE_VALUES view, H-9

CTX_PREFERENCES view, H-9

CTX_QUERY package

CTX_SECTION_GROUPS view, H-10

CTX_SECTIONS view, H-10

CTX_SERVERS view, H-11

CTX_SQES view, H-11

CTX_STOPLISTS view, H-12

CTX_STOPWORDS view, H-12

CTX_THES package, 10-1

BT, 10-3

BTG, 10-5

BTI, 10-7

BTP, 10-9

CREATE_PHRASE, 10-11

CREATE_THESAURUS, 10-13

DROP_THESAURUS, 10-14

NT, 10-15

NTG, 10-17

NTI, 10-19

NTP, 10-21

OUTPUT_STYLE, 10-23

PT, 10-24

RT, 10-26

SYN, 10-28

TR, 10-30

TRSYN, 10-32

TT, 10-34

CTX_THESAURI view, H-12

CTX_USER_INDEX_ERRORS view, H-14

CTX_USER_INDEX_OBJECTS view, H-14

CTX_USER_INDEX_VALUES view, H-14

CTX_USER_INDEXES view, H-13

CTX_USER_PENDING view, H-15

CTX_USER_PREFERENCE_VALUES view, H-15

CTX_USER_PREFERENCES view, H-15

CTX_USER_SECTION_GROUPS view, H-16

CTX_USER_SECTIONS view, H-16

CTX_USER_SQES view, H-16

CTX_USER_STOPLISTS view, H-17

CTX_USER_STOPWORDS view, H-17

CTX_USER_THESAURI view, H-17

CTXAPP role, 1-3

ctxkbtc complier, 11-13

ctxload, 11-6

examples, 11-11

import file structure, D-6

load file examples, D-15

load file format, D-13

ctxsrv

Inso variables in startup shell, C-3

shutting down, 6-5, 11-5

viewing active servers, H-11

ctxsrv executable, 1-7, 11-2

CTXSYS role, 1-3

customer support

contacting, xvii

Danish

alternate spelling, F-4

supplied stoplist, E-3

data storage

URL, 3-6

datastore objects, 3-3

DATE column, 1-4, 1-6, 2-10

default index

example, 2-13

default parameters

changing, 3-29

viewing, 3-29

DEFAULT thesaurus, 4-11, 4-17

DEFAULT_DATASTORE system parameter, 3-28

DEFAULT_DATASTORE system-defined indexing preference, 3-25

DEFAULT_FILTER_BINARY system parameter, 3-28

DEFAULT_FILTER_FILE system parameter, 3-28

DEFAULT_FILTER_TEXT system parameter, 3-28

DEFAULT_INDEX_MEMORY system parameter, 3-27

DEFAULT_LEXER system parameter, 3-29

DEFAULT_LEXER system-defined indexing preference, 3-26

DEFAULT_SECTION_HTML system parameter, 3-28

DEFAULT_SECTION_TEXT system parameter, 3-28

DEFAULT_STOPLIST system parameter, 3-29

DEFAULT_STOPLIST system-defined preference, 3-26

DEFAULT_STORAGE system parameter, 3-28

DEFAULT_STORAGE system-defined preference, 3-26

DEFAULT_WORDLIST system parameter, 3-29

DEFAULT_WORDLIST system-defined preference, 3-26

defaults

general index, 1-6

language-specific, 1-7

defaults for indexing

viewing, H-8

defragmentation, 2-6

derivational stemming

enabling for English, 3-20

DETAIL_DATASTORE object, 3-3

example, 3-4

detail_key attribute, 3-3

detail_lineno attribute, 3-3

detail_table attribute, 3-3

detail_text attribute, 3-4

DIRECT_DATASTORE object, 3-3

disambiguators

in thesaural queries, 4-10

in thesaurus import file, D-10

DML

affect on scoring, G-3

DML errors

batch, 2-4

DML queue

document

filtering to HTML and plain text, 8-2

generating themes, 8-18

Gist and theme summary, 8-4

document filtering

document formats

document loading

document presentation

about, 1-11

procedures, 8-1

DOMAIN_INDEX_NO_SORT hint

better throughput example, A-8

DOMAIN_INDEX_SORT hint

better response time example, A-7

DROP INDEX, 2-7

DROP_PREFERENCE procedure, 7-21

DROP_SECTION_GROUP procedure, 7-22

DROP_STOPLIST procedure, 7-23

DROP_THESAURUS procedure, 10-14

Dutch

composite word indexing, 3-17

index defaults, 1-7

setting for Inso filter, C-2

supplied stoplist, E-4

empty indexes

creating, 2-12

endjoins attribute, 3-16

English

supplied stoplist, E-2

environment variables

equivalence operator, 4-13

stopword transformations, I-6

with near, 4-19

escaping special characters, 5-4

expansion operator

fuzzy, 4-14

soundex, 4-26

stem, 4-27

retrieving data example, 9-5

EXPLAIN procedure, 9-3

example, 9-5

result table, B-2

explain table

creating, 9-4

structure, B-2

extending knowledge base, 11-13

extensible query optimizer, A-2

enabling/disabling, A-4

external filters

specifying, 3-11

extproc process, C-3

fast optimization

example, 2-5

features of interMedia Text

overview, 1-2

query and index, 1-10

field section

defining, 7-3

limitations, 7-5

FILE_DATASTORE object, 3-5

file data storage

example, 7-14

FILE_DATASTORE system-defined preference, 3-25

filter formats

supported, C-5

filter objects, 3-10

FILTER procedure, 8-2

filter table

filtering

to plain text and HTML, 1-11, 8-2

filters

Inso, 3-10, C-2

user, 3-11

Finnish

supplied stoplist, E-5

FIRST_ROWS hint

better response time example, A-5

better throughput example, A-8

formatted documents

filtering, 3-10

fragmentation of index, 2-12, 11-4

French

specifying a language, 3-20

supplied stoplist, E-6

French stemming, 3-19

ftp_proxy attribute, 3-8

full optimization

example, 2-6

full themes

example, 8-19

fuzzy matching

default, 1-6

fuzzy operator, 4-14

fuzzy_match attribute, 3-20

fuzzy_numresults attribute, 3-21

fuzzy_score attribute, 3-21

garbage collection, 2-6

German

alternate spelling attribute, 3-18

alternate spelling conventions, F-3

composite word indexing, 3-17

index defaults, 1-7

in thesaurus import file, D-9

supplied stoplist, E-7

Gist

Gist table

HFEEDBACK procedure, 9-6

example, 9-7

result table, B-5

hierarchical query feedback information

generating, 9-6

hierarchical relationships

HIGHLIGHT procedure, 8-8

highlight table

highlighting

generating markup, 8-11

generating offsets, 8-8

with near operator, 4-20

hit counting, 9-2

HOME environment variable

setting for INSO, C-3

homographs

in broader term queries, 4-11

in queries, 4-10

in thesaurus import file, D-10

HTML

filtering to, 1-11, 8-2

highlight markup, 8-11

highlight offset, 8-8

HTML highlighting

example, 8-14

HTML_SECTION_GROUP object, 3-24, 7-17

HTML_SECTION_GROUP system-defined preference, 3-26

http_proxy attribute, 3-8

i_index_clause attribute, 3-23

i_table_clause attribute, 3-22

import file

index

viewing registered, H-4

index creation

custom preference example, 2-13

default example, 2-13

index defaults

general, 1-6

language specific, 1-7

index fragmentation, 2-12

background DML, 11-4

index maintenance, 1-7, 2-2

index objects, 3-1

viewing, H-5, H-6

index preference

about, 3-2

creating, 3-2, 7-14

index synchronization

ctxsrv, 11-2

example, 2-6

index tablespace parameters

specifying, 3-22

index_text attribute, 3-17

index_themes attribute, 3-17

indexing

example, 1-6

master/detail example, 3-5

themes, 3-17

indextype context, 2-10

inflectional stemming

enabling, 3-20

INSERT

loading example, D-2

Inso filter

index preference object, 3-10

setting up, C-2

supported formats, C-5

supported platforms, C-2

unsupported formats, C-13

INSO_FILTER object, 3-10

INSO_FILTER system-defined preference, 3-25

interMedia Text

related publications, xvi

interMedia Text Manager tool, 11-2, 11-5

inverse frequency scoring, G-2

Italian

supplied stoplist, E-8

Japanese

JAPANESE_VGRAM_LEXER object, 3-18

indexing, 3-18

k_table_clause attribute, 3-22

knowledge base extension compiler, 11-13

knowledge catalog

category hierarchy, J-1

Korean text

indexing, 3-18

KOREAN_LEXER object, 3-18

language

default setting, 1-6

setting, 3-12

language specific defaults, 1-7

lexer objects, 3-12

list of themes

example, 8-19

listener.ora

setting environment variables in, C-3

load file

loading text

SQL INSERT example, D-2

SQL*Loader example, D-3

loading thesaurus, 11-6

LOB columns

indexing, 1-6

loading, D-3

LOG_DIRECTORY system parameter, 3-27

logical operators

with near, 4-19

LONG columns, 1-4

indexing, 2-10

loading text into, 11-6

LONG RAW columns

loading text into, 11-6

maintaining index, 2-2

MARKUP procedure, 8-11

example, 8-14

HTML highlight example, 8-14

result table, B-10

markup table

example, 8-14

structure, B-10

master/detail data storage, 3-3

example, 3-4, 7-15

master/detail tables

indexing example, 3-5

MAX_INDEX_MEMORY system parameter, 3-27

max_span parameter in near operator, 4-18

maxdocsize attribute, 3-8

maxthread attribute, 3-7

maxurls attribute, 3-8

memory

for index synchronize, 2-5

for indexing, 2-12

MINUS operator, 4-15

stopword transformations, I-5

mixed_case attribute, 3-17

mixed-format columns

filtering, 3-10

supported formats for, C-5

morpheme attribute, 3-18

n_table_clause attribute, 3-23

narrower term operators

example, 4-16

narrower term query feedback, 9-6

NCLOB column, 1-4, 1-6

near operator, 4-18

backward compatibility, 4-20

highlighting, 4-20

scoring, 4-19

stopword transformations, I-6

with other operators, 4-19

with within, 4-40

nested zone sections, 7-13

newline attribute, 3-16

NEWS_SECTION_GROUP object, 3-24, 7-18

no_proxy attribute, 3-8

NOT operator, 4-22

stopword transformations, I-5

notational conventions, xvii

NULL_FILTER object, 3-10

NULL_FILTER system-defined preference, 3-25

NULL_SECTION_GROUP object, 3-24, 7-17

NULL_SECTION_GROUP system-defined preference, 3-26

number attribute, 3-18

NUMBER column, 1-4, 1-6, 2-10

numgroup attribute, 3-14

numjoin attribute, 3-14

object values

viewing, H-6

objects

viewing index, H-6

offsets for highlighting, 8-8

onechar attribute, 3-18

OPERATION column of explain table

values, B-3

operator

operator expansion

stopword transformations, I-3

operator precedence, 4-3

optimizing index

optimizing queries, A-2

response time, A-5

statistics, A-2

throughput, A-8

OPTION column of explain table

values, B-4

OPTION column of hfeedback table

values, B-6

OR operator, 4-23

Oracle Corporation

customer support, xvii

Oracle Enterprise Manager, 11-5

OUTPUT_STYLE procedure, 10-23

overlapping zone sections, 7-13

PARAGRAPH keyword, 4-41

paragraph section

defining, 7-6

viewing system-defined, H-8

paragraph-level Gist and theme summary

generating, 8-4

parameters

setting, 6-3

parentheses

altering precedence, 4-5, 5-3

grouping character, 5-3

path attribute, 3-6

PATH environment variable

setting for Inso, C-3

pending updates

viewing, 11-4, H-9

personality mask for ctxsrv, 11-2

PKENCODE function, 8-16

plain text

filtering to, 8-2

highlight markup, 8-11

offsets for highlighting, 8-8

plain text filtering, 1-11

Portuguese

supplied stoplist, E-9

precedence of operators, 4-3

altering, 4-5, 5-3

equivalence operator, 4-13

preference classes

preference values

preferences

about, 3-2

preferred term operator

example, 4-24

printjoins attribute, 3-14

procedure attribute, 3-9

proximity operator, see near operator

PT function, 10-24

PT operator, 4-24

punctuations attribute, 3-15

qualifiers

in thesaural queries, 4-10

query

query example, 1-9

query features, 1-10

querying

about, 1-9

r_table_clause attribute, 3-23

rebuilding index

example, 2-5

syntax, 2-4

RECOVER procedure, 6-2

related term operator, 4-25

related term query feedback, 9-6

relevance ranking

word queries, G-2

REMOVE_SECTION procedure, 7-24

REMOVE_SQE procedure, 9-10

REMOVE_STOPCLASS procedure, 7-26

REMOVE_STOPTHEME procedure, 7-27

REMOVE_STOPWORD procedure, 7-28

renaming index, 2-2

replacing preferences, 2-4

reserved words and characters, 5-5

resuming failed index

example, 2-5

RFC 1738 URL specification, 3-6

roles

system-defined, 1-3

RT function, 10-26

RT operator, 4-25

Salton's formula for scoring, G-2

SCORE operator, 2-15

scoring

effect of DML, G-3

for near operator, 4-19

scoring algorithm

word queries, G-2

section group

creating, 7-17

dropping, 7-22

viewing information about, H-10

section group types, 3-24, 7-17

section searching, 4-39

sections

viewing information on, H-10

SENTENCE keyword, 4-41

sentence section

defining, 7-6

SET_ATTRIBUTE procedure, 7-29

sentence-level Gist and theme summary

generating, 8-4

server

DML, 11-2

shutting down, 6-5, 11-5

viewing active, H-11

SET_PARAMETER procedure, 3-27, 6-3

SHUTDOWN procedure, 6-5

single themes

obtaining (example), 8-19

single-byte languages

indexing, 3-12

skipjoins attribute, 3-16

soundex operator, 4-26

Spanish

supplied stoplist, E-10

special section

defining, 7-6

startjoins attribute, 3-16

SQL commands

SQL operators

SQL*Loader

example control file, D-3

example data file, D-4

sqlldr example, D-3

statistics

optimizing with, A-2

stem operator, 4-27

stemmer attribute, 3-20

stopclass

stoplist

Dutch, E-4

stoplists

stoptheme

stopword

adding dynamically, 2-4

defining, 7-10

removing, 7-28

viewing all in stoplist, H-12

stopword transformation, I-2

defaults for indexing, 3-28

storage

example, 7-15

storage defaults, 3-23

storage objects, 3-22

STORE_SQE procedure

example, 4-28

syntax, 9-11

stored queries, 4-28

stored query expression

creating, 9-11

removing, 9-10

viewing, H-16

viewing definition, H-11

supplied stoplists, E-1

Swedish

alternate spelling, F-5

index defaults, 1-7

supplied stoplist, E-11

SYN function, 10-28

SYN operator, 4-29

synchronizing index, 1-7

background, 11-2

batch example, 2-6

synonym operator, 4-29

system parameters, 3-27

system recovery

manual, 6-2

system-defined preferences, 3-25

table structure

Gist, B-8

tagged text

text column

loading, See loading text

supported types, 1-4, 2-10

Text data dictionary

text-only index

theme highlighting

generating markup, 8-11

generating offsets, 8-8

HTML markup example, 8-14

HTML offset example, 8-9

theme index

as default in English, 1-7

theme summary

theme table

themes

generating for document, 8-18

generating highlight markup, 8-11

highlight offset example, 8-9

indexing, 1-7, 3-17

THEMES procedure, 8-18

result table, B-11

thesaurus

compiling, 11-13

creating, 10-13

creating relationships, 10-11

DEFAULT, 4-11

dropping, 10-14

import/export examples, 11-11

importing/exporting, 11-6

procedures for browsing, 10-1

viewing information about, H-12

thesaurus import file

examples, D-11

structure, D-6

threshold operator, 4-31

stopword transformations, I-7

timeout attribute, 3-7

tohangeul attribute, 3-18

top term operator, 4-36

toupper attribute, 3-18

TR function, 10-30

TR operator, 4-32

transformation

stopword, I-2

translation term operator, 4-32

translation term synonym operator, 4-34

TRSYN function, 10-32

UNIX platforms

setting variables for Inso, C-3

UNSET_ATTRIBUTE procedure, 7-30

URL syntax, 3-6

URL_DATASTORE object

attributes for, 3-6

URL_DATASTORE system-defined preference, 3-25

urlsize attribute, 3-7

USER_DATASTORE object, 3-9

USER_FILTER object, 3-11

utilities

ctxload, 11-6

VARCHAR2 column

indexing, 2-10

verb attribute, 3-18

viewing

operator expansion, 9-3

operator precedence, 9-3

views, H-1

visible flag for field sections, 7-3

weight operator, 4-37

stopword transformations, I-7

whitespace attribute, 3-16

wildcard characters, 5-2

WITHIN operator, 4-39

limitations, 4-42

precedence, 4-4

stopword transformations, I-7

word query

example, 1-9

xdic attribute, 3-18

XML_SECTION_GROUP object, 3-24, 7-17

zone section

creating, 7-12