Index

AUTOB predefined preference, 10-25

applications

sample, 2-5

ASCII text. See plain text

attributes

values, 10-2, 10-19

viewing, B-6

automated

batch text loading, 4-13, 5-19

DML Queue notification, 4-3

Autorecognize filter, 4-30, 10-25

filtering mixed-format columns, 4-29

in Filter preferences, 6-13

supported formats, 4-30

base-letter conversion, 4-47

in text queries, 4-48

setting NLS_LANG, 4-47

BASIC LEXER Tile, 5-11, 10-10

in text indexing policies, 4-40

batch mode

DML operations, 4-4, 8-4

text loading using ConText servers, 4-13

text loading using ctxload, 4-12

BFILE datatype, 4-9

BLASTER FILTER Tile, 5-10, 6-13, 10-7

BLOB datatype, 4-9

broader generic terms, 4-52

broader partitive terms, 4-52

broader terms

multiple occurrences in a hierarchy, 4-52

calling

procedures within stored procedures, 3-4

procedures within triggers, 3-4

CANCEL procedure, 11-12

using, 3-12

CANCEL_ALL procedure, 11-13

CANCEL_USER procedure, 11-14

case sensitivity

in text indexes, 4-40

in theme indexes, 4-44

categories

CHANGE_MASK procedure, 11-3

using, 3-10

changing

personality masks for ConText servers, 3-10

Query pipe buffer size, 11-7

CHAR datatype, 4-9

character sets

7-bit, 5-6

8-bit, 4-47, 5-6

Chinese text

lexers for, 4-39, 5-6

pattern matching, 10-11

CHINESE V-GRAM LEXER Tile, 5-11, 10-11

choosing

an optimization method, 8-5

classes. See categories

CLEAR_ALL_ERRORS procedure, 11-15

CLEAR_ATTRIBUTES procedure, 11-22

CLEAR_ERROR procedure, 11-16, A-6

using, 3-13

CLEAR_INDEX_ERRORS procedure, 11-17

CLEAR_LING_ERRORS procedure, 11-18

client

column names

column policies

See also policies

creating, 11-24

viewing, B-12

columns

See also text columns

defining as text columns, 5-13

loading text into, 4-2

requirements for automated batch loading, 5-19

textkey, 6-27

with multiple indexes, 4-38

with multiple policies, 5-15

command-line

See also utilities

compaction

components

composite textkeys, 4-10

column length limitations, 4-10

column name limitations, 4-10

creating policies with, 6-20

configuring

ConText, 7-5

Linguistic Services, 7-7

consolidated server configuration, 7-5

CONTAINS

cursor (in-memory queries), 4-7

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

SQL function (one-step queries), 4-7, 4-38

ConText

related publications, xvi

ConText data dictionary

create a preference for a Tile, 11-27

description, 5-2

querying objects, B-2, B-8, B-18

storing policies, 5-13

storing sources, 5-19

viewing preference categories, B-8

viewing Tiles, B-8

ConText index tables

disk contention, 7-9

multiple rows for tokens, 4-34

Oracle indexes for, C-5

specifying additional parameters for, 10-14

specifying STORAGE clauses for, 10-14

specifying tablespaces for, 10-13

ConText indexes

ConText indexing

in parallel, 4-35, 6-10, 6-25

memory allocation for, 4-33, 4-34, 6-10, 7-2, 10-13

network requirements for, 7-2

Oracle indexes created during, C-5

policy requirements for, 5-13

Tiles for, 5-10

using a single CPU, 8-4

using multiple CPUs, 8-4

ConText queues. See queues

ConText roles, 2-3

ConText servers, 1-4, 2-7, 7-4

ConText server processes. See ConText servers

ConText users, 2-5

See also users

creating, 3-2

managing, 3-2

ConText Workbench, 1-11

control tables, C-3

CREATE_INDEX procedure, 11-23

in Context indexes, 4-35

conventions

notational, xviii

conversion

base-letter, 4-47

using, 6-24

CREATE_PHRASE function, 11-55

using, 6-32

CREATE_POLICY procedure, 11-24

creating template policies, 6-21

using, 6-18, 6-19

CREATE_PREFERENCE procedure, 11-27

using, 6-12

CREATE_SOURCE procedure, 11-28

CREATE_TEMPLATE_POLICY procedure, 11-30

using, 6-21

CREATE_THESAURUS function, 11-57

using, 6-31

creating

CTX_ADM package

CHANGE_MASK, 11-3

GET_QUEUE_STATUS, 11-4

RECOVER, 11-6

SET_QUERY_BUFFER_SIZE, 11-7

SHUTDOWN, 11-8

UPDATE_QUEUE_STATUS, 11-9

CTX_ALL_DML_QUEUE view, 3-11, A-4

CTX_ALL_DML_SUM view, 3-11, A-4

CTX_ALL_QUEUE view, 3-11, A-5

CTX_ALL_SERVERS view, A-2

using, 3-9

CTX_ALL_THESAURI view, B-18

CTX_CLASS view, B-8

CTX_COLUMN_POLICIES view, B-2

CTX_DDL package, 11-21

CLEAR_ATTRIBUTES, 11-22

CREATE_INDEX, 11-23

CREATE_POLICY, 11-24

CREATE_PREFERENCE, 11-27

CREATE_SOURCE, 11-28

CREATE_TEMPLATE_POLICY, 11-30

DROP_INDEX, 11-32

DROP_INTTRIG, 11-33

DROP_POLICY, 11-34

DROP_PREFERENCE, 11-35

DROP_SOURCE, 11-36

OPTIMIZE_INDEX, 11-37

RESUME_FAILED_INDEX, 11-40

SET_ATTRIBUTE, 11-43

UPDATE_POLICY, 11-45

UPDATE_SOURCE, 11-47

CTX_DML package, 11-49

REINDEX, 11-50

SYNC, 11-52

SYNC_QUERY, 11-53

CTX_INDEX_ERRORS view, A-6

viewing errors for automated batch loading, 4-14

viewing URL indexing errors, 4-22

CTX_INDEX_LOG view, 4-36, B-3

CTX_INDEX_STATUS view, A-7

CTX_INFO package, 11-59

GET_INFO, 11-60

GET_STATUS, 11-61

GET_VERSION, 11-62

CTX_LING package

for requesting Linguistic Services, 3-12

CTX_LING_ERRORS view, 2-20, A-7

CTX_OBJECT_ATTRIBUTES view, B-9

CTX_OBJECT_ATTRIBUTES_LOV view, B-10

CTX_OBJECTS view, B-8

CTX_POLICIES view, B-4

CTX_PREFERENCE_ATTRIBUTES view, B-6

CTX_PREFERENCE_USAGE view, B-6

CTX_PREFERENCES view, B-5

CTX_SERVERS view, A-3

CTX_SQES view, B-7

CTX_SVC package, 3-12, 11-11

CANCEL, 11-12

CANCEL_ALL, 11-13

CANCEL_USER, 11-14

CLEAR_ALL_ERRORS, 11-15

CLEAR_ERROR, 11-16

CLEAR_INDEX_ERRORS, 11-17

CLEAR_LING_ERRORS, 11-18

REQUEST_STATUS, 11-19

CTX_SYSTEM_PREFERENCE_USAGE view, B-11

CTX_SYSTEM_PREFERENCES view, B-10

CTX_SYSTEM_TEMPLATE_POLICIES view, B-11

CTX_TEMPLATE_POLICIES view, B-7

CTX_THES package, 11-54

CREATE_PHRASE, 11-55

CREATE_THESAURUS, 11-57

DROP_THESAURUS, 11-58

thesauri maintenance, 4-54

CTX_USER_COLUMN_POLICIES view, B-12

CTX_USER_DML_QUEUE view, 3-11, A-8

CTX_USER_DML_SUM view, 3-11, A-8

CTX_USER_INDEX_LOG view, 4-36, B-13

CTX_USER_POLICIES view, B-14

CTX_USER_PREFERENCE_ATTRIBUTES view, B-15

CTX_USER_PREFERENCE_USAGE view, B-16

CTX_USER_PREFERENCES view, B-15

CTX_USER_QUEUE view, 3-11, A-9

CTX_USER_SQES view, B-16

CTX_USER_SVCQ view, A-10

CTX_USER_TEMPLATE_POLICIES view, B-17

CTXADMIN role, 2-4

data dictionary views for, B-2, B-8

data dictionary views for, B-8

CTXAPP role, 2-4

shutting down ConText servers, 3-10

ctxctl utility, 9-6

examples, 9-7

starting, 9-6

starting ConText servers, 3-8

syntax, 9-6

viewing ConText server status, 3-9

CTXDEMO user

privileges, 2-5

ctxload utility, 4-12, 9-8

command-line restrictions, 9-12

mandatory arguments, 9-9

optional arguments, 9-10

syntax, 9-9

text load example, 9-12

thesaurus export example, 9-12

thesaurus import example, 9-12

using to create thesauri, 6-31

using to export thesauri, 6-33

using to load file pointers, 9-21

using with external data store columns, 9-21

ctxsrv executable, 9-2

See also ConText servers

masking CTXSYS password in, 3-7, 9-3

syntax, 9-2

theme indexing and queries with, 4-46

using, 3-6

ctxsrvx executable, 9-2

See also ConText servers

examples, 9-4

masking CTXSYS password in, 3-7, 9-3

syntax, 9-2

using, 3-7

CTXSYS user, 3-2

ConText data dictionary, 5-2

masking password in ctxsrv/ctxsrvx, 3-7, 9-3

privileges, 2-5

starting ConText servers, 9-2

temporary segments for, 8-2

temporary tablespaces, 6-24

viewing preferences owned by, B-10

CTXUSER role, 2-4

Data Store category, 10-3

customer support

contacting, xix

data dictionary. See ConText data dictionary

predefined preferences, 10-23

preference example, 10-5

Tiles, 5-3, 5-10

database administrator. See DBA

database pipes. See pipes

database triggers. See triggers

database views. See views, 1-1

datatypes

for text columns, 4-9

date format

specifying for ctxload, 9-11

DBA

personality, 2-12

responsibilities, 2-2

DDL

description, 4-3

personality, 2-10, 2-16, 9-3

DDL operations, 4-3

for text indexes, 4-41

for theme indexes, 4-45

requests for DDL operations, 4-3

DDL pipe

disabling/enabling, 3-13

default

personality mask, 9-3

preferences, 5-12, 10-22, 10-33, 10-36

stoplist, 10-31

thesaurus, 4-55

DEFAULT_DIRECT_DATASTORE predefined preference, 10-23

DEFAULT_INDEX predefined preference, 10-29

DEFAULT_LEXER predefined preference, 10-27

DEFAULT_LOADER predefined preference, 10-33

DEFAULT_NULL_FILTER predefined preference, 10-26

DEFAULT_OSFILE predefined preference, 10-23

DEFAULT_POLICY template policy, 10-36

DEFAULT_READER predefined preference, 10-33

DEFAULT_STOPLIST predefined preference, 10-31

DEFAULT_TRANSLATOR predefined preference, 10-34

DEFAULT_URL predefined preference, 10-23

deferred deletion

of ConText index entries, 4-35

defining

columns as text columns, 5-13

thesaurus relationships between terms, 4-49

deleting

document references in ConText indexes, 4-35, 4-37

policies, 6-22

preferences, 6-16

rows in CTX_INDEX_ERRORS, A-6

thesauri, 6-32

triggers, 11-33

derivational stemming, 10-17

diacritical marks

conversion during text indexing, 4-47

direct data store, 4-13, 4-15

loading text using ctxload, 9-21

DIRECT Tile, 5-10, 10-3

directories

ConText servers scanning for text loading, 4-2

specifying for text loading, 10-19

specifying in external data store, 4-18

DIRECTORY READER Tile, 5-11, 10-19

disabling

pipes, 3-13

queues, 3-13, 11-10

disk contention

in DDL operations, 7-9

in DML operations, 7-9

in queries, 7-9

distributed server configuration, 7-6

DML

description, 4-3

personality, 2-11, 2-16, 4-4, 9-3

processing, 4-4

DML operations, 2-17, 11-49

advantages of batch and immediate mode, 8-4

automated processing of, 4-3

automatic processing of, 4-3

batch mode, 2-16, 11-52

batch mode processing of, 4-4

for text indexes, 4-41

for theme indexes, 4-45

immediate mode, 2-16, 4-4

manual processing of, 4-4

DML Queue, 2-16

batch processing of pending rows, 11-52

disabling/enabling, 2-18, 3-13

error handling, 2-17

requests for DML operations, 4-3

tables, 2-17

timestamps, 2-17

updating status, 11-9

viewing, 2-16, 3-11

viewing status of, 11-4

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

documents

accessing through HTTP, 4-21

changes affecting ConText indexes, 4-35

native format storage, 5-4

stored inside database, 4-16

stored outside database, 4-16

theme signatures for, 4-44

uniquely identifying using textkeys, 4-9

with indexed words, C-3

DR_nnnnn_I1T table, 4-35

DR_nnnnn_I1Tn table, C-2

DR_nnnnn_I1W table, C-4

DR_nnnnn_KTB table, C-3

DR_nnnnn_LST table, 4-35, C-3

DR_nnnnn_SQR table, C-6

Oracle index for, C-6

DROP_INDEX procedure, 11-32

using, 6-28

DROP_INTTRIG procedure, 4-4, 11-33

DROP_POLICY procedure, 11-34

using, 6-22

DROP_PREFERENCE procedure, 11-35

using, 6-16

DROP_SOURCE procedure, 11-36

DROP_THESAURUS procedure, 11-58

using, 6-32

dropping

ConText indexes, 6-28

embedded text, 9-8

in ctxload load files, 9-12, 9-15

enabling

base-letter conversion, 4-47

end markers

in ctxload load files, 9-13

Engine (Text Loading) category, 5-11, 10-20

predefined preferences, 10-33

Engine category, 10-13

predefined preferences, 10-29

preference example, 10-15

Tiles, 5-7, 5-11

ENGINE NOP Tile, 10-13

Engine preferences

creating, 6-10

setting attributes for PARALLEL, 6-26

English text

lexers for, 4-39

environment variables

NLS_LANG, 4-47

TWO_TASK, 9-3, 9-9

error handling

clearing disabled queues, 11-9

DDL operations, 2-15

DML Queue, 2-17

for automated batch loading, 4-14

for URL data store, 4-20, 4-22

Services Queue, 2-20

errored requests

removing from Services Queue, 3-13

executables

ctxsrv and ctxsrvx, 9-2

EXECUTE privileges

granting to users, 3-4

packages requiring, 3-4

expanding

queries, 4-55

exporting

thesauri, 4-54, 6-33, 9-9

external data store

loading text using ctxload, 9-21

external filters, 10-38

executables, 4-26

filtering mixed-format columns, 4-29, 4-30

indexing text in unsupported formats, 4-26

performance, 4-27

specifying for mixed-format columns, 10-7

specifying for single-format columns, 10-8

supplied, 4-28

using to perform document cleanup, 4-26

external text, 4-16

directory paths in, 4-18

file accessibility for indexing, 4-18

file permissions for indexing, 4-18

storing as file names, 4-18

storing as URLs, 4-19

Tile for, 10-4

features

ConText, 1-3

file names

in ctxload load file, 9-15

file pointers, 9-8

in load files, 4-13, 9-11

storing, 9-8

file protocol

in URL data store, 4-20

Filter category, 10-6

predefined preferences, 10-25

preference example, 10-8

Tiles, 5-4, 5-10

FILTER NOP Tile, 5-10, 10-6

Filter preferences, 4-29

filtering

formatted text, 4-25

HTML text, 4-24

mixed-format columns, 4-29

plain text, 4-24

single-format columns, 4-29

filters

external, 4-26, 10-7, 10-8, 10-38

internal, 4-24, 10-7

firewalls. See gateway proxies

format ID

for document formats, 10-38

formatted text

filtering, 4-25

formatting

text load files, 9-13

thesaurus import files, 9-16

fragmentation

in ConText indexes, 4-34

in theme indexes, 4-45

through immediate DML processing, 4-4

functions

CREATE_PHRASE, 11-55

CREATE_THESAURUS, 11-57

GET_QUEUE_STATUS, 11-4

GET_STATUS, 11-61

GET_VERSION, 11-62

REQUEST_STATUS, 11-19

SYNC_QUERY, 11-53

fuzzy matching, 5-8

enabling, 5-8

specifying a method, 10-17

garbage collection. See actual deletion

gateway proxies

accessing the World Wide Web, 4-20

for URL data store, 4-20, 4-21

generating

Gists, 4-8

textkeys, 6-6

themes, 4-8

GENERIC ENGINE Tile, 5-11, 10-13

generic hierarchies

in thesauri, 4-52

GENERIC LOAD ENGINE Tile, 5-11

GENERIC STOP LIST Tile, 5-11, 6-12, 10-18

GENERIC WORD LIST Tile, 5-11, 10-16

GET_INFO procedure, 11-60

GET_QUEUE_STATUS function, 11-4, 11-9

GET_STATUS function, 11-61

GET_VERSION function, 11-62

Gists, 2-12, 4-8

GRANT command, 3-4

granting

ConText roles to users, 3-3

EXECUTE privileges to users, 3-4

header markers

in ctxload load file, 9-13

hierarchical relationships

text stored as URLs, 4-19

homographs

qualifiers for, 4-53

HTML

text, 10-7

HTML FILTER Tile, 5-10, 10-7

HTML_FILTER predefined preference, 10-26

HTTP

in URL data store, 4-19

hypertext markup language. See HTML

hypertext transfer protocol. See HTTP

I/O disk contention

See also disk contention

reducing, 7-9

immediate DML processing, 4-4, 8-4

import files, 9-9, 9-10

examples of, 9-20

formatting, 9-16

restrictions for thesaural relationships, 9-19

restrictions for thesaurus terms, 9-18

importing

thesauri, 4-54, 9-9

indexes. See ConText indexes, Oracle indexes

indexing

See also ConText indexing

existing columns, 6-27

HTML text, 4-24

setting SGA memory for, 8-2

text in unsupported formats, 4-26

indexing categories, 5-10

inflectional stemming, 10-17

initialization parameters

SORT_AREA_SIZE, 8-2

USER_DUMP_DEST, 9-4

initialization stage

for index creation, 4-33

INITRANS parameter

setting for parallel processing, 8-5

initsid.ora file, 9-4

in-memory queries, 4-7

using composite textkeys, 4-10

in-place compaction, 4-37

advantages of, 8-5

in-place deletion, 4-37

In-progress (DML) table, 2-17

input files

for external filters, 4-26

internal filters, 4-24, 10-7

filtering mixed-format columns, 4-29

supported formats, 5-4

internal tables

ConText index tables, 4-32, C-2

SQE results, C-6

internal text

storage, 4-15

Tile for, 10-3

internal triggers. See triggers

intranets

indexing using URL data store, 4-20

ISO-2788 thesauri, 4-49

Japanese text

HTML conversion, 10-7

lexers for, 4-39, 5-6

pattern matching, 10-11

JAPANESE V-GRAM LEXER Tile, 5-10, 10-11

Knowledge Catalog, 4-42, 4-45

KOREAN LEXER Tile, 5-10, 10-9

KOREAN predefined preference, 10-27

Korean text

lexers for, 4-39, 5-6

languages

multi-byte, 5-6

single-byte, 4-47, 5-5

Lexer category, 10-9

predefined preferences, 10-27

preference example, 10-11

Tiles, 5-5, 5-10

Lexer preferences

enabling base-letter conversion, 4-47

lexers

for text indexing, 4-39

for theme indexing, 4-42

limitations

for composite textkeys, 4-10

for query expansion, 4-56

Linguistic

personality, 2-12, 3-6, 9-3

linguistic output, 2-12

generated by Linguistic Services, 4-8

used in theme indexes, 4-42

Linguistic Services, 4-8

CPU requirements, 7-3

disabling, 9-2

memory requirements, 7-3

optimized processing, 7-7

processing HTML text, 4-24

requests, 2-19

setting up, 1-9

viewing errored requests, A-7, A-10

linguistic settings, 4-43

linguistics

disabling, 3-7

enabling, 3-6

load files, 4-12, 9-8

and the -separate option, 9-12

creating using translators, 4-13

example of embedded text in, 9-15

example of file pointers in, 9-15

formatting, 9-13

restrictions for structure of entries, 9-13

restrictions for syntax, 9-14

with embedded text, 9-12

Loader

personality, 2-10, 4-2, 9-3, 10-19

loading

See also importing

file pointers using ctxload, 10-20

text, 4-2, 4-12

text into direct data store columns, 9-21

text into LONG and LONG RAW columns, 9-8

text using ConText servers, 4-13, 6-3

text using ctxload, 6-2, 9-8

thesauri, 9-9

LOBs

support for, 4-9

log files

for ctxload, 6-3, 9-11

for ctxsrv/ctxsrvx, 9-4

logs

for ConText indexes, 4-36

for ConText servers, 2-8

using index logs, 6-29

LONG columns

in sources, 5-20

loading text into, 9-8

LONG datatype, 4-9

LONG RAW columns

in sources, 5-20

loading text into, 9-8

LONG RAW datatype, 4-9

longsize option (ctxload), 9-11

Lotus 123 format

ConText servers, 3-5, 9-6

maintaining

thesauri, 4-54

managing

ConText indexes, 6-23

manual

DML Queue notification, 4-4

mapping tables, C-3

in ctxload load file, 9-13

markers

MASTER DETAIL Tile, 5-10

master/detail

maximum file size

maximum length

maximum number of rows

MD_BINARY predefined preference, 10-24

MD_TEXT predefined preference, 10-24

memory

allocating for ConText indexing, 4-33, 4-34, 8-3

allocating for GENERIC ENGINE, 10-13

allocating for parallel ConText indexing, 4-35

effects on network speed, 8-6

real, 8-3

virtual, 7-2, 8-3

Microsoft Word format

filtering using external filters, 4-29, 4-30

mixed-format columns

supported formats for, 10-38

modifying

policies, 6-22

multi-byte languages

lexers for, 5-6

multi-threading

specifying for URL Tile, 10-4

with URL data store, 4-21

narrower generic terms, 4-52

narrower partitive terms, 4-52

narrower terms

multiple occurrences in a hierarchy, 4-52

National Language Support (NLS), 4-47

network speed, 7-5, 7-8

considerations, 7-6, 8-6

for queries, 8-8

newline characters

in ctxload load file, 9-14

NLS_LANG environment variable

base-letter conversion, 4-47

NO_SOUNDEX predefined preference, 10-30

NO_STOPLIST predefined preference, 10-32

NULL TRANSLATOR Tile, 5-11, 10-20

objects. See Tiles

offsets

for tokens in text indexes, 4-41

one-step queries, 4-7

on columns with multiple indexes, 4-38

operations

See also text operations

optimization methods

choosing, 8-5

OPTIMIZE_INDEX procedure, 11-37

using, 6-28

optimizing

ConText indexes, 6-28, 8-4, 8-5

guidelines for, 4-37

indexes, 4-36

optional attributes

for policies, 5-16

Oracle Corporation

customer support, xix

Oracle indexes

creating in parallel, 6-25

disk contention, 7-9

for ConText index tables, C-5

for SQE results tables, C-6

specifying additional parameters, 10-14

specifying PARALLEL clauses for, 6-26

specifying STORAGE clauses for, 10-14, 10-16

specifying tablespaces for, 10-13

Oracle servers, 1-4, 7-4

See also ConText servers

Oracle8 ConText Cartridge. See ConText

OSFILE Tile, 4-18, 5-10

attributes for, 10-4

output files

for external filters, 4-26

packages. See PL/SQL packages

PARALLEL clause

for Oracle indexes, 10-14

setting for Oracle indexes, 6-25

parallel ConText indexing, 4-35, 6-25

memory allocation for, 6-10

parallel creation of Oracle indexes, 6-25

parallel processing, 8-4

CPU requirements, 7-2

memory allocation for, 8-3

using SYNC, 4-5

parallel query option, 6-25, 10-14

parameters

for ConText index tables, 10-14

for Oracle indexes, 10-14

partitions

raw, 7-10

partitive hierarchies

in thesauri, 4-52

passwords

masking in ctxsrv/ctxsrvx, 3-7, 9-3

supplying through files, 3-8

pattern matching

Chinese text, 10-11

Japanese text, 10-11

Pending (DML) table, 2-17

pending requests

processing using SYNC, 4-5

removing from Services Queue, 3-12

permissions

granting permissions for external text files, 4-18

personalities

personality masks, 2-9

changing, 3-10

default, 9-3

phrases

creating in thesauri, 6-32

creating relationships for, 6-32

in theme indexes, 4-45, 5-6

pictorial languages

lexers for, 4-39, 5-5

token recognition for, 4-40

pipes

administration, 2-15

DDL, 2-15

increasing the size of, 11-7

query, 2-15

Text Request Queue, 2-15

PL/SQL

reserved words, 3-3, 6-17

PL/SQL packages

granting EXECUTE privileges for, 3-4

plain text

filtering, 4-24

policies

population stage

for index creation, 4-33

predefined ConText users, 2-5

predefined preferences, 5-12, 10-22, 10-33

See also preferences

preferences, 5-12

preferred terms

in synonym rings, 4-51

primary keys, 4-9, 6-27

procedures

processes

See also ConText servers

thrashing, 8-3

processing

DML requests in parallel, 4-5

HTML text through Linguistic Services, 4-24

in parallel, 7-2, 8-4

text before indexing, 4-26

proxies

gateway, 4-20, 4-21

balancing servers and users, 8-8

punctuation marks

indexing, 4-40

lexing, 5-5

qualifiers

in thesauri, 4-53

queries

in Text Request Queue, 2-15

Query

personality, 2-11, 9-3

query expansion

using fuzzy matching, 5-8

Query pipe

disabling/enabling, 3-13

increasing buffer size, 11-7

retrieving queries from, 8-8

queues

disabling/enabling, 3-13, 11-10

managing, 3-11

updating, 11-9

viewing, A-4

viewing status of, 11-4

quotation marks

in ctxload load file, 9-14

raw partitions, 7-10

for result tables, 8-7

Reader category, 5-11, 10-19

predefined preferences, 10-33

real memory, 8-3

real-time

ConText index updates in, 4-4

RECOVER procedure, 11-6

redirection

with URL data store, 4-21

reducing

REINDEX procedure, 11-50, A-6

manually reindexing documents, 4-4

using, 6-27

related terms

in thesauri, 4-54

relationships

defining in thesauri, 6-32

relevance ranking

in theme queries, 4-44

removing

errored requests from Services Queue, 3-13

pending requests from Services Queue, 3-12

REQUEST_STATUS function, 11-19

using, 3-12

requests

visible in pending table, 2-17

reserved words, 3-3, 6-17

responsibilities

DBA, 2-2

system administrator, 2-2

result tables

advantages of unique tables, 8-7

RESUME_FAILED_INDEX procedure, 11-40

using, 6-29

resuming

failed index operations, 6-29

roles. See ConText roles

rows

deleting from text columns, 4-3

deleting in CTX_INDEX_ERRORS, A-6

inserting into text columns, 4-3

multiple entries in index tables, 4-34

updating in text columns, 4-3

scanning

directories, 4-2

scope notes

in thesauri, 4-54

scores

in theme queries, 4-44

security

masking CTXSYS passwords, 3-7

separate option

for ConText servers with Loader personality, 10-20

separate option (ctxload), 9-11

sequences

for external filters, 6-15

for generating textkeys, 6-6

for stopwords, 4-41, 6-12

servers. See ConText servers

Services Queue, 2-19

enabling/disabling, 2-20, 3-13

error handling, 2-20

querying requests, 11-11

removing requests, 11-12, 11-13, 11-14

requesting status, 11-19

tables, 2-19

updating status, 11-9

viewing, 3-12

viewing status of, 3-12, 11-4

sessions

errors in ctxsrv/ctxsrvx log, 9-4

information in ctxsrv/ctxsrvx log, 9-4

SET_ATTRIBUTE procedure, 11-43

SET_QUERY_BUFFER_SIZE procedure, 11-7

setting

environment variables for ctxsrv/ctxsrvx, 9-3, 9-9

Query pipe buffer size, 11-7

setting configurations

custom, 4-43

predefined, 4-43

setting up

Linguistic Services, 1-9

text, 1-8

settings

linguistic, 4-43

SGA, 8-2

sharing

hitlist result tables, 8-7

SHUTDOWN procedure, 11-8

using, 3-10

shutting down

ConText servers, 3-10

ConText servers using ctxctl, 9-7

single-byte languages, 4-47

lexers for, 5-5

single-format columns

filtering using external filters, 4-29

SORT_AREA_SIZE initialization parameter, 8-2

SOUNDEX function

SOUNDEX predefined preference, 10-30

Soundex wordlist tables

creating, 5-20, 6-4, 11-28

source policies. See template policies

sources, 2-10, 4-13

attributes, 5-20

definition, 5-19

deleting, 11-36

preferences in, 5-20

specifying

additional parameters for Oracle indexes, 6-25

directories to scan for text loading, 10-19

fuzzy matching method, 10-17

language for stemming, 10-17

personality mask for ctxsrv/ctxsrvx, 9-3

stopwords, 10-18

STORAGE clauses for tables/indexes, 10-16

tablespaces for Oracle indexes, 10-13

translator for text loading, 10-21

SQE result tables, 4-7, C-6

reserved words, 3-3, 6-17

SQEs

storing results, 4-7

viewing, B-16

viewing results, 4-7

SQL

SQL commands

CREATE USER, 3-2

GRANT, 3-3

SQL*Loader, 4-12, 9-21

SQL*Net, 7-5

starting

ConText servers, 3-6, 3-7

ConText servers on remote machines, 9-3

ConText servers using ctxctl, 9-7

ConText servers with Loader personality, 6-5

status

monitoring ConText servers, A-2

queues, 11-4, 11-9

Services Queue, 11-19

stemming

enabling, 5-7

specifying a language for, 10-17

supported languages, 5-7

Stoplist category, 10-18

predefined preferences, 10-31

preference example, 10-18

Tiles, 5-9, 5-11

stoplists

creating, 6-12, 10-18

maximum size, 6-12

supported number of stopwords, 5-9

stopwords

in text indexes, 4-41

in text queries, 4-41

maximum number in stoplists, 5-9

specifying, 10-18

STORAGE clauses

for ConText index tables, 6-10, 10-14

for Oracle indexes, 10-14, 10-16

for wordlist tables, 10-16

stored procedures. See procedures

stored query expressions. See SQEs

storing

file names in text columns, 4-18

internal text, 4-15

tables and indexes on separate disks, 7-9

text as multiple rows, 4-17

text in operating system files, 4-16

text using MASTER DETAIL, 10-3

text using OSFILE, 10-4

text using URL, 10-4

URLs in text columns, 4-19

SUBMIT procedure

in CTX_LING package, 3-12

supplied external filters, 4-28

supported formats

for mixed-format columns, 10-38

internal filters, 4-25

viewing in Windows 32-bit viewer, 4-25

SYNC procedure, 11-52

initiating DML processing, 4-4

SYNC_QUERY function, 11-53

synonym rings

in thesauri, 4-50

preferred terms in, 4-51

synonyms

in thesauri, 4-50

System Administration tool, 1-11, 4-43

creating custom setting configurations in, 4-43

maintaining thesauri in, 4-54, 6-32

system administrator

responsibilities, 2-2

table names

tables

Text Request Queue, 2-15

tablespaces

for ConText index tables, 10-13

specifying for Oracle indexes, 10-13

temporary, 6-24, 8-2

template policies, 5-18, 10-35

See also policies

creating, 6-21, 11-30

using in policies, 5-16

viewing, B-11

TEMPLATE_AUTOB policy, 10-36

TEMPLATE_DIRECT template policy, 10-36

TEMPLATE_LONGTEXT_STOPLIST_OFF policy, 10-37

TEMPLATE_MD template policy, 10-37

TEMPLATE_MD_BIN policy, 10-37

TEMPLATE_WW6B policy, 10-37

temporary segments

for Oracle index creation, 8-2

temporary tablespaces

CTXSYS user, 6-24, 8-2

termination stage

for index creation, 4-33

text

external storage, 4-18, 10-4

external storage in operating system files, 4-16

external storage with URL pointers, 4-16

filtering, 4-23

indexing, 4-39

internal storage, 4-15, 10-3

loading, 2-10, 4-12, 9-8, 10-19, 10-21

loading using ConText servers, 4-2

preprocessing using external filters, 4-26

setting up and managing, 1-8

storing as multiple rows, 4-17

text columns

datatypes for external storage, 4-16

description, 4-9

in policies, 5-16

length limitations for composite textkeys, 4-10

LOB datatypes in, 4-9

naming limitations for composite textkeys, 4-10

storing data, 4-15

textkeys for, 4-9

updating, 4-5

text indexes

See also ConText indexes

creating, 11-23

definition, 4-39

deleting, 11-32

DML and DDL processing, 4-41

for columns with theme indexes, 4-38

stopwords in, 4-41

tables for, C-2

tokens in, 4-40

text indexing policies, 4-40

text load files. See load files

text loading categories, 5-11

text operations

Linguistic Services, 4-8

using base-letter conversion, 4-48

Text Queue. See Text Request Queue

Text Request Queue, 1-4, 2-8, 2-14

retrieving queries from, 8-8

text requests

controlling, 11-9

pending, 4-5

precedence for processing, 2-14

textkeys, 4-9, 6-27

composite, 4-10, 6-20

generating, 6-5

generating using sequences and triggers, 6-6

in ctxload load file, 6-5

in policies, 5-16

mapping to document IDs in ConText indexes, C-3

theme indexes

See also ConText indexes

and ctxsrvx, 9-2

creating, 11-23

DDL and DML processing, 4-45

deleting, 11-32

for columns with text indexes, 4-38

fragmentation in, 4-45

policies for, 4-43

tables for, C-2

theme signatures in, 4-44

tokens in, 4-45

weights in, 4-44

theme indexing policies, 4-43

Theme Lexer preferences

creating, 6-11

THEME LEXER Tile, 4-42, 5-11, 6-11, 10-9

theme queries, 4-6

and ctxsrvx, 9-2

theme weights in, 4-44

theme signatures, 4-44

theme weights

in theme indexes, 4-44

THEME_LEXER predefined preference, 10-28

themes, 2-12

document signatures, 4-44

in linguistic output, 4-8

indexing, 4-42, 5-6

thesauri, 4-49

thesaurus entries

creating, 6-32

exporting to files, 6-33

updating, 6-32

thesaurus import files. See import files

thesaurus output files

creating, 6-33

thrashing

processes, 8-3

Tiles, 5-10

assigning multiple attribute values, 6-9

attribute values, 5-11, 10-2, 10-19

attributes, 5-11, 10-2, 10-19

BASIC LEXER, 10-10

BLASTER FILTER, 10-7

CHINESE V-GRAM LEXER, 10-11

Data Store category, 5-3, 10-3

DIRECT, 10-3

DIRECTORY READER, 10-19

Engine (Text Loading) category, 10-20

Engine category, 5-7, 10-13

ENGINE NOP, 10-13

Filter category, 5-4, 10-6

FILTER NOP, 10-6

GENERIC ENGINE, 10-13

GENERIC STOP LIST, 10-18

GENERIC WORD LIST, 10-16

HTML FILTER, 10-7

JAPANESE V-GRAM LEXER, 10-11

KOREAN LEXER, 10-9

Lexer category, 5-5, 10-9

MASTER DETAIL, 10-3

NULL TRANSLATOR, 10-20

OSFILE, 10-4

Reader category, 10-19

Stoplist category, 5-9, 10-18

THEME LEXER, 10-9

Translator category, 10-20

URL, 10-4

USER FILTER, 10-8

USER TRANSLATOR, 10-21

viewing attribute values, B-10

viewing attributes, B-9

Wordlist category, 5-7, 10-16

timeouts

with URL data store, 4-21

timestamps

DML Queue, 2-17

TO_CHAR date format

specifying for ctxload, 9-11

token tables, C-2

in ConText indexes, 4-32, 4-35

tokens

in ConText indexes, C-2

in text indexes, 4-40, 5-5

in theme indexes, 4-45, 5-6

location information in text indexes, 4-41

top terms

in ctxload import file, 9-16

Translator category, 5-11, 10-20

trace files

for ctxload, 9-11

for ctxsrv/ctxsrvx, 9-4

predefined preferences, 10-34

translators

for automated text loading, 4-13

specifying for text loading, 10-21

triggers

deleting, 4-4, 11-33

for DML operations, 2-16, 4-3

for generating textkeys, 6-6

tuning

ConText indexes, 4-34

ConText indexing, 8-2

DML operations, 8-4

queries, 8-7

using raw partitions, 7-10

TWO_TASK environment variables, 9-3, 9-9

two-step queries, 4-6

result tables in, 8-7

using composite textkeys, 4-10

two-table compaction, 4-37, C-2

advantages of, 8-5

two-table deletion, 4-37, C-2

uniform resource locators. See URLs

unique keys, 4-9

UPDATE_POLICY procedure, 11-45

using, 6-22

UPDATE_QUEUE_STATUS procedure, 11-9

using, 3-13, 3-14

UPDATE_SOURCE procedure, 11-47

updating

ConText indexes, 4-4, 6-27

document references in ConText indexes, 4-35

text columns during indexing, 4-5

URLs

file accessibility for indexing, 4-20

in text columns, 4-19

using file protocol in, 4-20

using HTTP in, 4-19, 4-21

USER FILTER Tile, 5-10, 6-14, 10-8

USER TRANSLATOR Tile, 5-11, 10-21

USER_DUMP_DEST initialization parameter

for ctxload, 9-11

for ctxsrv/ctxsrvx, 9-4

user-defined translators

for automated text loading, 4-13

usernames

restrictions, 3-3

users

balancing servers with, 8-8

creating, 3-2

granting ConText roles to, 3-3

viewing policies for, B-14

viewing preferences for, B-15

using

ctxctl to manage ConText servers, 9-6

ctxload to import/export thesauri, 9-9

ctxload to load text, 9-8

ctxsrv/ctxsrvx to start ConText servers, 9-2

external filters, 4-27

index logs to resume index operations, 6-29

log files with ctxload, 9-11

log files with ctxsrv/ctxsrvx, 9-4

trace files with ConText servers, 9-4

trace files with ctxload, 9-11

utilities

ctxctl, 9-6

ctxload, 9-8

VARCHAR datatype, 4-9

variable grammar lexer. See V-Gram lexer

V-Gram lexers, 5-6

VGRAM_CHINESE predefined preference, 10-27

VGRAM_JAPANESE predefined preference, 10-28

viewing

column policies, B-12

column policies for a user, B-14

ConText server status, 3-9

DML Queue, 3-11

preference attributes defined by current user, B-15

preferences attached to policies, B-16

Services Queue, 3-12

SQEs, B-16

template policies, B-11

template policies for current user, B-17

views, A-2

CTX_ALL_DML_QUEUES, A-4

CTX_ALL_DML_SUM, A-4

CTX_ALL_QUEUE, A-5

CTX_ALL_SERVERS, A-2

CTX_ALL_THESAURI, B-18

CTX_CLASS, B-8

CTX_COLUMN_POLICIES, B-2

CTX_INDEX_ERRORS, A-6

CTX_INDEX_STATUS, A-7

CTX_INEX_LOG, B-3

CTX_LING_ERRORS, A-7

CTX_OBJECT_ATTRIBUTES, B-9

CTX_OBJECT_ATTRIBUTES_LOV, B-10

CTX_OBJECTS, B-8

CTX_PEFERENCE_ATTRIBUTES, B-6

CTX_POLICIES, B-4

CTX_PREFERENCE_USAGE, B-6

CTX_PREFERENCES, B-5

CTX_SERVERS, A-3

CTX_SQES, B-7

CTX_SYSTEM_PREFERENCE_USAGE, B-11

CTX_SYSTEM_PREFERENCES, B-10

CTX_SYSTEM_TEMPLATE_POLICIES, B-11

CTX_TEMPLATE_POLICIES, B-7

CTX_USER_COLUMN_POLICIES, B-12

CTX_USER_DML_QUEUE, A-8

CTX_USER_DML_SUM, A-8

CTX_USER_INDEX_LOG, B-13

CTX_USER_POLICIES, B-14

CTX_USER_PREFERENCE_ATTRIBUTES, B-15

CTX_USER_PREFERENCE_USAGE, B-16

CTX_USER_PREFERENCES, B-15

CTX_USER_QUEUE, A-9

CTX_USER_SQES, B-16

CTX_USER_SVCQ, A-10

CTX_USER_TEMPLATE_POLICIES, B-17

CTX_USER_THESAURI, B-18

virtual memory, 8-3

configuring, 7-2

Web files

formats supported by URL data store, 4-19

Web servers, 4-19

Windows 32-bit viewer

supported formats, 4-25

word processing formats, 4-25

Wordlist category, 10-16

predefined preferences, 10-30

preference example, 10-17

Tiles, 5-7, 5-11

wordlist tables, C-4

specifying STORAGE clauses for, 10-16

WordPerfect format

indexing using URL data store, 4-19

World Wide Web

writing

ConText server output to trace file, 9-4

WW6B predefined preference, 10-26

WYSIWYG document viewing, 4-25

Xerox XIF format