Index

viewing allowed values, H-7

attribute sections

adding dynamically, 2-6

WITHIN example, 4-46

attributes

alternate_spelling, 3-33

fuzzy_numresults, 3-41

path, 3-7

whitespace, 3-32

AUTO stemming, 3-39

AUTO_SECTION_GROUP object, 3-46, 7-28

background DML, 12-2

backslash escape character, 5-3

base_letter attribute, 3-32

BASIC_LEXER object, 3-28

supported character sets, 3-28

BASIC_LEXER system-defined preference, 3-52

BASIC_SECTION_GROUP object, 3-46, 7-27

BASIC_STORAGE object

attributes for, 3-43

defaults, 3-44

example, 3-44

BASIC_WORDLIST object

batch processing

binary attribute, 3-4, 3-15

BLOB column, 1-5

indexing, 1-7, 2-14

loading example, D-3

blocking operations

tuning queries with, A-9

brace escape character, 5-3

brackets

altering precedence, 4-5, 5-2

grouping character, 5-2

broader term operators

example, 4-12

broader term query feedback, 10-9

BROWSE_WORDS procedure, 10-2

browsing words in index, 10-2

case-sensitive index

categories in knowledge catalog, J-1

character sets

supported for Chinese, 3-36

characters

specifying for newline, 3-32

specifying for whitespace, 3-32

startjoin and endjoin, 3-31

character-set

indexing mixed columns, 3-19

character-set conversion

with INSO_FILTER, 3-22

charset attribute, 3-19

CHARSET_FILTER

attributes for, 3-19

example, 3-20

Chinese character sets supported, 3-36

Chinese text

indexing, 3-36

CHINESE_VGRAM_LEXER object, 3-36

CHOOSE hint

better response time, A-7

CLOB column, 1-5

indexing, 1-7, 2-14

clump size in near operator, 4-20

code samples directory, 1-3

column types

supported for indexing, 1-5

columns types

supported for indexing, 2-14

command attribute, 3-25

compaction of index, 2-7

composite attribute (basic lexer), 3-33

composite attribute (korean lexer), 3-37

composite indexing

Dutch default, 1-8

German default, 1-8

composite textkey

encoding, 8-19

composite word index

creating for German or Dutch text, 3-33

composite words

concepts in knowledge catalog, J-1

concept query, See ABOUT

CONTAINS operator

example, 2-13

syntax, 2-12

context indextype, 2-14

continuation attribute, 3-29

control file example

SQL*Loader, D-4

COUNT_HITS procedure, 10-5

CREATE INDEX, 2-14

default parameters, 3-55

example, 1-7, 2-18

CREATE_PHRASE procedure, 11-16

CREATE_PREFERENCE procedure, 7-24

CREATE_RELATION procedure, 11-18

CREATE_SECTION_GROUP procedure, 7-27

CREATE_STOPLIST procedure, 7-30

CREATE_THESAURUS function, 11-20

CTX_ADM package

RECOVER, 6-2

SET_PARAMETER, 6-3

SHUTDOWN, 6-5

CTX_CLASSES view, H-4

CTX_DDL package

GIST, 8-5

CTX_DOC_KEY_TYPE system parameter, 3-54

CTX_FEEDBACK_ITEM_TYPE type, B-6

CTX_FEEDBACK_TYPE type, 10-10, B-6

CTX_INDEX_ERRORS view, H-5

example, 2-20

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_OUTPUT package, 9-1

END_LOG, 9-2

LOGFILENAME, 9-3

START_LOG, 9-4

CTX_PARAMETERS view, 3-54, 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_SUB_LEXERS view, H-13

CTX_THES package, 11-1

CTX_THESAURI view, H-13

CTX_USER_INDEX_ERRORS view, H-15

example, 2-20

CTX_USER_INDEX_OBJECTS view, H-15

CTX_USER_INDEX_VALUES view, H-15

CTX_USER_INDEXES view, H-14

CTX_USER_PENDING view, H-16

example, 2-9

CTX_USER_PREFERENCE_VALUES view, H-16

CTX_USER_PREFERENCES view, H-16

CTX_USER_SECTION_GROUPS view, H-17

CTX_USER_SECTIONS view, H-17

CTX_USER_SQES view, H-17

CTX_USER_STOPLISTS view, H-18

CTX_USER_STOPWORDS view, H-18

CTX_USER_SUB_LEXERS view, H-19

CTX_USER_THESAURI view, H-19

CTXAPP role, 1-4

ctxkbtc complier, 12-12

ctxload, 12-6

examples, 12-11

import file structure, D-6

load file examples, D-15

load file format, D-13

ctxsrv

about, 1-9, 12-2

Inso variables in startup shell, C-3

shutting down, 6-5, 12-4

viewing active servers, H-11

CTXSYS user, 1-4

customer support

contacting, xix

Danish

alternate spelling, F-4

defined procedurally, 3-12

supplied stoplist, E-3

data storage

datastore objects, 3-3

DATE column, 1-5, 1-7, 2-14

default index

example, 2-18

default parameters

changing, 3-56

viewing, 3-56

DEFAULT thesaurus, 4-13, 4-19

DEFAULT_DATASTORE system parameter, 3-55

DEFAULT_DATASTORE system-defined indexing preference, 3-50

DEFAULT_FILTER_BINARY system parameter, 3-55

DEFAULT_FILTER_FILE system parameter, 3-55

DEFAULT_FILTER_TEXT system parameter, 3-55

DEFAULT_INDEX_MEMORY system parameter, 3-54

DEFAULT_LEXER system parameter, 3-56

DEFAULT_LEXER system-defined indexing preference, 3-51

DEFAULT_SECTION_HTML system parameter, 3-55

DEFAULT_SECTION_TEXT system parameter, 3-55

DEFAULT_STOPLIST system parameter, 3-56

DEFAULT_STOPLIST system-defined preference, 3-53

DEFAULT_STORAGE system parameter, 3-55

DEFAULT_STORAGE system-defined preference, 3-53

DEFAULT_WORDLIST system parameter, 3-56

DEFAULT_WORDLIST system-defined preference, 3-53

defaults

index, 1-7

defaults for indexing

viewing, H-8

defragmentation, 2-7

derivational stemming

enabling for English, 3-40

DETAIL_DATASTORE object, 3-4

example, 3-4

detail_key attribute, 3-4

detail_lineno attribute, 3-4

detail_table attribute, 3-4

detail_text attribute, 3-4

DIRECT_DATASTORE object, 3-3

example, 3-3

disambiguators

in thesaural queries, 4-12

in thesaurus import file, D-9

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-22

Gist and theme summary, 8-5

document filtering

document formats

document loading

document presentation

about, 1-13

procedures, 8-1

document services

about, 1-13

logging requests, 9-4

DOMAIN_INDEX_NO_SORT hint

better throughput example, A-8

DOMAIN_INDEX_SORT hint

better response time example, A-7

double-truncated queries, 4-41

double-truncated searching

improving performance, 3-41

DROP INDEX, 2-11

DROP_PHRASE procedure, 11-21

DROP_PREFERENCE procedure, 7-31

DROP_RELATION procedure, 11-23

DROP_SECTION_GROUP procedure, 7-32

DROP_STOPLIST procedure, 7-33

DROP_THESAURUS procedure, 11-26

Dutch

composite word indexing, 3-33

supplied stoplist, E-4

empty indexes

creating, 2-18

END_LOG procedure, 9-2

endjoins attribute, 3-31

English

setting for Inso filter, C-2

supplied stoplist, E-2

environment variables

equivalence operator, 4-15

stopword transformations, I-6

with NEAR, 4-21

errors

indexing, 2-9, 2-20

escaping special characters, 5-3

EXP_TAB table type, B-12

expansion operator

fuzzy, 4-16

soundex, 4-28

stem, 4-29

retrieving data example, 10-8

EXPLAIN procedure, 10-6

example, 10-8

result table, B-2

explain table

creating, 10-7

structure, B-2

extending knowledge base, 12-12

extensible query optimizer, A-2

enabling/disabling, A-4

external filters

specifying, 3-25

extproc process, C-3

failed index operation

resuming, 2-5

fast optimization

code samples directory, 1-3

features of interMedia Text

new, See interMedia Text Migration

overview, 1-3

query and index, 1-11

field section

defining, 7-5

limitations, 7-7

FILE_DATASTORE object, 3-7

field sections

adding dynamically, 2-6

repeated, 4-46

WITHIN example, 4-45

file data storage

example, 7-24

example, 3-7

FILE_DATASTORE system-defined preference, 3-50

filter formats

supported, C-5

filter objects, 3-18

FILTER procedure, 8-2

example, 8-4

in-memory example, 8-3

result table, B-8

filter table

structure, B-8

filtering

index default, 1-7

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

filters

character-set, 3-19

Inso, 3-21, C-2

user, 3-25

Finnish

index defaults, 1-8, 3-52

supplied stoplist, E-5

FIRST_ROWS hint

better response time example, A-5

better throughput example, A-8

example, 1-11

formats

supported, 1-5

formatted documents

filtering, 3-21

fragmentation of index, 2-18, 12-4

French

supplied stoplist, E-6

French stemming, 3-39

ftp_proxy attribute, 3-10

full optimization

automatic language detection, 3-40

full themes

example, 8-24

fuzzy matching

default, 1-7

example for enabling, 3-42

specifying a language, 3-41

fuzzy operator, 4-16

fuzzy_match attribute, 3-41

fuzzy_numresults attribute, 3-41

fuzzy_score attribute, 3-41

garbage collection, 2-7

German

alternate spelling attribute, 3-33

alternate spelling conventions, F-3

composite word indexing, 3-33

in thesaurus import file, D-8

supplied stoplist, E-7

Gist

Gist table

HFEEDBACK procedure, 10-9

example, 10-10

result table, B-5

hierarchical query feedback information

generating, 10-9

hierarchical relationships

HIGHLIGHT procedure, 8-10

highlight table

highlighting

generating markup, 8-13

generating offsets, 8-10

with NEAR operator, 4-22

hit counting, 10-5

HOME environment variable

setting for INSO, C-3

homographs

in broader term queries, 4-13

in queries, 4-12

in thesaurus import file, D-9

HTML

bypassing filtering, 3-21

filtering to, 1-13, 8-2

generating highlight offsets for, 8-10

highlight markup, 8-13

highlighting example, 8-17

indexing, 3-24, 3-46

zone section example, 7-21

HTML_SECTION_GROUP object, 3-46, 7-21, 7-27

with NULL_FILTER, 3-24

HTML_SECTION_GROUP system-defined preference, 3-52

http_proxy attribute, 3-10

i_index_clause attribute, 3-44

i_table_clause attribute, 3-43

import file

index

viewing registered, H-4

index creation

custom preference example, 2-18

default example, 2-18

index creation parameters

example, 3-44

index defaults

general, 1-7

language specific, 1-8

index errors, 2-9

viewing, 2-20

index fragmentation, 2-18

background DML, 12-4

index maintenance, 1-9, 2-2

index objects, 3-1

viewing, H-5, H-6

index optimization, 2-5

index preference

about, 3-2

creating, 3-2, 7-24

index requests

logging, 9-4

index synchronization

ctxsrv, 12-2

example, 2-8

index tablespace parameters

specifying, 3-43

index_text attribute, 3-33

index_themes attribute, 3-33

indexing

example, 1-7

master/detail example, 3-5

parallel, 2-15

themes, 3-33

indextype context, 2-14

inflectional stemming

enabling, 3-40

INSERT statement

load text example, 1-5

loading example, D-2

Inso filter

index preference object, 3-21

setting up, C-2

supported formats, C-5

supported platforms, C-2

unsupported formats, C-13

INSO_FILTER object, 3-21

character-set conversion, 3-22

INSO_FILTER system-defined preference, 3-51

interMedia Text

related publications, xviii

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

inverse frequency scoring, G-2

Italian

supplied stoplist, E-8

Japanese

Japanese character sets supported, 3-37

index defaults, 3-52

indexing, 3-37

JAPANESE_VGRAM_LEXER object, 3-37

JOB_QUEUE_INTERVAL initialization parameter, 2-15

JOB_QUEUE_PROCESSES initialization parameter, 2-15

k_table_clause attribute, 3-43

knowledge base extension compiler, 12-12

knowledge catalog

category hierarchy, J-1

Korean

index defaults, 3-52

korean character sets supported, 3-37

Korean text

indexing, 3-37

KOREAN_LEXER object, 3-37

language

default setting for indexing, 1-7

setting, 3-27

language specific defaults, 1-8

left-truncated searching

improving performance, 3-41

lexer objects, 3-27

list of themes

example, 8-24

listener.ora

setting environment variables in, C-3

load file

examples, D-15

formatting, D-13

loading text

about, 1-5

ctxload, 12-6, D-13

SQL INSERT example, 1-5, D-2

SQL*Loader example, D-3

loading thesaurus, 12-6

LOB columns

indexing, 1-7

loading, D-3

LOG_DIRECTORY system parameter, 3-54, 9-3

LOGFILENAME procedure, 9-3

logging index requests, 9-4

logical operators

with NEAR, 4-21

LONG columns, 1-5

indexing, 2-14

loading text into, 12-6

LONG RAW columns

loading text into, 12-6

maintaining index, 2-2

MARKUP procedure, 8-13

example, 8-17

HTML highlight example, 8-17

result table, B-10

markup table

example, 8-17

structure, B-10

master/detail data storage, 3-4

example, 3-4, 7-25

master/detail tables

indexing example, 3-5

MAX_INDEX_MEMORY system parameter, 3-54

max_span parameter in near operator, 4-20

maxdocsize attribute, 3-10

maxthreads attribute, 3-9

maxurls attribute, 3-10

memory

for index synchronize, 2-5

for indexing, 2-8, 2-17

META tag

creating field sections for, 7-6

creating zone section for, 7-21

MINUS operator, 4-17

stopword transformations, I-5

mixed character-set columns

indexing, 3-19

mixed_case attribute, 3-32

mixed-format columns

filtering, 3-21

indexing, 3-21

supported formats for, C-5

morpheme attribute, 3-37

MULTI_LEXER object, 3-35

CREATE INDEX example, 2-19

example, 3-35

multi-language indexing, 7-17

multi-language tables

querying, 2-13, 3-36

n_table_clause attribute, 3-44

narrower term operators

example, 4-18

narrower term query feedback, 10-9

NCLOB column, 1-5, 1-7

NEAR operator, 4-20

backward compatibility, 4-22

highlighting, 4-22

scoring, 4-21

stopword transformations, I-6

with other operators, 4-21

with within, 4-44

nested section searching, 4-45

nested zone sections, 7-22

nested_column attribute, 3-15

NESTED_DATASTORE attribute, 3-15

NESTED_DATASTORE object, 3-15

nested_lineno attribute, 3-15

nested_text attribute, 3-15

nested_type attribute, 3-15

new features

See interMedia Text Migration

newline attribute, 3-32

NEWS_SECTION_GROUP object, 3-46, 7-28

no_proxy attribute, 3-10

Norwegian

index defaults, 1-8, 3-52

NOT operator, 4-24

stopword transformations, I-5

notational conventions, xix

NULL_FILTER object, 3-24

NULL_FILTER system-defined preference, 3-51

NULL_SECTION_GROUP object, 3-46, 7-27

NULL_SECTION_GROUP system-defined preference, 3-52

number attribute, 3-37

NUMBER column, 1-5, 1-7, 2-14

numgroup attribute, 3-29

numjoin attribute, 3-30

object values

viewing, H-6

objects

viewing index, H-6

offsets for highlighting, 8-10

onechar attribute, 3-37

OPERATION column of explain table

values, B-3

operator

operator expansion

operator precedence, 4-3

examples, 4-4

with blocking operations, A-9

operators, 4-1

optimizing index, 2-5

fast (example), 2-7

full (example), 2-7

optimizing queries, A-2

response time, 1-11, A-5

statistics, A-2

throughput, A-8

OPTIONS column

explain table, B-4

hfeedback table, B-6

OR operator, 4-25

stopword transformations, I-3

Oracle Corporation

customer support, xix

Oracle Enterprise Manager, 12-5

OUTPUT_STYLE procedure, 11-36

output_type attribute, 3-13

overlapping zone sections, 7-22

p_table_clause, 3-44

PARAGRAPH keyword, 4-46

paragraph section

defining, 7-9

viewing system-defined, H-8

paragraph-level Gist and theme summary

generating, 8-5

parallel indexing, 2-15

example, 2-19

parameters

setting, 6-3

parentheses

altering precedence, 4-5, 5-2

grouping character, 5-2

path attribute, 3-7

PATH environment variable

setting for Inso, C-3

pending DML

viewing, 2-9, 12-4, H-9

performance

wildcard searches, 4-42

personality mask for ctxsrv, 12-2

PKENCODE function, 8-19

plain text

bypassing filtering, 3-21

filtering to, 8-2

highlight markup, 8-13

indexing, 3-22

indexing with NULL_FILTER, 3-24

offsets for highlighting, 8-10

plain text filtering, 1-13

Portuguese

supplied stoplist, E-9

precedence of operators, 4-3

altering, 4-5, 5-2

equivalence operator, 4-15

preference classes

preference values

preferences

about, 3-2

creating, 7-24

dropping, 7-31

replacing, 2-4

specifying for indexing, 2-15

system-defined, 3-50

viewing, H-9

preferred term operator

example, 4-26

printjoins attribute, 3-30

procedure attribute, 3-12

proximity operator, see NEAR operator

PT function, 11-37

PT operator, 4-26

punctuations attribute, 3-30

query

query example, 1-10

query features, 1-11

querying

about, 1-10

r_table_clause attribute, 3-44

rebuilding index

related term operator, 4-27

syntax, 2-4

RECOVER procedure, 6-2

related term query feedback, 10-9

relevance ranking

word queries, G-2

REMOVE_SECTION procedure, 7-36

REMOVE_SQE procedure, 10-13

REMOVE_STOPCLASS procedure, 7-38

REMOVE_STOPTHEME procedure, 7-39

REMOVE_STOPWORD procedure, 7-40

renaming index, 2-2

repeated field sections

querying, 4-46

replacing preferences, 2-4

reserved words and characters, 5-4

escaping, 5-3

response time

improving, A-5

optimizing for example, 1-11

result buffer size

resuming failed index, 2-5

RFC 1738 URL specification, 3-8

roles

system-defined, 1-4

RT function, 11-39

RT operator, 4-27

Salton's formula for scoring, G-2

scope notes

scoring

for NEAR operator, 4-21

scoring algorithm

word queries, G-2

section group

creating, 7-27

dropping, 7-32

viewing information about, H-10

section group example, 3-47

section group types, 3-46, 7-27

section searching, 4-43

nested, 4-45

sections

adding dynamically, 2-4

contraints for dynamic addition, 2-9

creating attribute, 7-3

viewing information on, H-10

SENTENCE keyword, 4-46

sentence section

defining, 7-9

SET_ATTRIBUTE procedure, 7-41

sentence-level Gist and theme summary

generating, 8-5

server

DML, 12-2

shutting down, 6-5, 12-4

viewing active, H-11

SET_KEY_TYPE procedure, 8-21

SET_PARAMETER procedure, 3-54, 6-3

SHUTDOWN procedure, 6-5

Simplified Chinese

index defaults, 3-52

single themes

obtaining (example), 8-24

single-byte languages

indexing, 3-28

skipjoins attribute, 3-31

SN procedure, 11-41

SORT_AREA_SIZE parameter, A-9

soundex operator, 4-28

Spanish

startjoins attribute, 3-31

supplied stoplist, E-10

special section

SQL commands

SQL operators

SQL*Loader

example control file, D-4

example data file, D-5

sqlldr example, D-3

START_LOG procedure, 9-4

statistics

optimizing with, A-2

stem operator, 4-29

stemmer attribute, 3-40

stemming, 3-40

automatic, 3-39

default, 1-7

example for enabling, 3-42

stop section

adding dynamically, 2-6

dynamically adding example, 2-8

stop sections

stopclass

stoplist

Dutch, E-4

stoplists

stoptheme

stopword

adding dynamically, 2-4, 2-5

defining, 7-15

removing, 7-40

viewing all in stoplist, H-12

stopword transformation, I-2

example for creating, 3-42

stopwords

adding dynamically, 3-48

removing, 3-49

storage defaults, 3-44

storage index preference

example, 7-25

storage objects, 3-43

STORE_SQE procedure

example, 4-30

syntax, 10-14

stored queries, 4-30

stored query expression

creating, 10-14

removing, 10-13

viewing, H-17

viewing definition, H-11

sub-lexers

viewing, H-13

substring index

substring_index attribute, 3-41

supplied stoplists, E-1

Swedish

alternate spelling, F-5

index defaults, 1-8, 3-52

supplied stoplist, E-11

SYN function, 11-40, 11-42

SYN operator, 4-31

synchronizing index, 1-9

background, 12-2

batch example, 2-8

synonym operator, 4-31

system parameters, 3-54

defaults for indexing, 3-55

system recovery

manual, 6-2

system-defined preferences, 3-50

table structure

Gist, B-8

tagged text

text column

loading, See loading text

supported types, 1-5, 2-14

Text data dictionary

text-only index

theme highlighting

generating markup, 8-13

generating offsets, 8-10

HTML markup example, 8-17

HTML offset example, 8-12

theme index

as default in English, 1-8, 3-51

creating, 3-33

theme query, See ABOUT

theme summary

theme table

theme_language attribute, 3-33

themes

generating for document, 8-22

generating highlight markup, 8-13

highlight offset example, 8-12

indexing, 3-33

THEMES procedure, 8-22

result table, B-11

THES_TT procedure, 11-45

thesaurus

compiling, 12-12

creating, 11-20

creating relationships, 11-16

DEFAULT, 4-13

dropping, 11-26

import/export examples, 12-11

importing/exporting, 12-6

procedures for browsing, 11-1

renaming and truncating, 11-5

viewing information about, H-13

thesaurus import file

thesaurus phrases

thesaurus relations

thesaurus scope note

thesaurus top terms

threshold operator, 4-33

stopword transformations, I-7

throughput

improving query, A-8

timeout attribute, 3-9

tohangeul attribute, 3-37

top term operator, 4-38

toupper attribute, 3-37

TR function, 11-46

TR operator, 4-34

transformation

stopword, I-2

translation term operator, 4-34

translation term synonym operator, 4-36

TRSYN function, 11-48

TRSYN operator, 4-36

TT function, 11-50

TT operator, 4-38

tuning queries

for response time, 1-11, A-5

for throughput, A-8

increasing result buffer size, A-9

with statistics, A-2

udic attribute, 3-37

UNIX platforms

setting variables for Inso, C-3

UNSET_ATTRIBUTE procedure, 7-43

URL syntax, 3-8

URL_DATASTORE object

attributes for, 3-8

example, 3-11

URL_DATASTORE system-defined preference, 3-50

urlsize attribute, 3-10

user

system-defined, 1-4

USER_DATASTORE object, 3-12

example, 3-13

USER_FILTER object, 3-25

example, 3-25

UTF8 character set, 3-28, 3-37

utilities

viewing

operator expansion, 10-6

operator precedence, 10-6

views, H-1

visible flag for field sections, 7-6

visible flag in field sections, 4-45

weight operator, 4-39

stopword transformations, I-7

whitespace attribute, 3-32

wildcard searches, 4-41

improving performance, 4-42

WITHIN operator, 4-43

attribute sections, 4-46

limitations, 4-49

nested, 4-45

precedence, 4-4

stopword transformations, I-7

word query

example, 1-10

xdic attribute, 3-37

XML documents

attribute sections, 7-3

doctype sensitive sections, 7-21

indexing, 3-46, 7-28

querying, 4-46

XML_SECTION_GROUP object, 3-46, 7-27

zone section

adding dynamically, 2-5

creating, 7-20

dynamically adding example, 2-8