Index

AUTOB predefined indexing preference, 8-16

applications

sample, 2-5

ASCII text. See plain text

attributes

base_letter, 8-67

binary, 8-34, 8-35

code_conversion, 8-51

optimize_default, 8-74

path, 8-36

soundex_at_index, 8-81

startjoins, 6-45, 8-66

viewing values for, B-17

whitespace, 8-67

automated

batch text loading, 7-2, 7-5

DML Queue notification, 6-3

Autorecognize filter, 8-16, 8-43

formats supported by, 8-43

in Filter preferences, 9-20

base_letter attribute, 8-67

base-letter conversion, 8-57

in text queries, 8-58

in UTF-8 databases, 8-59

setting NLS_LANG for, 8-58

BASIC LEXER Tile

attributes for, 8-62

in text indexing policies, 8-57

NLS compliance for, 8-59

BASIC_HTML_FILTER predefined indexing preference, 8-17

BASIC_HTML_LEXER predefined indexing preference, 8-18

BASIC_HTML_SECTION predefined section group, 6-48

BASIC_HTML_WORDLIST predefined indexing preference, 8-20

batch mode

DML operations, 6-4

processing in DML Queue, 2-18

text loading using ConText servers, 7-2

text loading using ctxload, 6-12

BFILE datatype, 6-8

binary attribute

for MASTER DETAIL NEW Tile, 8-35

for MASTER DETAIL Tile, 8-34

BLASTER FILTER Tile, 9-20

attributes for, 8-50

BLOB datatype, 6-8

broader terms

generic hierarchy, 6-38

in thesauri, 6-37

instance hierarchy, 6-38

multiple occurrences in a hierarchy, 6-38

partitive hierarchy, 6-38

calling

procedures within stored procedures, 3-4

procedures within triggers, 3-4

CANCEL procedure, 5-12

using, 3-12

CANCEL_ALL procedure, 5-13

CANCEL_USER procedure, 5-14

case-sensitivity

for piecewise optimization, 6-28

in composite word indexes, 8-60

in stoplists, 8-84

in theme indexes, 6-18

in thesauri, 6-35

categories

See also indexing Tiles, text loading Tiles

Engine (text loading), 7-12

Filter, 8-49

Reader, 7-9

Translator, 7-10

CHANGE_MASK procedure, 5-3

using, 3-9

changing

personality masks for ConText servers, 3-9

Query pipe buffer size, 5-7

CHAR datatype, 6-8

character sets

7-bit, 8-56

8-bit, 8-56, 8-58

supported for German or Dutch composite word indexing, 8-60

characters

base-letter conversion for, 8-33

continuation, 8-64

in multi-byte languages, 8-56

in single-byte languages, 8-56

specifying for newline, 8-67

specifying for whitespace, 8-67

startjoin and endjoin, 6-45, 8-66

Chinese language

CLEAR_ALL_ERRORS procedure, 5-15

pattern matching, 8-68

CHINESE V-GRAM LEXER Tile

attributes for, 8-68

classes. See categories

CLEAR_ATTRIBUTES procedure, 11-8

CLEAR_ERROR procedure, 5-16, B-6

using, 3-12

CLEAR_INDEX_ERRORS procedure, 5-17

CLEAR_LING_ERRORS procedure, 5-18

CLOB datatype, 6-8

code_conversion attribute, 8-51

column policies

See also policies

creating, 11-12

viewing, B-22

columns

See also text columns

loading text into, 6-2

requirements for automated batch loading, 7-5

textkey, 9-28

with multiple indexes, 6-19

with multiple policies, 8-6

command attribute, 7-10, 8-53

command-line

See also utilities

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

compaction

in-place, 6-26

two-table, 6-26

composite attribute, 8-67

composite textkeys, 6-9

column length limitations, 6-10

column name limitations, 6-9

creating policies with, 9-13

updating documents containing, 10-6

composite word indexing

enabling for German or Dutch text, 8-67

for Dutch text, 8-60

for German text, 8-60

compound words

in German or Dutch text, 8-60

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

CONTAINS

cursor (in-memory queries), 6-6

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

SQL function (one-step queries), 6-6, 6-19

ConText

description, 1-2

features, 1-3

overview of administration, 1-7

related publications, xx

ConText data dictionary

creating a preference for a Tile, 11-15

description, 2-8

querying objects, B-10

storing sources, 7-5

viewing preference categories, B-12

viewing Tiles, B-14

ConText index tables

multiple rows for tokens, 6-22

Oracle indexes for, C-5

specifying additional parameters for, 8-75

specifying STORAGE clauses for, 8-74

specifying tablespaces for, 8-74

ConText indexes

ConText indexing

in parallel, 6-21, 9-17, 9-26

memory allocation for, 6-20, 6-22, 8-73, 9-17

Oracle indexes created during, C-5

Tiles for, 8-13

ConText Linguistics. See Linguistics

ConText queues. See queues

ConText roles, 2-3

administration tools, 1-11

ConText server processes. See ConText servers

ConText servers, 1-4, 2-9

ConText users

See also users

creating, 3-3

managing, 3-3

predefined, 2-5

ConText Workbench

loading/updating/exporting text using, 9-2

continuation attribute, 8-64

control tables, C-3

in ConText indexes, 6-19, 6-25

conventions

notational, xxiii

conversion

base-letter, 8-57

CREATE_INDEX procedure, 11-9

using, 9-25

CREATE_PHRASE function, 11-50

using, 9-35

CREATE_POLICY procedure, 11-12

using, 9-10, 9-12

CREATE_PREFERENCE procedure, 11-15

using, 9-23

CREATE_SECTION_GROUP procedure, 11-16

CREATE_SOURCE procedure, 11-17

CREATE_TEMPLATE_POLICY procedure, 11-19

using, 9-10

CREATE_THESAURUS function, 11-53

using, 9-33, 9-34

creating

case-sensitive thesauri, 9-34

column policies, 9-10

ConText indexes, 9-25

ConText users, 3-3

Engine preferences (indexing), 9-17

Engine preferences (text loading), 9-5

Filter preferences for external filters, 9-21

Filter preferences for internal filters, 9-20

indexes in parallel, 9-26

Oracle indexes in parallel, 9-27

phrases in thesauri, 11-50

policies for columns in object tables, 9-11

policies for detail tables, 8-26

policies for master tables, 8-25

policies using composite textkeys, 9-13

preferences, 9-15

Reader preferences, 9-4

section groups, 9-37

sections, 9-37

sources, 9-5

stoplists, 8-85, 9-23

supplied stoplists, A-2

template policies, 9-10

text indexing policies, 9-10

theme indexing policies, 9-12

Theme Lexer preferences, 9-22

thesauri, 6-30

thesaurus entries, 9-35

thesaurus output files, 9-36

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-11, B-4

CTX_ALL_DML_SUM view, 3-11, B-4

CTX_ALL_PREFERENCES view, B-10

CTX_ALL_QUEUE view, 3-11, B-5

CTX_ALL_SECTION_GROUPS view, B-11

CTX_ALL_SECTIONS view, B-10

CTX_ALL_SERVERS view, B-2

using, 3-9

CTX_ALL_THESAURI view, B-11, B-29

CTX_CLASS view, B-12

CTX_COLUMN_POLICIES view, B-12

CTX_DDL package, 11-2

CTX_DML package, 11-42

REINDEX, 11-43

SYNC, 11-46

SYNC_QUERY, 11-48

CTX_INDEX_ERRORS view, B-6

viewing errors for automated batch loading, 7-3

viewing URL indexing errors, 8-31

CTX_INDEX_LOG view, 6-23, B-13

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-20, B-7

CTX_OBJECT_ATTRIBUTES view, B-15

CTX_OBJECT_ATTRIBUTES_LOV view, B-15

CTX_OBJECTS view, B-14

CTX_POLICIES view, B-16

CTX_PREFERENCE_ATTRIBUTES view, B-17

CTX_PREFERENCE_USAGE view, B-18

CTX_PREFERENCES view, B-17

CTX_SERVERS view, B-3

CTX_SOURCE view, B-18

CTX_SQES view, B-19

CTX_SVC package, 3-12, 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-20

CTX_SYSTEM_PREFERENCES view, B-20

CTX_SYSTEM_TEMPLATE_POLICIES view, B-21

CTX_TEMPLATE_POLICIES view, B-21

CTX_THES package, 11-49

CREATE_PHRASE, 11-50

CREATE_THESAURUS, 11-53

DROP_THESAURUS, 11-54

for thesauri maintenance, 6-30

CTX_USER_COLUMN_POLICIES view, B-22

CTX_USER_DML_QUEUE view, 3-11, B-8

CTX_USER_DML_SUM view, 3-11, B-8

CTX_USER_INDEX_LOG view, 6-23, B-23

CTX_USER_POLICIES view, B-24

CTX_USER_PREFERENCE_ATTRIBUTES view, B-25

CTX_USER_PREFERENCE_USAGE view, B-25

CTX_USER_PREFERENCES view, B-24

CTX_USER_QUEUE view, 3-11, B-9

CTX_USER_SECTION_GROUPS view, B-26

CTX_USER_SECTIONS view, B-26

CTX_USER_SOURCES view, B-27

CTX_USER_SQES view, B-28

CTX_USER_SVCQ view, B-9

CTX_USER_TEMPLATE_POLICIES view, B-28

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

CTXDEMO user

privileges, 2-5

ctxload utility, 6-12, 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-33, 9-34

using to export thesauri, 9-36

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-7, 4-2

syntax, 4-2

using, 3-7

CTXSYS user, 3-3

ConText data dictionary, 2-8

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

privileges, 2-5

starting ConText servers, 4-2

temporary tablespaces, 9-26

viewing preferences owned by, B-20

CTXUSER role, 2-4

limitations on importing/exporting, 3-3

customer support

contacting, xxiv

Danish language

supplied stoplist, A-5

data dictionary. See ConText data dictionary

Data Store Tiles, 8-33

preference example, 8-39

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, xix

datatypes

for text columns, 6-8

date format

specifying for ctxload, 10-7

DBA

personality, 2-13

responsibilities, 2-2

DDL

description, 6-2

personality, 2-12, 2-17, 4-3, 6-24

DDL operations, 6-2

for theme indexes, 6-24

DDL pipe

disabling/enabling, 3-13

requests for DDL operations, 6-2

default

personality mask, 4-3

preferences, 8-9

stoplist, 8-21

thesaurus, 6-33

DEFAULT_DIRECT_DATASTORE predefined indexing preference, 8-14

DEFAULT_INDEX predefined indexing preference, 8-19

DEFAULT_LEXER predefined indexing preference, 8-18

DEFAULT_LOADER predefined text loading preference, 7-8

DEFAULT_NULL_FILTER predefined indexing preference, 8-17

DEFAULT_OSFILE predefined indexing preference, 8-14

DEFAULT_POLICY template policy, 8-9

DEFAULT_READER predefined text loading preference, 7-8

DEFAULT_STOPLIST predefined indexing preference, 8-21

list of stop words for, A-4

DEFAULT_TRANSLATOR predefined text loading preference, 7-8

DEFAULT_URL predefined indexing preference, 8-14

deferred deletion

of ConText index entries, 6-25

defining

thesaurus relationships between terms, 6-30

deleting

See also dropping

database schema objects, 5-6

document references in ConText indexes, 6-25, 6-27

rows in CTX_INDEX_ERRORS, B-6

sections, 9-39

triggers, 11-22

derivational stemming

enabling for English, 8-81

detail_key attribute, 8-35

detail_lineno attribute, 8-35

detail_table attribute, 8-35

detail_text attribute, 8-35

diacritical marks

conversion during text indexing, 8-58

direct data store, 6-12, 8-23

loading text using ctxload, 9-3

DIRECT Tile, 8-33

directories

ConText servers scanning for text loading, 6-2

specifying for text loading, 7-9

specifying in external data store, 8-27

directories attribute, 7-9

DIRECTORY READER Tile

disabling

DML

personality, 2-12, 2-17, 4-3, 6-4, 6-24

processing, 6-4

DML operations, 2-18, 11-42

automated processing of, 6-3

batch mode, 2-17, 6-24, 11-46

batch mode processing of, 6-4

for theme indexes, 6-24

immediate mode, 2-17, 6-4

manual processing of, 6-4

DML operations immediate mode, 6-24

DML Queue, 2-17

batch processing of pending rows, 2-18, 11-46

disabling/enabling, 2-19, 2-20, 3-13

error handling, 2-19

requests for DML operations, 6-3

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, 8-30

changes affecting ConText indexes, 6-25

exporting, 9-8, 10-2

exporting example, 10-9

native format storage, 8-49

sections in, 6-41

stored inside database, 8-27

stored outside database, 8-27

uniquely identifying using textkeys, 6-8

updating, 9-8, 10-2

updating example, 10-9

with indexed words, C-3

DR_nnnnn_I1Tn table, 6-25, C-2

using for piecewise optimization, 6-29

DR_nnnnn_I1W table, C-4

DR_nnnnn_KTB table, C-3

DR_nnnnn_LST table, 6-25, 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-29

DROP_INTTRIG procedure, 11-22

DROP_POLICY procedure, 11-23

using, 9-14

DROP_PREFERENCE procedure, 11-24

using, 9-24

DROP_SECTION_GROUP procedure, 11-25

DROP_SOURCE procedure, 11-26

DROP_THESAURUS procedure, 11-54

using, 9-36

dropping

ConText indexes, 9-29

Dutch language

composite word indexing, 8-60

queries for composite words in, 8-61

supplied stoplist, A-6

embedded text, 10-2

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

enabling

base-letter conversion, 8-58

case-sensitive text indexes, 8-67

fuzzy matching, 8-78

German or Dutch composite word indexing, 8-67

pipes, 3-13

queues, 3-13

sentence/paragraph searching, 8-67

Soundex, 8-79, 8-81

stemming, 8-77

end markers

in ctxload load files, 10-11

end tags

for sections, 6-43

endjoins attribute, 6-45, 8-66

ENGINE NOP Tile, 8-72

Engine preferences (indexing)

creating, 9-17

setting attributes for PARALLEL, 9-27

Engine preferences (text loading)

creating, 9-5

Engine Tiles (indexing), 8-72

preference example, 8-76

Engine Tiles (text loading)

list of, 7-12

English language

clearing disabled queues, 5-9

predefined stoplist, A-4

environment variables

NLS_LANG, 8-58

TWO_TASK, 4-2, 10-4

error handling

DDL operations, 2-16

DML Queue, 2-19

for automated batch loading, 7-3

for URL data store, 8-30, 8-32

Services Queue, 2-20

errored requests

removing from Services Queue, 3-12

examples

executable attribute, 8-50

executables

ctxsrv, 4-2

EXECUTE privileges

documents to OS files, 9-8, 10-2

packages requiring, 3-5

expanding

queries, 6-31

expansion

query, 8-77

exporting

schema objects, 3-3

thesauri, 6-30, 9-36, 10-3

external data store

loading text using ctxload, 9-3

external filters, D-2

executables, 8-44

indexing text in unsupported formats, 8-43

performance, 8-44

specifying for mixed-format columns, 8-50

specifying for single-format columns, 8-53

supplied by ConText, D-6

using to perform document cleanup, 8-43

external text, 8-27

directory paths in, 8-27

file accessibility for indexing, 8-28

file permissions for indexing, 8-28

storing as file names, 8-27

storing as URLs, 8-28

Tile for, 8-36, 8-37

features

ConText, 1-3

file names

in ctxload load file, 10-13

file pointers, 10-2

in load files, 6-12, 10-7

storing, 10-2

file protocol

in URL data store, 8-29

File Transfer Protocol. See FTP

FILTER NOP Tile, 8-51

Filter Tiles

list of, 8-49

preference example, 8-53

filtering

formatted text, 8-42

HTML text, 8-41

mixed-format columns, 8-47

plain text, 8-41

single-format columns, 8-46

filters

external, 8-43, 8-50, 8-53, D-2

internal, 8-41, 8-51

Finnish language

supplied stoplist, A-7

firewalls. See gateway proxies

format attribute, 8-51

format ID

for document formats, D-2

using in Filter preferences, 9-21

formatted text

filtering, 8-42

supported formats for external filters, 8-48

supported formats for internal filters, 8-42

formatting

text load files, 10-11

thesaurus import files, 10-14

fragmentation

in ConText indexes, 6-21

through immediate DML processing, 6-4

French language

supplied stoplist, A-8

FRENCH_STOPLIST predefined indexing preference, 8-21

FTP

in URLs, 8-29

ftp_proxy attribute, 8-38

functions

CREATE_PHRASE, 11-50

CREATE_THESAURUS, 11-53

GET_QUEUE_STATUS, 5-4

fuzzy matching

specifying a method, 8-81

fuzzy_match attribute, 8-81

garbage collection. See actual deletion

gateway proxies

accessing the World Wide Web, 8-30

for URL data store, 8-30, 8-31

generating

Gists, 6-7

GENERIC ENGINE Tile

generic hierarchies

GENERIC LOADER Tile

GENERIC STOP LIST Tile, 9-23

attributes for, 8-85

GENERIC WORD LIST Tile

attributes for, 8-80

German language

composite word indexing, 8-60

queries for composite words in, 8-61

supplied stoplist, A-9

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-13, 6-7

GRANT command, 3-4

granting

ConText roles to users, 3-4

EXECUTE privileges to users, 3-4

groups

section, 6-47

hanzi_indexing attribute, 8-68

header markers

in ctxload load file, 10-11

hierarchical relationships

in thesauri, 6-37

in thesaurus import file, 10-16

hitlists, 8-2

homographs

qualifiers for, 6-39

HTML

filtering tags in, 8-52

internal filter, 8-16

text, 8-51

text filtering for sections, 6-46

text stored as URLs, 8-28

HTML FILTER Tile

attributes for, 8-51

HTML_FILTER predefined indexing preference, 8-17

HTTP

in URLs, 8-29

http_proxy attribute, 8-38

HyperText Markup Language. See HTML

HyperText Transfer Protocol. See HTTP

immediate DML processing, 6-4

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-30, 10-3

index entries in, 6-28

index_memory attribute, 8-73

indexes. See ConText indexes, Oracle indexes

indexing

See also ConText indexing

existing columns, 9-28

HTML text, 8-42

overview, 8-2

overview of, 1-9

text in unsupported formats, 8-43

indexing Tiles

Engine, 8-72

Filter, 8-49

Wordlist, 8-80

inflectional stemming

enabling, 8-81

initialization parameters

TEXT_ENABLE, 3-2

USER_DUMP_DEST, 4-3

initialization stage

for index creation, 6-20

initsid.ora file, 4-3

in-memory queries, 6-6

using composite textkeys, 6-9

in-place

compaction, 6-26

deletion, 6-27

input files

for external filters, 8-44

installing

supplied external filters, D-8

instance hierarchies

in thesauri, 6-38

instclause attribute, 8-81

internal filters, 8-41, 8-51

supported formats, 8-49

internal tables

ConText index tables, 6-19, C-2

SQE results, C-6

internal text

storage, 8-23

Tile for, 8-34

intranets

indexing using URL data store, 8-30

I/O utility

in ConText Workbench, 9-2

issues for external filters, 8-44

Italian language

supplied stoplist, A-10

Japanese language

HTML text conversion, 8-51

kanji_indexing attribute, 8-69

pattern matching, 8-69

JAPANESE V-GRAM LEXER Tile

attributes for, 8-69

keep_tag attribute, 8-52

Knowledge Catalog, 6-17, 6-18

Korean language

lexers for, 8-57

KOREAN LEXER Tile, 8-69

KOREAN predefined indexing preference, 8-18

KOREAN_WORDLIST predefined indexing preference, 8-20

languages

multi-byte, 8-56

single-byte, 8-56

supported for fuzzy matching, 8-78

supported for Soundex, 8-79

supported for stemming, 8-77

supported for text indexing, 8-56

supported for theme indexing, 8-57

Lexer Tiles

list of, 8-62

preference examples, 8-70

lexers

text indexing, 6-15

theme indexing, 6-17

limitations

composite textkeys, 6-9, 6-10

for importing/exporting schema objects, 3-3

German or Dutch composite word indexing, 8-60

policies on master tables, 8-25

redirection for URL data store, 8-31

sections, 6-46

thesaurus query expansion, 6-31

UTF-8 character set, 8-59

linguistic output, 2-13, 6-7

generated by Linguistics, 6-7

used in theme indexes, 6-17

linguistic settings, 6-18

Linguistics

enabling, 3-7

personality for, 2-13, 3-6, 4-3

processing HTML text through, 8-42

requests for, 2-19, 6-7

viewing errored requests, B-7, B-9

load files, 6-12, 10-2

and the separate option, 10-8

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-11, 4-3, 6-2, 6-13, 7-9

loading

See also importing

file pointers using ctxload, 7-12

text, 6-2, 6-11, 6-13

text from client-side files, 6-13

text into direct data store columns, 9-3

text into LONG and LONG RAW columns, 10-2

text using ConText servers, 7-2, 9-3

text using ctxload, 9-2, 10-2

thesauri, 10-3

LOBs

support for, 6-8

log files

for ctxload, 9-2, 10-8

for ctxsrv, 4-3

logs

for ConText indexes, 6-22

for ConText servers, 2-10

using index logs, 9-31

LONG columns

in sources, 7-5

loading text into, 10-2

LONG datatype, 6-8

LONG RAW columns

in sources, 7-5

loading text into, 10-2

LONG RAW datatype, 6-8

longsize attribute, 7-12

longsize option (ctxload), 10-7

Lotus 123 format

internal filter, 8-16

internal filters, 8-42

Lotus Freelance format

DML Queue notification, 6-4

maintaining

thesauri, 6-30

managing

ConText indexes, 9-25

ConText servers, 3-6, 4-5

manual

mapping tables, C-3

in ConText indexes, 6-19

markers

in ctxload load file, 10-11

MASTER DETAIL NEW Tile, 8-25

attributes for, 8-35

MASTER DETAIL Tile, 8-26

attributes for, 8-34

master-detail

tables, 8-24

text storage, 8-24

maxdocsize attribute, 8-38

maximum file size

maximum length

maximum number of rows

MD_BINARY predefined indexing preference, 8-15

maxthread attribute, 8-37

maxurls attribute, 8-38

MD_TEXT predefined indexing preference, 8-15

memory

allocating for ConText indexing, 6-20, 6-22

allocating for parallel ConText indexing, 6-21

in GENERIC ENGINE Tile, 8-72

Microsoft Excel format

supplied external filters, D-7

Microsoft PowerPoint format

Microsoft Word format

internal filters, 8-16, 8-42

supplied external filters, D-7

mixed_case attribute, 8-67

mixed-format columns, 8-47

filtering using external filters, 9-21

filtering using internal filters, 9-20

supported formats for, D-2

modifying

policies, 9-14

multi-byte languages

specifying for URL Tile, 8-37

multi-lingual environments

using UTF-8 in, 8-59

multi-threading

with URL data store, 8-31

narrower terms

generic hierarchy, 6-38

in thesauri, 6-37

instance hierarchy, 6-38

multiple occurrences in a hierarchy, 6-38

partitive hierarchy, 6-38

National Language Support (NLS), 8-58

compliance with, 8-59

enabling support for, 8-59

newline attribute, 8-67

newline characters

in ctxload load file, 10-12

NLS_LANG environment variable

base-letter conversion, 8-58

no_proxy attribute, 8-39

NO_SOUNDEX predefined indexing preference, 8-20

NO_STOPLIST predefined indexing preference, 8-21

nouns

decompounding in German or Dutch text, 8-60

NULL TRANSLATOR Tile, 7-10

numgroup attribute, 8-64

numjoin attribute, 8-64

object tables

See also tables

creating policies for, 9-11

indexes for, 6-14

requirements for, 6-9

specifying textkeys for, 9-12

objects. See Tiles

offsets

for tokens in text indexes, 6-15

one-step queries, 6-6

on columns with multiple indexes, 6-19

operations

See also text operations

optimize_default attribute, 8-74

OPTIMIZE_INDEX procedure, 11-27

using, 9-30

optimizing

ConText indexes, 6-26, 9-30

guidelines for, 6-29

individual words and phrases, 9-31

individual words in indexes, 6-27

Oracle Corporation

customer support, xxiv

Oracle indexes

creating in parallel, 9-27

for ConText index tables, C-5

for SQE results tables, C-6

specifying additional parameters, 8-75

specifying PARALLEL clauses for, 9-27

specifying STORAGE clauses for, 8-74, 8-81

specifying tablespaces for, 8-74

Oracle servers, 1-4

See also ConText servers

Oracle8 ConText Cartridge. See ConText

OSFILE Tile

attributes for, 8-36

other_parms attributes, 8-75

output files

for external filters, 8-44

packages. See PL/SQL packages

paragraph searching

enabling, 8-67

PARALLEL clause

for Oracle indexes, 8-75

setting for Oracle indexes, 9-27

parallel ConText indexing, 6-21, 9-26

memory allocation for, 9-17

parallel creation of Oracle indexes, 9-27

parallel processing

using SYNC, 6-5

parallel query option, 8-75, 9-27

parameters

for ConText index tables, 8-75

for Oracle indexes, 8-75

partitive hierarchies

in thesauri, 6-38

passwords

masking in ctxsrv, 3-7, 4-2

supplying through files, 3-7

path attribute, 8-36

pattern matching

Chinese language, 8-68

Japanese language, 8-69

PDF format

processing using SYNC, 6-5

pending requests

removing from Services Queue, 3-12

performance, 8-44

permissions

granting permissions for external text files, 8-28

personalities

DBA, 2-13

DDL, 2-12

DML, 2-12

Linguistic, 2-13

Loader, 2-11

Query, 2-12

personality masks, 2-11

changing, 3-9

default, 4-3

phrases

creating in thesauri, 9-35

creating relationships for, 9-35

in theme indexes, 6-17, 8-57

pictorial languages

token recognition for, 6-15

piecewise optimization, 6-28

case-sensitivity in, 6-28

example of, 9-31

identifying words for, 6-29

pipes

administration, 2-16

DDL, 2-16

increasing the size of, 5-7

query, 2-16

Text Request Queue, 2-16

plain text

filtering, 8-41

PL/SQL

reserved words, 3-4, 9-9

PL/SQL packages

granting EXECUTE privileges for, 3-5

policies

population stage

for index creation, 6-20

Portuguese language

supplied stoplist, A-11

predefined ConText users, 2-5

predefined preferences, 7-6, 8-13

See also preferences

predefined section groups, 6-48

predefined template policies, 8-9

preferences

creating, 9-15

dropping, 9-24, 11-24

enabling base-letter conversion, 8-58

Engine (text loading), 7-12

Filter, 8-49

for indexing, 8-12

in sources, 7-6

predefined, 7-8, 8-13

viewing attributes for, B-17

viewing policies for, B-18

preferred terms

in synonym rings, 6-36

primary keys, 6-8, 9-28

in object tables, 6-9

printjoins attribute, 8-64

procedures

CLEAR_ALL_ERRORS, 5-15

CLEAR_ATTRIBUTES, 11-8

CLEAR_ERROR, 5-16

CLEAR_INDEX_ERRORS, 5-17

CLEAR_LING_ERRORS, 5-18

CREATE_INDEX, 11-9

CREATE_POLICY, 11-12

CREATE_PREFERENCE, 11-15

CREATE_SECTION_GROUP, 11-16

CREATE_SOURCE, 11-17

CREATE_TEMPLATE_POLICY, 11-19

DROP_INDEX, 11-21

DROP_INTTRIG, 11-22

DROP_POLICY, 11-23

DROP_PREFERENCE, 11-24

DROP_SECTION_GROUP, 11-25

DROP_SOURCE, 11-26

DROP_THESAURUS, 11-54

GET_INFO, 5-22

OPTIMIZE_INDEX, 11-27

RECOVER, 5-6

REINDEX, 11-43

REMOVE_SECTION, 11-30

RESUME_FAILED_INDEX, 11-31

SET_ATTRIBUTE, 11-34

SET_QUERY_BUFFER_SIZE, 5-7

SHUTDOWN, 5-8

SYNC, 11-46

UPDATE_POLICY, 11-38

UPDATE_QUEUE_STATUS, 5-9

UPDATE_SOURCE, 11-40

UPGRADE_INDEX, 11-37

processes

See also ConText servers

processing

DML requests in parallel, 6-5

HTML text through Linguistics, 8-42

text before indexing, 8-43

protocols

URL support for, 8-29

proxies

gateway, 8-30, 8-31

punctuations attribute, 8-65

punctuation marks

indexing, 6-15

lexing, 8-56

qualifiers

in thesauri, 6-39

queries

in Text Request Queue, 2-16

SQEs, 6-6

Query

personality, 2-12, 4-3

query expansion

using fuzzy matching, 8-78

query operators

query options

Query pipe

disabling/enabling, 3-13

increasing buffer size, 5-7

queues

disabling/enabling, 3-13, 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-13

Reader Tiles

list of, 7-9

real-time

ConText index updates in, 6-4

RECOVER procedure, 2-14, 5-6

recovery

system, 2-14

redirection

with URL data store, 8-31

REINDEX procedure, 11-43, B-6

manually reindexing documents, 6-4

using, 9-29

related terms

in thesauri, 6-39

relationships

defining in thesauri, 9-35

relevance ranking

in theme queries, 6-18

REMOVE_SECTION procedure, 11-30

removing

errored requests from Services Queue, 3-12

pending requests from Services Queue, 3-12

sections from section groups, 9-39

REQUEST_STATUS function, 5-19

using, 3-11

requirements

for indexes on object tables, 6-9

reserved words, 3-4, 9-9

responsibilities

DBA, 2-2

system administrator, 2-2

results

from queries, 8-2

RESUME_FAILED_INDEX procedure, 11-31

using, 9-31

resuming

failed index creation/optimization, 9-31

roles. See ConText roles

rows

deleting from text columns, 6-3

deleting in CTX_INDEX_ERRORS, B-6

inserting into text columns, 6-3

multiple entries in index tables, 6-22

updating in text columns, 6-3

sample applications, 2-5

scanning

directories, 6-2

scope notes

in thesauri, 6-40

scoring

in queries, 6-6

in theme queries, 6-18

section groups

creating, 9-37

dropping, 9-39

for text queries, 6-47

in policies, 9-38

managing, 9-37

predefined, 6-48

specifying for text columns, 8-82

viewing, 9-38

section searching

process for enabling, 6-49

template policy for, 8-10

using document sections, 6-41

WITHIN operator for, 6-48

section_group attribute, 8-82

sections, 6-43

adding to section groups, 9-37

creating, 9-37

deleting, 9-39

filtering HTML text for, 6-46

limitations for, 6-46

managing, 9-37

optimizing in indexes, 6-28

removing from a section group, 9-39

section groups for, 6-47

self-enclosing, 6-45

start and end tags for, 6-43

template policy for, 8-10

top-level, 6-45

viewing, 9-38

security

masking CTXSYS passwords, 3-7

self-enclosing sections, 6-45

sent_para attribute, 8-67

sentence searching

enabling, 8-67

separate attribute, 7-12

separate option

for ConText servers with Loader personality, 7-12

for ctxload, 10-7

sequences

for external filters, 9-21

for generating textkeys, 9-7

for stop words, 9-23

servers. See ConText servers

Services Queue, 2-19

enabling/disabling, 3-13

error handling, 2-20

querying requests, 11-2

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

requesting status, 5-19

tables, 2-20

updating status, 5-9

viewing requests in, 3-11

viewing status of, 3-11, 5-4

sessions

errors in ctxsrv log, 4-3

information in ctxsrv log, 4-3

SET_ATTRIBUTE procedure, 11-34

SET_QUERY_BUFFER_SIZE procedure, 5-7

setting

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

Query pipe buffer size, 5-7

setting up

text, 1-8, 1-9

settings

linguistic, 6-18

SHUTDOWN procedure, 5-8

using, 3-10

shutting down

ConText servers, 3-10

ConText servers using ctxctl, 4-6

single-byte languages