Oracle8 ConText Cartridge Application Developer's Guide
Release 2.4
A63821-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Symbols
! as punctuation, 3-52
! operator, 3-24,
3-25
escape character, 3-46
# as punctuation, 3-52
# operator, 3-21,
3-22
$ as punctuation, 3-52
$ operator, 3-24
% wildcard, 3-35
theme queries, 4-7
& operator, 3-8
* operator, 3-14,
3-15
- (hyphen) as skipjoin or printjoin, 3-52
- operator, 3-14,
3-15
, (comma)
as a numgroup character, 3-54
as accumulate operator, 3-14
as punctuation, 3-52
. (decimal point) numjoin, 3-53
. (period) as punctuation, 3-52
: operator, 3-21,
3-22
= operator, 3-8,
3-9
> operator, 3-21
? operator, 3-24,
3-25
@ operator, 3-42
_ wildcard, 3-35
{} escape character, 3-46
| operator, 3-8
~ operator, 3-8
A
accumulate operator, 3-14
example, 3-14
in thesaurus queries, 3-29
stopword transformations, D-14
accumulation of themes, 7-12
algorithm for scoring, B-2
altering precedence, 3-45
ambiguous concept in knowledge catalog, 7-10
ambiguous themes, 4-3
AND operator, 3-8
example, 3-8
stopword transformations, D-13
theme queries, 4-9
application
building, 1-2
B
backslash escape character, 3-46
backward compatibility
near operator syntax, 3-19
base-letter conversion, 3-6
base-letter query
thesuarus operator, 3-6
base-letter support
expansion operators, 3-27
thesuarus operator, 3-34
brace escape character, 3-46
brackets
altering precedence, 3-36,
3-45
grouping character, 3-36
broader term generic operator, 3-28
broader term instance operator, 3-29
broader term operator, 3-28
broader term operators
example, 3-32
broader term partitive operator, 3-29
BT operator, 3-28,
3-32
BTG operator, 3-28,
3-32
BTI operator, 3-29,
3-32
BTP operator, 3-29,
3-32
C
CANCEL procedure
CTX_LING, 10-33
CTX_SVC, 10-53
CANCEL_ALL procedure, 10-54
CANCEL_USER procedure, 10-55
case-conversion linguistic settings, 7-13
case-sensitivity
stopwords, 3-4,
3-49
text queries, 1-7,
3-3
theme query, 1-8,
4-5
thesaural queries, 3-33
categories in knowledge catalog, E-1
definition, 7-8
CLEAR_ALL_ERRORS procedure, 10-56
CLEAR_ERROR procedure, 8-19,
10-57
CLEAR_INDEX_ERRORS procedure, 10-58
CLEAR_LING_ERRORS procedure, 10-59
clearing linguistic requests with errors, 8-19
CLOSE_CON procedure, 2-16,
10-4
clump size in near operator, 3-17
combined queries
first/next and max, 3-23
comma
accumulate operator, 3-14
as a numgroup, 3-54
composite textkey table
creating theme and Gist, 8-9
gist structure, A-7
hitlist structure, A-2
theme structure, A-6
composite textkeys
in-memory queries, 2-18
one-step queries, 2-14
two-step queries, 2-7
using FETCH_HIT, 10-14
using PKDECODE, 10-24
using PKENCODE, 10-25
composite word queries, 3-5
highlighting, 3-5
compound phrases
in synonym queries, 3-30
concept
ambiguous, 7-10
unknown, 7-10
concepts in knowledge catalog
definition, 7-9
CONTAINS function, 2-11,
2-12,
9-3
restrictions, 2-12
using multiple, 2-12
CONTAINS procedure, 2-3,
10-5
tables created, A-2
using SQEs, 3-39
ConText linguistics
about, 7-2
continuation character, 3-51
querying, 3-52
count
presenting, 1-15
COUNT_HITS function, 2-19,
10-8
COUNT_LAST function, 2-19,
10-10
counting hits, 1-13,
2-19
CREATE TABLE command, 6-6
CREATE VIEW statement, 2-7
CTX_LING
CANCEL, 10-33
GET_COMPLETION_CALLBACK, 10-34
GET_ERROR_CALLBACK, 10-35
GET_FULL_THEMES, 10-36
GET_LOG_PARSE, 8-22,
10-37
GET_SETTINGS_LABEL, 10-38
package, 10-32
REQUEST_GIST, 8-10,
10-39
REQUEST_THEMES, 8-10,
10-42
SET_COMPLETION_CALLBACK, 8-20,
10-44
SET_ERROR_CALLBACK, 8-20,
10-45
SET_FULL_THEMES, 8-11,
10-46
SET_LOG_PARSE, 8-22,
10-47
SET_SETTINGS_LABEL, 8-16,
10-48
SUBMIT, 8-10,
10-50
CTX_LING output
about, 8-2
combining with queries, 8-14
generating, 8-8,
8-14
presenting, 1-18
CTX_LING output tables
creating, 8-8
CTX_QUERY
CLOSE_CON, 2-16,
10-4
CONTAINS, 2-3,
3-39,
10-5
COUNT_HITS, 10-8
COUNT_LAST, 10-10
FEEDBACK, 5-2,
5-13,
10-12
FETCH_HIT, 2-16,
10-14
GETTAB, 6-6,
6-10,
10-16,
A-2
HIGHLIGHT, 6-7,
10-18
OPEN_CON, 2-16,
10-22
package, 10-3
PKDECODE, 10-24
PKENCODE, 10-25
PURGE_SQE, 3-37,
10-26
REFRESH_SQE, 3-37,
3-39,
10-27
RELTAB, 6-10,
10-28
REMOVE_SQE, 3-37,
10-29
STORE_SQE, 3-37,
10-30
CTX_SQES view, 3-40
CTX_SVC
CANCEL, 10-53
CANCEL_ALL, 10-54
CANCEL_USER, 10-55
CLEAR_ALL_ERRORS, 10-56
CLEAR_ERROR, 8-19,
10-57
CLEAR_INDEX_ERRORS, 10-58
CLEAR_LING_ERRORS, 10-59
package, 10-52
REQUEST_STATUS, 10-60
CTX_USER_SQES view, 3-40
CTXLING sample application, C-7
CTXPLUS sample application, C-3
CTXSYS user, 8-4
D
database links
creating, 2-9,
2-18
in CONTAINS PL/SQL procedure, 10-5
in COUNT_HITS PL/SQL function, 10-8
in OPEN_CON PL/SQL function, 10-22
using in in-memory queries, 2-18
using in one-step queries, 2-14,
9-6
using in two-step queries, 2-9
DBMS_OUTPUT.ENABLE, 2-17
decimal point
as a numjoin, 3-53
DEFAULT thesaurus, 3-30
demo application
CTXLING, C-7
CTXPLUS, C-3
settting up, C-2
DML
affect on scoring, B-3
document hit count
presenting, 1-15
document presentation, 6-2
highlighting composites, 3-5
structure of tables, A-3
using CTX_LING output, 8-14
document viewing, 6-2
DROP TABLE command, 6-10
Dutch composite queries, 3-5
E
endjoin character, 3-51
querying, 3-55
equivalence operator, 3-8,
3-9
stopword transformations, D-16
with near, 3-18
error clearing from services queue, 8-19
error processing for linguistics, 8-20
escaping special characters, 3-46
EXECUTE command, 3-42
expansion operator
fuzzy, 3-24,
3-25
penetration, 3-26
soundex, 3-24,
3-25
stem, 3-24
expansions
viewing query, 5-5
expression feedback
presenting, 1-15
viewing, 5-14
extending stored query expressions, 3-39
F
feedback
query expansion, 5-5
query expression, 5-2
query optimization, 5-7
stopword rewite, 5-7
theme query normalization, 5-6
FEEDBACK procedure, 5-2,
5-13,
10-12
feedback table
creating, 5-13
understanding, 5-9
FETCH_HIT function, 2-16,
10-14
first/next operator, 3-21,
3-22
stopword transformations, D-17
with max, 3-23
formats
supported for Windows 32-bit viewing, 1-17
fuzzy expansions
viewing with expression feedback, 5-5
fuzzy operator, 3-24
example, 3-25
G
generalizing theme queries, 4-10
German composite queries, 3-5
GET_COMPLETION_CALLBACK function, 10-34
GET_ERROR_CALLBACK function, 10-35
GET_FULL_THEMES, 10-36
GET_LOG_PARSE function, 8-22,
10-37
GET_SETTINGS_LABEL function, 10-38
GETTAB procedure, 6-6,
10-16,
A-2
Gist, 8-2,
8-7
generating, 8-10,
10-39
presenting, 1-18
Gist table
composite textkey, 8-9
composite textkey stucture, A-7
creating, 8-8
structure, A-7
granting execute privileges, 10-2
grouping characters, 3-36
theme queries, 4-7
H
hierarchical list of themes, 8-5
generating, 8-11
hierarchical query
query expression feedback, 5-14
highlight output
text and theme queries, 6-8
HIGHLIGHT procedure, 6-7,
10-18
output, 6-4
result table, A-3
using, 6-3
highlight result tables
creating, 6-6
releasing, 6-10
structure, A-3
highlighted documents
presenting, 1-16
highlighting
composite word queries, 3-5
mark-up, 6-5
near operator, 3-19
text and theme, 6-2
text query, 6-7
theme query, 6-8
viewers, 1-17
HIGHTAB table, 6-3,
6-8
structure, A-3
hints
theme queries, 4-8
hitlist
result tables, 2-4
sharing, 2-5
hitlist table
composite textkey, A-2
structure, A-2
hits counting, 2-19
homographs
in broader term queries, 3-32
in narrower term queries, 3-32
hyphenated words
querying, 3-52
I
ICF highlight output, 6-3
ICFTAB table
structure, A-4
index
creating, 1-4
options for text index, 1-4
indexing
special characters, 3-51
theme, 4-2
in-memory query, 1-12
example, 2-17,
C-6
limitations, 2-18
using, 2-16
with composite textkeys, 2-18
input to theme extraction system, 7-5
inverse frequency scoring, B-2
iterative queries, 3-37,
3-39
K
knowledge catalog
about, 7-8
category hiearchy, E-1
normal forms, 7-10
structure, 7-8
knowlege base
about, 7-6
known themes, 4-3
known tokens, 7-11
L
lexicon, 7-6
linguistic completion processing, 8-20
linguistic output, 8-3
table structure, A-6
linguistic personality, 8-4
linguistic request
about, 1-18,
8-4
clearing, 8-19
monitoring status, 8-17
removing, 8-18
submitting, 8-11
linguistic settings
about, 7-13
enabling, 7-14,
8-16
linguistics
about, 1-18,
7-2
list of themes, 8-2,
8-5
generating, 8-10,
10-42
generating parent themes, 8-11
hierarchies, 8-5
presenting, 1-18
single themes, 8-5
loading text, 1-4
logging linguistic parse information, 8-22
logical operators, 3-8
with near, 3-18
M
mark-up
highlighting, 6-5
max operator, 3-21,
3-22
stopword transformations, D-17
with first/next, 3-23
max_span parameter in near operator, 3-17
MINUS operator, 3-14
example, 3-15
stopword transformations, D-15
monitoring services queue, 8-17
multiple CONTAINS, 2-12
multiple policies
one-step queries, 4-13
with one-step queries, 2-14
MUTAB table, 6-3,
6-8,
A-3
N
narrower term generic operator, 3-28
narrower term instance operator, 3-28
narrower term operator, 3-28
narrower term operators
example, 3-31
narrower term partitive operator, 3-28
near operator, 3-17
backward compatibility, 3-19
highlighting, 3-19
scoring, 3-18
section searching, 3-20
stopword transformations, D-16
with other operators, 3-18
nesting stored query expressions, 3-40
NOFILTAB table, 6-3
structure, A-5
normal forms in knowledge catalog, 7-10
normalization of tokens, 7-11
NOT operator, 3-8
example, 3-9
stopword transformations, D-15
theme queries, 4-10
NT operator, 3-28,
3-31
NTG operator, 3-28,
3-31
NTI operator, 3-28,
3-31
NTP operator, 3-28,
3-31
numbers
querying, 3-53
numgroup character, 3-51
querying, 3-53
numjoin character, 3-51
querying, 3-53
O
one-step query, 1-13,
2-11
example, 2-12,
C-5
multiple policies, 2-14,
4-13
processing, 2-11
SELECT statement, 9-6
theme query, 4-12
OPEN_CON function, 2-16,
10-22
OPERATION column of feedback table, 5-10
operator
accumulate, 3-14
AND, 3-8
broader term, 3-32
equivalence, 3-8,
3-9
first/next, 3-21,
3-22
fuzzy, 3-25
max, 3-21,
3-22
MINUS, 3-14,
3-15
narrower term, 3-31
NOT, 3-8,
3-9
OR, 3-8
penetration, 3-26
preferred term, 3-31
related term, 3-31
soundex, 3-25
SQE, 3-37
stem, 3-24
synonym, 3-28,
3-29,
3-30
thesaurus, 3-28
threshold, 3-21
top term, 3-33
weight, 3-14,
3-15
WITHIN, 3-12
operator precedence, 3-43
examples, 3-44
viewing with parse trees, 5-4
operators
expansion, 3-24
logical, 3-8
result-set, 3-21
score-changing, 3-14
stem, 3-24
theme query examples, 4-6
thesaurus, 3-28
using, 1-7
with theme queries, 4-6
operators in SQEs, 3-41
optimization of queries
expression feedback, 5-7
OPTIONS column of feedback table, 5-11
OR operator, 3-8
example, 3-9
stopword transformations, D-14
Oracle Worldwide Technical Support
how to contact, xix
how to contact in Europe, xix
how to contact in U.S.A., xix
order parameter in near operator, 3-17
output
linguistic, 8-3
P
package
CTX_LING, 10-32
CTX_QUERY, 10-3
CTX_SVC, 10-52
PARAGRAPH keyword, 3-11
paragraph-level Gist, 8-7
generating, 10-39
paragraph-level theme summary, 8-6
generating, 10-39
parallel processing
two-step queries, 2-9
parent themes
generating, 8-11
in list of themes, 8-5
parentheses
altering precedence, 3-36,
3-45
grouping character, 3-36
parse logging, 8-22
parse trees
query expansion, 5-5
query optimization, 5-7
stopword transformation, 5-7
theme query normalization, 5-6
understanding, 5-4
parsing engine, 7-11
PENDING requests
removing, 8-18
penetration of operators, 3-26
personality
linguistic, 8-4
PKDECODE function, 10-24
PKENCODE function, 10-25
PLAINTAB table, 6-3
structure, A-5
PL/SQL
in text queries, 3-42
PL/SQL packages
granting privileges, 10-2
pol_hint parameter in SELECT statement, 2-14,
4-13,
9-7
policies
multiple, 2-14,
4-13
precedence of operators, 3-43
altering, 3-36,
3-45
equivalence operator, 3-10
example, 3-44
preferred term operator, 3-28
example, 3-31
presenting document
about, 1-16
printjoin character, 3-51
querying with, 3-52
privileges
granting, 10-2
procedures
in queries, 3-42
proving themes, 7-12
proximity operator, see near operator
PT operator, 3-28,
3-31
punctuation character, 3-51
querying, 3-52
PURGE_SQE procedure, 3-37,
10-26
Q
qualifiers
using in thesaural queries, 3-33
queries
combining with CTX_LING output, 8-14
query
accumulate, 3-14
AND, 3-8
base-letter, 3-6
broader term, 3-32
combined first/next and max, 3-23
composite textkey, 2-7
counting hits, 1-13,
2-19
equivalence, 3-9
executing PL/SQL function in, 3-42
first/next, 3-22
in-memory, 1-12,
2-16
in-memory example, C-6
iterative, 3-37,
3-39
max, 3-22
MINUS, 3-15
narrower term, 3-31
NOT, 3-9
one-step, 1-13
one-step example, C-5
OR, 3-9
preferred term, 3-31
related term, 3-31
remote, 2-9,
2-14,
2-18,
9-6,
10-5,
10-8,
10-22
structured, 2-8
synonym, 3-30
theme, 1-6
threshold, 3-21
top term, 3-33
two-step example, C-5
weight, 3-15
query expansions
viewing with expression feedback, 5-5
query expression
about, 3-2
components, 3-3
examples, 3-6
query expression feedback
about, 5-2
obtaining, 5-13
query optimization
viewing with expression feedback, 5-7
query terms, 3-2
query_id parameter in CONTAINS, 2-5,
10-6
querying
continuation characters, 3-52
numbers, 3-53
punctuation chacracters, 3-52
theme, 4-4
querying with stopwords, 3-49
queue
services, see services queue
R
re-evaluation of SQEs, 3-38
refining theme queries, 4-9
REFRESH_SQE procedure, 3-37,
3-39,
10-27
related term operator, 3-28
example, 3-31
relevance ranking
text queries, B-2
RELTAB procedure, 10-28
remote databases
counting query hits in, 10-8
in-memory queries in, 2-18,
10-22
one-step queries in, 2-14,
9-6
two-step queries in, 2-9,
10-5
remote queries
in-memory, 2-18,
10-22
one-step, 2-14,
9-6
query hits counting, 10-8
two-step, 2-9,
10-5
REMOVE_SQE procedure, 3-37,
10-29
request
clearing errors, 8-19
monitoring linguistic, 8-17
removing linguistic, 8-18
REQUEST_GIST procedure, 8-10,
10-39
REQUEST_STATUS function, 10-60
REQUEST_THEMES procedure, 8-10,
10-42
reserved words and characters, 3-46
escaping, 3-46
restricting theme query, 4-9
result table
allocating, 6-6
composite textkey, A-2
highlight, A-3
hitlist, 2-4,
A-2
shared, 2-5
result-set operators, 3-21
rewrite
stopword, 3-50,
D-12
RT operator, 3-28,
3-31
S
sample application
CTXLING, C-7
CTXPLUS, C-3
setting up, C-2
score
presenting, 1-14
SCORE function, 2-11,
2-13,
9-5
score-changing operators, 3-14
scoring
DML, B-3
theme queries, 4-5
two-step queries, 2-4
scoring algorithm
text queries, B-2
scoring for near operator, 3-18
section searching, 3-12
about, 1-8
with NEAR operator, 3-20
SELECT statement, 2-12,
2-13,
9-6
in one-step queries, 2-12
in two-step queries, 2-3
SENTENCE keyword, 3-11
sentence-level Gist, 8-7
sentence-level Gist and theme summary
generating, 10-39
sentence-level theme summary, 8-6
server personality, 8-4
service request
cancelling, 10-53,
10-54,
10-55
removing errors, 10-56,
10-58,
10-59
services queue
about, 8-4
monitoring, 8-17
session and system SQEs, 3-38
session configuration
setting, 8-16
SET_COMPLETION_CALLBACK procedure, 8-20,
10-44
SET_ERROR_CALLBACK procedure, 8-20,
10-45
SET_FULL_THEMES procedure, 8-11,
10-46
SET_LOG_PARSE procedure, 8-22,
10-47
SET_SETTINGS_LABEL procedure, 8-16,
10-48
settings
linguistic, 7-13,
8-16
sharelevel parameter in CONTAINS, 2-5,
10-5
sharing result table, 2-5
single themes
in list of themes, 8-5
skipjoin character, 3-51
querying with, 3-52
soundex expansions
view with expression feedback, 5-5
soundex operator, 3-24
example, 3-25
special characters
indexing, 3-51
querying, 3-51
SQE operator, 3-37
SQE tables, 3-40
SQL functions
CONTAINS, 9-3
SCORE, 9-5
startjoin character, 3-51
querying, 3-55
stem expansions
viewing with expression feedback, 5-5
stem operator, 3-24
stoplist, 3-2
stopword transformation, D-12
viewing with expression feedback, 5-7
stopwords, 3-2
case-sensitivity, 3-4,
3-49
querying, 3-49
STORE_SQE procedure, 3-37,
10-30
stored query expressions
behavior with FEEDBACK, 10-13
extending, 3-39
iterative queries, 3-39
nesting, 3-40
re-evaluation, 3-38
session and system, 3-38
support of operators, 3-41
using, 3-37
stripping punctuation characters, 3-52
structured field searching
about, 1-9
structured query, 2-8
SUBMIT function, 8-10,
10-50
submitting linguistic requests, 8-11
supported document formats
for Windows 32-bit viewing, 1-17
SYN operator, 3-28,
3-30
synonym operator, 3-28
example, 3-30
T
table structure
Gist, A-7
HIGHLIGHT, A-3
hitlist, A-2
ICFTAB, A-4
MUTAB, A-3
NOFILTAB, A-5
PLAINTAB, A-5
theme, A-6
tables
CTX_LING output, 8-8
SQE, 3-40
SQR, 3-41,
10-27
tagged text
querying, 3-55
searching, 3-12
text highlighting, 6-2
text index
options, 1-4
text loading, 1-4
text query
about, 1-6
case-sensitivity, 1-7,
3-3
highlighting, 6-7
selecting method, 2-2
theme accumulation
in theme extraction process, 7-12
theme extraction
about, 7-2
text input, 7-5
theme hierarchy generation
setting, 10-46
theme highlighting, 6-2
theme indexing, 4-2
theme proving
in theme extraction process, 7-12
theme query
about, 1-6,
4-4
case-sensitivity, 1-8,
4-5
constructing, 4-6
generalizing, 4-10
highlighting, 6-8
one-step, 4-12
operators not supported, 4-7
phrasing hints, 4-8
refining, 4-9
restricting, 4-9
scoring, 4-5
two-step, 4-12
using operators, 4-6
theme query normalization
viewing with expression feedback, 5-6
theme ranking
in theme extraction process
ranking of themes, 7-12
theme summaries, 8-2,
8-6
generating, 8-10,
10-39
presenting, 1-18
theme table
composite textkey, 8-9,
A-6
creating, 8-8
structure, A-6
theme weight, 7-4
in theme indexes, 4-4
list of themes, 8-5
themes
about, 7-4
ambiguous, 4-3
generating, 10-42
generating parent themes, 8-11
known, 4-3
list of, 8-5
unknown, 4-3
thesaural query
base-letter, 3-6
thesaurus
calling in queries, 3-30
DEFAULT, 3-30
hierarchy levels, 3-30
thesaurus expansions
viewing with expression feedback, 5-5
thesaurus operators, 3-28
arguments, 3-29
limitations, 3-29
theme queries, 4-7
threshold operator, 3-21
stopword transformations, D-17
token normalization, 7-11
tokens, 7-11
top term operator, 3-28
example, 3-33
transformation
stopword, 3-50,
5-7,
D-12
tree-structure of knowledge catalog, 7-8
TT operator, 3-28,
3-33
two-step query, 2-3
alternative, 2-6
example, 2-3,
C-5
parallel processing, 2-9
result table, 2-4
scoring, 2-4
tables used in, A-2
theme query, 4-12
U
unknown concept in knowledge catalog, 7-10
unknown themes, 4-3
unknown tokens, 7-11
V
view
using in two-step query, 2-6
viewers
about, 1-17
viewing documents, see document presentation
views
CTX_SQES, 3-40
CTX_USER_SQES, 3-40
W
weight
in list of themes, 8-5
theme, 4-4,
7-4
weight operator, 3-14,
3-15
stopword transformations, D-17
wildcard characters, 3-35
theme queries, 4-7
wildcard expansions
viewing with expression feedback, 5-5
Windows viewer control
table used, A-4
WITHIN operator, 3-11,
3-12
limitations, 3-13
precedence, 3-44
stopword transformations, D-17
with near, 3-20
Prev
Copyright © 1998 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents