Index

AUTOB predefined indexing preference, 7-19

ANSI Z39.19 thesauri, 6-59

applications

sample, 2-5

ASCII text. See plain text

attributes

base_letter, 7-42

binary, 7-27, 7-28

code_conversion, 7-34

optimize_default, 7-51

path, 7-29

soundex_at_index, 7-57

startjoins, 6-72, 7-44

viewing values for, B-20

automated

batch text loading, 6-14, 8-3

DML Queue notification, 6-4

Autorecognize filter, 6-33, 7-19

filtering mixed-format columns, 6-32

formats supported by, 6-33

in Filter preferences, 9-15

base_letter attribute, 7-42

base-letter conversion, 6-57

in text queries, 6-58

in UTF-8 databases, 7-38

setting NLS_LANG for, 6-57

BASIC LEXER Tile

attributes for, 7-41

in text indexing policies, 7-4

NLS compliance for, 7-38

BASIC_HTML_FILTER predefined indexing preference, 7-20

BASIC_HTML_LEXER predefined indexing preference, 7-21

BASIC_HTML_SECTION predefined section group, 6-74

BASIC_HTML_WORDLIST predefined indexing preference, 7-23

batch mode

DML operations, 6-5

processing in DML Queue, 2-16

text loading using ConText servers, 6-14

text loading using ctxload, 6-13

BFILE datatype, 6-10

binary attribute

for MASTER DETAIL NEW Tile, 7-28

for MASTER DETAIL Tile, 7-27

BLASTER FILTER Tile, 9-15

attributes for, 7-33

BLOB datatype, 6-10

broader terms

generic hierarchy, 6-65

in thesauri, 6-64

instance hierarchy, 6-65

multiple occurrences in a hierarchy, 6-65

partitive hierarchy, 6-65

calling

procedures within stored procedures, 3-5

procedures within triggers, 3-5

CANCEL procedure, 5-12

using, 3-13

CANCEL_ALL procedure, 5-13

CANCEL_USER procedure, 5-14

case-sensitivity

in composite word indexes, 7-39

in stoplists, 6-51, 7-24, 7-25

in text indexes, 6-50

in theme indexes, 6-54

in thesauri, 6-60

categories

See also indexing Tiles, text loading Tiles

Data Store, 7-26

Engine (indexing), 7-49

Engine (text loading), 8-8

Filter, 7-32

Lexer, 7-37

Reader, 8-7

Stoplist, 7-59

Translator, 8-9

Wordlist, 7-54

CHANGE_MASK procedure, 5-3

using, 3-10

changing

personality masks for ConText servers, 3-10

Query pipe buffer size, 5-7

CHAR datatype, 6-10

character sets

7-bit, 7-37

8-bit, 6-57, 7-37

supported for German composite word indexing, 7-39

characters

base-letter conversion for, 6-57

continuation, 7-42

in multi-byte languages, 7-37

in single-byte languages, 7-37

startjoin and endjoin, 6-72, 7-44

Chinese language

CLEAR_ALL_ERRORS procedure, 5-15

pattern matching, 7-46

CHINESE V-GRAM LEXER Tile

attributes for, 7-46

classes. See categories

CLEAR_ATTRIBUTES procedure, 11-8

CLEAR_ERROR procedure, 5-16, B-6

using, 3-13

CLEAR_INDEX_ERRORS procedure, 5-17

CLEAR_LING_ERRORS procedure, 5-18

CLOB datatype, 6-10

code_conversion attribute, 7-34

column policies

See also policies

creating, 11-12

viewing, B-25

columns

See also text columns

defining as text columns, 7-3

loading text into, 6-3

requirements for automated batch loading, 8-3

textkey, 9-31

with multiple indexes, 6-43

with multiple policies, 7-4

command attribute, 7-35, 8-9

command-line

See also utilities

administration, 1-10, 3-1, 9-1

compaction

in-place, 6-46

two-table, 6-46

composite attribute, 7-45

composite textkeys, 6-11

column length limitations, 6-11

column name limitations, 6-11

creating policies with, 9-24

updating documents containing, 10-6

composite word indexing

enabling for German text, 7-45

for German text, 7-39

compound words

in German text, 7-39

Configuration Manager, 1-11, 3-1, 9-1

CONTAINS

cursor (in-memory queries), 6-8

PL/SQL procedure (two-step queries), 6-7

SQL function (one-step queries), 6-8, 6-43

ConText

administration, 1-7

description, 1-2

features, 1-3

related publications, xx

ConText data dictionary

creating a preference for a Tile, 11-15

description, 6-2

querying objects, B-11

storing policies, 7-3

storing sources, 8-3

viewing preference categories, B-13

viewing Tiles, B-16

ConText index tables

multiple rows for tokens, 6-44

Oracle indexes for, C-5

specifying additional parameters for, 7-52

specifying STORAGE clauses for, 7-51

specifying tablespaces for, 7-51

ConText indexes

ConText indexing

in parallel, 6-45, 9-12, 9-29

memory allocation for, 6-43, 6-44, 7-50, 9-12

Oracle indexes created during, C-5

policy requirements for, 7-3

Tiles for, 7-16

ConText Linguistics. See Linguistics

ConText queues. See queues

ConText roles, 2-3

defining custom setting configurations, 1-9

ConText server processes. See ConText servers

ConText servers, 1-4, 2-7

ConText users, 2-5

See also users

creating, 3-4

managing, 3-3

ConText Workbench

administration tools, 1-11

loading/updating/exporting text using, 9-2

continuation attribute, 7-42

control tables, C-3

in ConText indexes, 6-42, 6-45

conventions

notational, xxii

conversion

base-letter, 6-57

CREATE_INDEX procedure, 11-9

using, 9-28

CREATE_PHRASE function, 11-48

using, 9-36

CREATE_POLICY procedure, 11-12

creating template policies, 9-25

using, 9-22, 9-23

CREATE_PREFERENCE procedure, 11-15

using, 9-19

CREATE_SECTION_GROUP procedure, 11-16

CREATE_SOURCE procedure, 11-17

CREATE_TEMPLATE_POLICY procedure, 11-19

using, 9-25

CREATE_THESAURUS function, 11-50

using, 9-35, 9-36

creating

case-sensitive thesauri, 9-35

column policies, 9-22

ConText indexes, 9-28

ConText users, 3-4

Engine preferences (indexing), 9-12

Engine preferences (text loading), 9-5

Filter preferences for external filters, 9-16

Filter preferences for internal filters, 9-15

indexes in parallel, 9-29

Oracle indexes in parallel, 9-29

phrases in thesauri, 11-48

policies for detail tables, 6-20

policies for master tables, 6-19

policies using composite textkeys, 9-24

preferences, 9-11

Reader preferences, 9-4

section groups, 9-39

sections, 9-39

sources, 9-6

stoplists, 7-59, 9-19

template policies, 9-25

text indexing policies, 9-22

theme indexing policies, 9-23

Theme Lexer preferences, 9-18

thesauri, 6-59, 9-35

thesaurus entries, 9-36

thesaurus output files, 9-37

Translator preferences, 9-4, 9-5

CTX_ADM package

CHANGE_MASK, 5-3

GET_QUEUE_STATUS, 5-4

RECOVER, 5-6

SET_QUERY_BUFFER_SIZE, 5-7

SHUTDOWN, 5-8

UPDATE_QUEUE_STATUS, 5-9

CTX_ALL_DML_QUEUE view, 3-12, B-4

CTX_ALL_DML_SUM view, 3-12, B-4

CTX_ALL_PREFERENCES view, B-11

CTX_ALL_QUEUE view, 3-12, B-5

CTX_ALL_SECTION_GROUPS view, B-12

CTX_ALL_SECTIONS view, B-12

CTX_ALL_SERVERS view, B-2

using, 3-9

CTX_ALL_THESAURI view, B-13, B-31

CTX_CLASS view, B-13

CTX_COLUMN_POLICIES view, B-14

CTX_DDL package, 11-2

CTX_DML package, 11-41

REINDEX, 11-42

SYNC, 11-44

SYNC_QUERY, 11-46

CTX_INDEX_ERRORS view, B-6

viewing errors for automated batch loading, 6-15

viewing URL indexing errors, 6-26

CTX_INDEX_LOG view, 6-48, B-15

CTX_INDEX_STATUS view, B-7

CTX_INFO package, 5-21

GET_INFO, 5-22

GET_STATUS, 5-23

GET_VERSION, 5-24

CTX_LING package

for requesting Linguistics, 3-12

CTX_LING_ERRORS view, 2-19, B-7

CTX_OBJECT_ATTRIBUTES view, B-17

CTX_OBJECT_ATTRIBUTES_LOV view, B-18

CTX_OBJECTS view, B-16

CTX_POLICIES view, B-19

CTX_PREFERENCE_ATTRIBUTES view, B-20

CTX_PREFERENCE_USAGE view, B-21

CTX_PREFERENCES view, B-20

CTX_SERVERS view, B-3

CTX_SOURCE view, B-22

CTX_SQES view, B-23

CTX_SVC package, 3-13, 11-2

CANCEL, 5-12

CANCEL_ALL, 5-13

CANCEL_USER, 5-14

CLEAR_ALL_ERRORS, 5-15

CLEAR_ERROR, 5-16

CLEAR_INDEX_ERRORS, 5-17

CLEAR_LING_ERRORS, 5-18

REQUEST_STATUS, 5-19

CTX_SYSTEM_PREFERENCE_USAGE view, B-24

CTX_SYSTEM_PREFERENCES view, B-23

CTX_SYSTEM_TEMPLATE_POLICIES view, B-24

CTX_TEMPLATE_POLICIES view, B-24

CTX_THES package, 11-47

CREATE_PHRASE, 11-48

CREATE_THESAURUS, 11-50

DROP_THESAURUS, 11-51

for thesauri maintenance, 6-59

CTX_USER_COLUMN_POLICIES view, B-25

CTX_USER_DML_QUEUE view, 3-12, B-8

CTX_USER_DML_SUM view, 3-12, B-8

CTX_USER_INDEX_LOG view, 6-48, B-26

CTX_USER_POLICIES view, B-27

CTX_USER_PREFERENCE_ATTRIBUTES view, B-28

CTX_USER_PREFERENCE_USAGE view, B-28

CTX_USER_PREFERENCES view, B-27

CTX_USER_QUEUE view, 3-12, B-9

CTX_USER_SECTION_GROUPS view, B-29

CTX_USER_SECTIONS view, B-29

CTX_USER_SOURCES view, B-30

CTX_USER_SQES view, B-31

CTX_USER_SVCQ view, B-10

CTX_USER_TEMPLATE_POLICIES view, B-31

CTXADMIN role, 2-4

CTXAPP role, 2-4

shutting down ConText servers, 3-10

ctxctl utility, 4-5

examples, 4-6

starting ConText servers, 3-8

starting the utility, 4-5

syntax, 4-5

viewing ConText server status, 3-9

CTXDEMO user

privileges, 2-5

ctxload utility, 6-13, 10-2

command-line restrictions, 10-8

mandatory arguments, 10-4

optional arguments, 10-6

syntax, 10-4

text load example, 10-9

thesaurus export example, 10-10

thesaurus import example, 10-10

using to create thesauri, 9-35, 9-36

using to export thesauri, 9-37

using to load file pointers, 9-3

using with external data store columns, 9-3

ctxsrv executable, 4-2

See also ConText servers

masking CTXSYS password in, 3-8, 4-2

syntax, 4-2

using, 3-7

CTXSYS user, 3-4

ConText data dictionary, 6-2

masking password in ctxsrv, 3-8, 4-2

privileges, 2-5

starting ConText servers, 4-2

temporary tablespaces, 9-28

viewing preferences owned by, B-23

CTXUSER role, 2-4

limitations on importing/exporting, 3-3

customer support

contacting, xxiii

data dictionary. See ConText data dictionary

Data Store Tiles, 7-26

list of, 7-26

preference example, 7-31

database administrator. See DBA

database indexes. See Oracle indexes

database pipes. See pipes

database schema objects

deleting, 5-6

database triggers. See triggers

database views. See views, 1-1

datatypes

for text columns, 6-10

date format

specifying for ctxload, 10-8

DBA

personality, 2-11

responsibilities, 2-2

DDL

description, 6-3

personality, 2-10, 2-15, 4-3

DDL operations, 6-3

for text indexes, 6-52

for theme indexes, 6-56

DDL pipe

disabling/enabling, 3-14

requests for DDL operations, 6-3

default

personality mask, 4-3

preferences, 7-12

stoplist, 7-24

thesaurus, 6-60

DEFAULT_DIRECT_DATASTORE predefined indexing preference, 7-17

DEFAULT_INDEX predefined indexing preference, 7-22

DEFAULT_LEXER predefined indexing preference, 7-21

DEFAULT_LOADER predefined text loading preference, 8-6

DEFAULT_NULL_FILTER predefined indexing preference, 7-20

DEFAULT_OSFILE predefined indexing preference, 7-17

DEFAULT_POLICY template policy, 7-12

DEFAULT_READER predefined text loading preference, 8-6

DEFAULT_STOPLIST predefined indexing preference, 7-24

DEFAULT_TRANSLATOR predefined text loading preference, 8-6

DEFAULT_URL predefined indexing preference, 7-17

deferred deletion

of ConText index entries, 6-45

defining

columns as text columns, 7-3

thesaurus relationships between terms, 6-59

deleting

See also dropping

database schema objects, 5-6

document references in ConText indexes, 6-45, 6-47

rows in CTX_INDEX_ERRORS, B-6

sections, 9-40

triggers, 11-22

derivational stemming

enabling for English, 7-57

detail_key attribute, 7-28

detail_lineno attribute, 7-28

detail_table attribute, 7-28

detail_text attribute, 7-28

diacritical marks

conversion during text indexing, 6-57

direct data store, 6-14, 6-16

loading text using ctxload, 9-3

DIRECT Tile, 7-27

directories

ConText servers scanning for text loading, 6-3

specifying for text loading, 8-7

specifying in external data store, 6-21

directories attribute, 8-7

DIRECTORY READER Tile

attributes for, 8-7

disabling

pipes, 3-14

queues, 3-14, 5-10

DML

description, 6-4

personality, 2-10, 2-15, 4-3, 6-5

processing, 6-5

DML operations, 2-16, 11-41

automated processing of, 6-4

automatic processing of, 6-4

batch mode, 2-15, 11-44

batch mode processing of, 6-5

for text indexes, 6-52

for theme indexes, 6-56

immediate mode, 2-15, 6-5

manual processing of, 6-5

DML Queue, 2-15

batch processing of pending rows, 2-16, 11-44

disabling/enabling, 2-17, 3-14

error handling, 2-17

requests for DML operations, 6-4

viewing status of, 5-4

views, B-4, B-5, B-7, B-8, B-9

documents

See also rows, text

accessing through HTTP/FTP, 6-24

changes affecting ConText indexes, 6-45

exporting, 9-9, 10-3

exporting example, 10-10

native format storage, 7-32

sections in, 6-68

stored inside database, 6-17

stored outside database, 6-17

uniquely identifying using textkeys, 6-10

updating, 9-8, 10-3

updating example, 10-9

with indexed words, C-3

DR_nnnnn_I1Tn table, 6-45, C-2

DR_nnnnn_I1W table, C-4

DR_nnnnn_KTB table, C-3

DR_nnnnn_LST table, 6-45, C-3

DR_nnnnn_NLT table, C-3

DR_nnnnn_SQR table, C-6

Oracle index for, C-6

DROP_INDEX procedure, 11-21

using, 9-32

DROP_INTTRIG procedure, 11-22

DROP_POLICY procedure, 11-23

using, 9-26

DROP_PREFERENCE procedure, 11-24

using, 9-20

DROP_SECTION_GROUP procedure, 11-25

DROP_SOURCE procedure, 11-26

DROP_THESAURUS procedure, 11-51

using, 9-37

dropping

ConText indexes, 9-32

in ctxload load files, 10-8, 10-13

enabling

base-letter conversion, 6-57

fuzzy matching, 7-54

German composite word indexing, 7-45

pipes, 3-14

queues, 3-14

Soundex, 7-55, 7-57

stemming, 7-54

end markers

in ctxload load files, 10-11

end tags

for sections, 6-69

endjoins attribute, 6-72, 7-44

ENGINE NOP Tile, 7-50

Engine preferences (indexing)

creating, 9-12

setting attributes for PARALLEL, 9-29

Engine preferences (text loading)

creating, 9-5

Engine Tiles (indexing), 7-49

list of, 7-49

preference example, 7-53

Engine Tiles (text loading)

list of, 8-8

English language

clearing disabled queues, 5-9

predefined stoplist, A-2

environment variables

NLS_LANG, 6-57

TWO_TASK, 4-2, 10-4

error handling

DDL operations, 2-14

DML Queue, 2-17

for automated batch loading, 6-15

for URL data store, 6-23, 6-26

Services Queue, 2-19

errored requests

removing from Services Queue, 3-13

examples

executable attribute, 7-33

executables

ctxsrv, 4-2

EXECUTE privileges

granting to users, 3-5

packages requiring, 3-5

expanding

queries, 6-60

exporting

documents to OS files, 9-9, 10-3

schema objects, 3-3

thesauri, 6-59, 9-37, 10-3

external data store

loading text using ctxload, 9-3

external filters, 6-35

executables, 6-30

filtering mixed-format columns, 6-32, 6-33

indexing text in unsupported formats, 6-30

performance, 6-31

specifying for mixed-format columns, 7-33

specifying for single-format columns, 7-35

supplied, 6-38

supplied by ConText, 6-38

using to perform document cleanup, 6-30

external text, 6-17

directory paths in, 6-21

file accessibility for indexing, 6-21

file permissions for indexing, 6-21

storing as file names, 6-21

storing as URLs, 6-22

Tile for, 7-29

features

ConText, 1-3

file names

in ctxload load file, 10-13

file pointers, 10-2

in load files, 6-13, 10-7

storing, 10-2

file protocol

in URL data store, 6-23

File Transfer Protocol. See FTP

FILTER NOP Tile, 7-34

Filter Tiles, 7-32

list of, 7-32

preference example, 7-36

filtering

formatted text, 6-28

HTML text, 6-28

mixed-format columns, 6-32

plain text, 6-28

single-format columns, 6-32

filters

external, 6-30, 6-35, 7-33, 7-35

internal, 6-28, 7-33

firewalls. See gateway proxies

format attribute, 7-33

format ID

for document formats, 6-35

using in Filter preferences, 9-17

formatted text

filtering, 6-28

supported formats for external filters, 6-35

supported formats for internal filters, 6-28

formatting

text load files, 10-11

thesaurus import files, 10-14

fragmentation

in ConText indexes, 6-44

in theme indexes, 6-55

through immediate DML processing, 6-5

French language

predefined stoplist, A-3

FRENCH_STOPLIST predefined indexing preference, 7-25

FTP

in URLs, 6-23

ftp_proxy attribute, 7-31

functions

CREATE_PHRASE, 11-48

CREATE_THESAURUS, 11-50

GET_QUEUE_STATUS, 5-4

fuzzy matching

specifying a method, 7-57

fuzzy_match attribute, 7-57

garbage collection. See actual deletion

gateway proxies

accessing the World Wide Web, 6-24

for URL data store, 6-24

generating

Gists, 6-9

GENERIC ENGINE Tile

generic hierarchies

GENERIC LOADER Tile

GENERIC STOP LIST Tile, 9-19

attributes for, 7-59

GENERIC WORD LIST Tile

attributes for, 7-57

German language

composite word indexing, 7-39

predefined stoplist, A-4

queries for composite words in, 7-40

GERMAN_STOPLIST predefined indexing preference, 7-25

GET_INFO procedure, 5-22

GET_QUEUE_STATUS function, 5-4, 5-9

GET_STATUS function, 5-23

GET_VERSION function, 5-24

Gists, 2-11, 6-9

GRANT command, 3-5

granting

ConText roles to users, 3-4

EXECUTE privileges to users, 3-5

groups

section, 6-71

hanzi_indexing attribute, 7-46

header markers

in ctxload load file, 10-11

hierarchical relationships

in thesauri, 6-64

in thesaurus import file, 10-16

homographs

qualifiers for, 6-66

HTML

filtering tags in, 7-35

internal filter, 7-19

text, 7-34

text filtering for sections, 6-72

text stored as URLs, 6-22

HTML FILTER Tile

attributes for, 7-34

HTML_FILTER predefined indexing preference, 7-20

HTTP

in URLs, 6-22

http_proxy attribute, 7-31

HyperText Markup Language. See HTML

HyperText Transfer Protocol. See HTTP

I/O utility

in ConText Workbench, 9-2

immediate DML processing, 6-5

import files, 10-3, 10-5

alternate hierarchy structures in, 10-16

examples of, 10-19

formatting, 10-14

restrictions for thesaural relationships, 10-18

restrictions for thesaurus terms, 10-17

importing

schema objects, 3-3

thesauri, 6-59, 10-3

index_memory attribute, 7-50

indexes. See ConText indexes, Oracle indexes

indexing

See also ConText indexing

existing columns, 9-31

HTML text, 6-28

text in unsupported formats, 6-30

indexing Tiles

Lexer, 7-37

inflectional stemming

enabling, 7-57

initialization parameters

TEXT_ENABLE, 3-2

USER_DUMP_DEST, 4-3

initialization stage

for index creation, 6-43

initsid.ora file, 4-3

in-memory queries, 6-8

using composite textkeys, 6-11

in-place

compaction, 6-46

deletion, 6-47

input files

for external filters, 6-30

installing

internal filters, 6-28, 7-33

instance hierarchies

in thesauri, 6-65

instclause attribute, 7-57

filtering mixed-format columns, 6-32

supported formats, 7-32

internal tables

ConText index tables, 6-42, C-2

SQE results, C-6

internal text

storage, 6-16

Tile for, 7-27

intranets

indexing using URL data store, 6-24

ISO-2788 thesauri, 6-59

issues for external filters, 6-31

Italian language

predefined stoplist, A-5

ITALIAN_STOPLIST predefined indexing preference, 7-25

Japanese language

HTML text conversion, 7-34

kanji_indexing attribute, 7-46

pattern matching, 7-46

JAPANESE V-GRAM LEXER Tile

attributes for, 7-46

keep_tag attribute, 7-35

Knowledge Catalog, 6-53, 6-54

Korean language

lexers for, 6-49, 7-38

KOREAN LEXER Tile, 7-47

KOREAN predefined indexing preference, 7-21

KOREAN_WORDLIST predefined indexing preference, 7-23

languages

multi-byte, 7-37

single-byte, 6-57, 7-37

supported for fuzzy matching, 7-54

supported for Soundex, 7-55

supported for stemming, 7-54

supported for text indexing, 7-37

supported for theme indexing, 7-40

Lexer Tiles, 7-37

list of, 7-40

preference examples, 7-48

lexers

text indexing, 6-49

theme indexing, 6-53

limitations

composite textkeys, 6-11

for importing/exporting schema objects, 3-3

German composite word indexing, 7-39

policies on master tables, 6-19

redirection for URL data store, 6-25

sections, 6-70

supplied external PDF filter, 6-40

thesaurus query expansion, 6-61

UTF-8 character set, 7-38

linguistic output, 2-11, 6-9

generated by Linguistics, 6-9

used in theme indexes, 6-53

linguistic settings, 6-55

Linguistics

enabling, 3-7

personality for, 2-11, 3-7, 4-3

processing HTML text through, 6-28

requests for, 2-18, 6-9

setting up, 1-9

viewing errored requests, B-7, B-10

list of, 7-59

load files, 6-13, 10-2

and the separate option, 10-8

creating using translators, 6-14

example of embedded text in, 10-13

example of file pointers in, 10-13

formatting, 10-11

restrictions for structure of entries, 10-12

restrictions for syntax, 10-12

with embedded text, 10-8

Loader

personality, 2-9, 4-3, 6-3, 8-7

loading

See also importing

file pointers using ctxload, 8-8

text, 6-3, 6-13

text into direct data store columns, 9-3

text into LONG and LONG RAW columns, 10-2

text using ConText servers, 6-14, 9-4

text using ctxload, 9-2, 10-2

thesauri, 10-3

LOBs

support for, 6-10

log files

for ctxload, 9-3, 10-8

for ctxsrv, 4-3

logs

for ConText indexes, 6-47

for ConText servers, 2-8

using index logs, 9-33

LONG columns

in sources, 8-4

loading text into, 10-2

LONG datatype, 6-10

LONG RAW columns

in sources, 8-4

loading text into, 10-2

LONG RAW datatype, 6-10

longsize attribute, 8-8

longsize option (ctxload), 10-7

Lotus 123 format

internal filter, 7-19

internal filters, 6-29

Lotus Freelance format

DML Queue notification, 6-5

maintaining

thesauri, 6-59

managing

ConText indexes, 9-27

ConText servers, 3-6, 4-5

text, 1-8

manual

mapping tables, C-3

in ConText indexes, 6-42

markers

in ctxload load file, 10-11

MASTER DETAIL NEW Tile, 6-19

attributes for, 7-28

MASTER DETAIL Tile, 6-20

master-detail

maxdocsize attribute, 7-30

maximum file size

maximum length

maximum number of rows

MD_BINARY predefined indexing preference, 7-18

maxthread attribute, 7-30

maxurls attribute, 7-30

MD_TEXT predefined indexing preference, 7-18

memory

allocating for ConText indexing, 6-43, 6-44

allocating for parallel ConText indexing, 6-45

in GENERIC ENGINE Tile, 7-50

Microsoft Excel format

Microsoft PowerPoint format

internal filters, 6-29, 7-19

Microsoft Word format

filtering using external filters, 6-33, 9-17

mixed-format columns, 6-32

filtering using internal filters, 9-15

supported formats for, 6-35

modifying

policies, 9-25

multi-byte languages

lexers for, 7-37

multi-lingual environments

using UTF-8 in, 7-38

multi-threading

with URL data store, 6-25

narrower terms

generic hierarchy, 6-65

in thesauri, 6-64

instance hierarchy, 6-65

multiple occurrences in a hierarchy, 6-65

partitive hierarchy, 6-65

National Language Support (NLS), 6-57

compliance with, 7-38

enabling support for, 7-38

newline characters

in ctxload load file, 10-12

NLS_LANG environment variable

base-letter conversion, 6-57

no_proxy attribute, 7-31

NO_SOUNDEX predefined indexing preference, 7-23

NO_STOPLIST predefined indexing preference, 7-25

nouns

decompounding in German text, 7-39

NULL TRANSLATOR Tile, 8-9

numgroup attribute, 7-42

numjoin attribute, 7-42

objects. See Tiles

offsets

for tokens in text indexes, 6-50

one-step queries, 6-8

on columns with multiple indexes, 6-43

operations

See also text operations

optimize_default attribute, 7-51

OPTIMIZE_INDEX procedure, 11-27

using, 9-32

optimizing

ConText indexes, 9-32

guidelines for, 6-47

indexes, 6-46

optional attributes

for policies, 7-8

Oracle Corporation

customer support, xxiii

Oracle indexes

creating in parallel, 9-29

for ConText index tables, C-5

for SQE results tables, C-6

specifying additional parameters, 7-52

specifying PARALLEL clauses for, 9-29

specifying STORAGE clauses for, 7-52, 7-57

specifying tablespaces for, 7-51

Oracle servers, 1-4

See also ConText servers

Oracle8 ConText Cartridge. See ConText

OSFILE Tile, 6-21

attributes for, 7-29

other_parms attributes, 7-52

output files

for external filters, 6-30

packages. See PL/SQL packages

PARALLEL clause

for Oracle indexes, 7-52

setting for Oracle indexes, 9-29

parallel ConText indexing, 6-45, 9-29

memory allocation for, 9-12

parallel creation of Oracle indexes, 9-29

parallel processing

using SYNC, 6-5

parallel query option, 7-52, 9-29

parameters

for ConText index tables, 7-52

for Oracle indexes, 7-52

partitive hierarchies

in thesauri, 6-65

passwords

masking in ctxsrv, 3-8, 4-2

supplying through files, 3-8

path attribute, 7-29

pattern matching

Chinese language, 7-46

Japanese language, 7-46

PDF format

limitations, 6-40

removing from Services Queue, 3-13

pending requests

processing using SYNC, 6-5

performance, 6-31

permissions

granting permissions for external text files, 6-21

personalities

DBA, 2-11

DDL, 2-10

DML, 2-10

Linguistic, 2-11

Loader, 2-9

Query, 2-10

personality masks, 2-9

changing, 3-10

default, 4-3

phrases

creating in thesauri, 9-36

creating relationships for, 9-36

in theme indexes, 6-54, 7-40

pictorial languages

token recognition for, 6-50

pipes

administration, 2-14

DDL, 2-14

increasing the size of, 5-7

query, 2-14

Text Request Queue, 2-14

PL/SQL

reserved words, 3-4, 9-21

PL/SQL packages

granting EXECUTE privileges for, 3-5

plain text

filtering, 6-28

policies

population stage

for index creation, 6-43

predefined ConText users, 2-5

predefined preferences, 7-16, 8-5

See also preferences

predefined section groups, 6-74

predefined template policies, 7-11

preferences

preferred terms

in synonym rings, 6-63

primary keys, 6-10, 9-31

printjoins attribute, 7-43

procedures

processes

See also ConText servers

processing

DML requests in parallel, 6-5

HTML text through Linguistics, 6-28

text before indexing, 6-30

protocols

URL support for, 6-22, 6-23

proxies

gateway, 6-24

specifying for URL Tile, 7-31

punctuation marks

indexing, 6-50

lexing, 7-37

punctuations attribute, 7-43

qualifiers

in thesauri, 6-66

queries

in Text Request Queue, 2-14

SQEs, 6-8

Query

personality, 2-10, 4-3

query expansion

using fuzzy matching, 7-54

query operators

Query pipe

disabling/enabling, 3-14

increasing buffer size, 5-7

queues

disabling/enabling, 3-14, 5-10

managing, 3-11

updating, 5-9

viewing entries in, B-4

viewing status of, 5-4

quotation marks

in ctxload load file, 10-12

Reader Tiles

list of, 8-7

real-time

ConText index updates in, 6-5

RECOVER procedure, 2-12, 5-6

recovery

system, 2-12

redirection

with URL data store, 6-25

REINDEX procedure, 11-42, B-6

manually reindexing documents, 6-5

using, 9-31

related terms

in thesauri, 6-67

relationships

defining in thesauri, 9-36

relevance ranking

in theme queries, 6-54

REMOVE_SECTION procedure, 11-30

removing

errored requests from Services Queue, 3-13

pending requests from Services Queue, 3-13

sections from section groups, 9-40

REQUEST_STATUS function, 5-19

using, 3-12

requests

visible in pending table, 2-16

reserved words, 3-4, 9-21

responsibilities

DBA, 2-2

system administrator, 2-2

RESUME_FAILED_INDEX procedure, 11-31

using, 9-33

resuming

failed index operations, 9-33

roles. See ConText roles

rows

deleting from text columns, 6-4

deleting in CTX_INDEX_ERRORS, B-6

inserting into text columns, 6-4

multiple entries in index tables, 6-44

updating in text columns, 6-4

sample applications, 2-5

scanning

directories, 6-3

scope notes

in thesauri, 6-67

scoring

in queries, 6-7

in theme queries, 6-54

section groups

creating, 9-39

dropping, 9-41

for text queries, 6-71

predefined, 6-74

specifying for text columns, 7-58

viewing, 9-40

section searching

process for enabling, 6-73

template policy for, 7-13

using document sections, 6-68

WITHIN operator for, 6-74

section_group attribute, 7-58

sections, 6-68

adding to section groups, 9-39

creating, 9-39

deleting, 9-40

filtering HTML text for, 6-72

limitations for, 6-70

removing from a section group, 9-40

section groups for, 6-71

self-enclosing, 6-70

start and end tags for, 6-69

template policy for, 7-13

top-level, 6-70

viewing, 9-40

security

masking CTXSYS passwords, 3-8

self-enclosing sections, 6-70

separate attribute, 8-8

separate option

for ConText servers with Loader personality, 8-8

for ctxload, 10-7

sequences

for external filters, 9-17

for generating textkeys, 9-7

for stop words, 6-51, 9-19

servers. See ConText servers

Services Queue, 2-18

enabling/disabling, 2-19, 3-14

error handling, 2-19

querying requests, 11-2

removing requests, 5-12, 5-13, 5-14

requesting status, 5-19

tables, 2-18

updating status, 5-9

viewing requests in, 3-12

viewing status of, 3-12, 5-4

sessions

errors in ctxsrv log, 4-3

information in ctxsrv log, 4-3

SET_ATTRIBUTE procedure, 11-33

SET_QUERY_BUFFER_SIZE procedure, 5-7

setting

environment variables for ctxsrv, 4-2, 10-4

Query pipe buffer size, 5-7

setting configurations

setting up

settings

SHUTDOWN procedure, 5-8

using, 3-10

shutting down

ConText servers, 3-10

ConText servers using ctxctl, 4-6

single-byte languages, 6-57

lexers for, 7-37

single-format columns, 6-32

filtering using external filters, 9-16

filtering using internal filters, 9-15

skipjoins attribute, 7-44

SOUNDEX

predefined indexing preference, 7-23

SQL function, 7-55

Soundex, 7-55

enabling, 7-55, 7-57

wordlist table, 6-42, C-4

soundex_at_index attribute, 7-57

source policies. See template policies

sources, 2-9, 6-14

attributes, 8-4

creating, 8-4, 9-6, 11-17

Spanish language

predefined stoplist, A-6

SPANISH_STOPLIST predefined indexing preference, 7-25

specifying

additional parameters for Oracle indexes, 9-29

directories to scan for text loading, 8-7

fuzzy matching method, 7-57

language for stemming, 7-57

personality mask for ctxsrv, 4-3

stop words, 7-59

STORAGE clauses for tables/indexes, 7-57

tablespaces for Oracle indexes, 7-51

translator for text loading, 8-9

SQE result tables, 6-8, C-6

in ConText indexes, 6-42

SQEs

storing results, 6-8

viewing, B-31

viewing results, 6-8

SQL

ALTER SESSION command, 3-2

CREATE USER command, 3-4

GRANT command, 3-4

reserved words, 3-4, 9-21

SQL*Loader, 6-13, 9-3

start tags

for sections, 6-69

starting

ConText servers, 3-7

ConText servers on remote machines, 4-2

ConText servers using ctxctl, 4-5

ConText servers with Loader personality, 9-6

startjoins attribute, 6-72, 7-44

status

monitoring ConText servers, B-2

queues, 5-4, 5-9

Services Queue, 5-19

stclause attribute, 7-57

stemmer attribute, 7-57

stemming

derivational, 7-57

enabling, 7-54

inflectional, 7-57

specifying a language for, 7-57

supported languages, 7-54

stop words

case-sensitivity for, 6-51

in text indexes, 6-51

in text queries, 6-51

maximum number in stoplists, 7-59

specifying, 7-59

stop_word attribute, 7-59

Stoplist Tiles, 7-59

preference example, 7-60

stoplists

case-sensitivity in, 6-51

creating, 7-59, 9-19

default, A-2

English, A-2

French, A-3

German, A-4

in text indexes, 6-51

Italian, A-5

maximum size, 9-19

Spanish, A-6

supported number of stop words, 7-59

storage attributes, 7-51

STORAGE clauses

for ConText index tables, 7-52, 9-12

for Oracle indexes, 7-52, 7-57

for wordlist tables, 7-57

stored procedures. See procedures

stored query expressions. See SQEs

storing

file names in text columns, 6-21

internal text, 6-16

text as multiple rows, 6-18

text in operating system files, 6-17

text using MASTER DETAIL, 7-27, 7-28

text using OSFILE, 7-29

text using URL, 7-29

URLs in text columns, 6-22

SUBMIT procedure

in CTX_LING package, 3-12