Oracle8 ConText Cartridge Application Developer's Guide
Release 2.3
A58164-01

Library
Product
Contents

Prev

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

- (hyphen) as skipjoin or printjoin, 3-47
- operator, 3-12, 3-13
! as punctuation, 3-47
! operator, 3-19, 3-20
escape character, 3-41
# as punctuation, 3-47
# operator, 3-16, 3-17
$ as punctuation, 3-47
$ operator, 3-19
% wildcard, 3-30
theme queries, 4-10
& operator, 3-7
* operator, 3-12, 3-14
, (comma)
as a numgroup character, 3-49
as accumulate operator, 3-12
as punctuation, 3-47
. (decimal point) numjoin, 3-48
. (period) as punctuation, 3-47
: operator, 3-16, 3-17
; operator, 3-12
= operator, 3-7, 3-8
> operator, 3-16
? operator, 3-19, 3-20
@ operator, 3-37
_ wildcard, 3-30
theme query, 4-10
{} escape character, 3-41
| operator, 3-7
~ operator, 3-7

Numerics

32-bit environment
viewing in, 6-10
32-bit I/O utility, 6-11

A

accumulate operator, 3-12
example, 3-12
in thesaurus queries, 3-24
stopword transformations, C-5
administration tool
linguistic settings, 7-4
algorithm for scoring, 1-8
altering precedence, 3-40
AND operator, 3-7
example, 3-7
stopword transformations, C-4
with theme queries, 4-12
API
linguistics, 7-3

B

backslash escape character, 3-41
base-letter conversion, 3-5
base-letter support
expansion operators, 3-22
thesuarus operator, 3-29
brace escape character, 3-41
brackets
altering precedence, 3-31, 3-40
grouping character, 3-31
broader term generic operator, 3-23
broader term instance operator, 3-24
broader term operator, 3-23
broader term operators
example, 3-27
broader term partitive operator, 3-24
BT operator, 3-23, 3-27
BTG operator, 3-23, 3-27
BTI operator, 3-24, 3-27
BTP operator, 3-24, 3-27

C

CANCEL procedure
CTX_LING, 10-33
CTX_SVC, 8-8, 10-53
CANCEL_ALL procedure, 10-54
CANCEL_USER procedure, 10-55
cancelling linguistic request, 8-8
case-sensitivity
stopwords, 3-4, 3-44
text queries, 1-2, 3-3
theme queries, 4-11
thesaural queries, 3-28
categories in knowledge catalog, 4-2
CLEAR_ALL_ERRORS procedure, 10-56
CLEAR_ERROR procedure, 8-8, 10-57
CLEAR_INDEX_ERRORS procedure, 10-58
CLEAR_LING_ERRORS procedure, 10-59
clearing linguistic requests with errors, 8-8
CLOSE_CON procedure, 2-15, 10-4
combined queries
first/next and max, 3-18
comma
accumulate operator, 3-12
as a numgroup, 3-49
completion processing, 8-10
composite textkey table
creating theme and Gist, 8-4
gist structure, A-7
hitlist structure, A-2
theme structure, A-6
composite textkeys
in-memory queries, 2-16
one-step queries, 2-13
two-step queries, 2-6
using FETCH_HIT, 10-14
using PKDECODE, 10-23
using PKENCODE, 10-24
composite word queries, 3-4
highlighting, 3-5
compound phrases
in synonym queries, 3-25
concepts in knowledge catalog, 4-3
CONTAINS function, 2-10, 2-11, 9-3
restrictions, 2-11
using multiple, 2-11
CONTAINS procedure, 2-3, 10-5
tables created, A-2
using SQEs, 3-34
continuation character, 3-46
querying, 3-47
control
32-bit viewer, 6-10
COUNT_HITS function, 2-18, 10-8
COUNT_LAST function, 2-18, 10-10
counting hits, 1-6, 2-18
CREATE TABLE command, 6-6
CREATE VIEW statement, 2-6
CTX_LING
CANCEL, 10-33
GET_COMPLETION_CALLBACK, 10-34
GET_ERROR_CALLBACK, 10-35
GET_FULL_THEMES, 10-36
GET_LOG_PARSE, 8-12, 10-37
GET_SETTINGS_LABEL, 10-38
package, 7-3, 10-32
REQUEST_GIST, 8-4, 10-39
REQUEST_THEMES, 8-4, 10-42
SET_COMPLETION_CALLBACK, 8-10, 10-44
SET_ERROR_CALLBACK, 8-10, 10-45
SET_FULL_THEMES, 8-5, 10-46
SET_LOG_PARSE, 8-12, 10-47
SET_SETTINGS_LABEL, 8-2, 10-48
SUBMIT, 8-4, 10-50
CTX_QUERY
CLOSE_CON, 2-15, 10-4
CONTAINS, 2-3, 3-34, 10-5
COUNT_HITS, 10-8
COUNT_LAST, 10-10
FEEDBACK, 5-2, 5-15, 10-12
FETCH_HIT, 2-15, 10-14
GETTAB, 6-6, 6-9, 10-16, A-2
HIGHLIGHT, 6-7, 10-18
OPEN_CON, 2-15, 10-21
package, 10-3
PKDECODE, 10-23
PKENCODE, 10-24
PURGE_SQE, 3-32, 10-26
REFRESH_SQE, 3-32, 3-34, 10-27
RELTAB, 6-9, 10-28
REMOVE_SQE, 3-32, 10-29
STORE_SQE, 3-32, 10-30
CTX_SQES view, 3-35
CTX_SVC
CANCEL, 8-8, 10-53
CANCEL_ALL, 10-54
CANCEL_USER, 10-55
CLEAR_ALL_ERRORS, 10-56
CLEAR_ERROR, 8-8, 10-57
CLEAR_INDEX_ERRORS, 10-58
CLEAR_LING_ERRORS, 10-59
package, 7-4, 10-52
REQUEST_STATUS, 10-60
CTX_USER_SQES view, 3-35
CTXIO32, 6-11
CTXLING sample application, B-7
CTXPLUS sample application, B-3
CTXSYS user, 7-4
CTXV32.HLP, 6-11
CTXV32.OCX, 6-10

D

database links
creating, 2-8, 2-17
in CONTAINS PL/SQL procedure, 10-5
in COUNT_HITS PL/SQL function, 10-8
in OPEN_CON PL/SQL function, 10-21
using in in-memory queries, 2-17
using in one-step queries, 2-13, 9-6
using in two-step queries, 2-8
DBMS_OUTPUT.ENABLE, 2-16
decimal point
as a numjoin, 3-48
DEFAULT thesaurus, 3-25
demo application
CTXLING, B-7
CTXPLUS, B-3
settting up, B-2
DML
affect on scoring, 1-10
document presentation, 1-12, 6-2
highlighting German composites, 3-5
in Windows, 6-10
structure of tables, A-3
document viewing, 6-2
DROP TABLE command, 6-9

E

endjoin character, 3-46
querying, 3-49
equivalence operator, 3-7, 3-8
stopword transformations, C-7
error clearing from services queue, 8-8
error processing for linguistics, 8-10
escaping special characters, 3-41
EXECUTE command, 3-37
expansion operator
fuzzy, 3-19, 3-20
penetration, 3-21
soundex, 3-19, 3-20
stem, 3-19
expansions
viewing query, 5-6
expression feedback
viewing, 5-16
extending stored query expressions, 3-34

F

feedback
query expansion, 5-6
query expression, 5-2
query optimization, 5-9
stopword rewite, 5-10
theme query normalization, 5-8
FEEDBACK procedure, 5-2, 5-15, 10-12
feedback table
creating, 5-15
understanding, 5-11
FETCH_HIT function, 2-15, 10-14
first/next operator, 3-16, 3-17
stopword transformations, C-8
with max, 3-18
formats
supported for Windows 32-bit viewing, 6-11
fuzzy expansions
viewing with expression feedback, 5-6
fuzzy operator, 3-19
example, 3-20

G

generalizing theme queries, 4-13
German composite queries, 3-4
GET_COMPLETION_CALLBACK function, 10-34
GET_ERROR_CALLBACK function, 10-35
GET_FULL_THEMES, 10-36
GET_LOG_PARSE function, 8-12, 10-37
GET_SETTINGS_LABEL function, 10-38
GETTAB procedure, 6-6, 10-16, A-2
Gist
about, 7-10
generating, 8-4, 10-39
Gist table
composite textkey, 8-4
composite textkey stucture, A-7
creating, 8-3
structure, A-7
granting execute privileges, 10-2
GROUP BY clause, 2-12
grouping characters, 3-31
with theme queries, 4-10

H

hierarchical query
query expression feedback, 5-16
hierarchies
theme, 8-5
highlight output
text and theme queries, 6-8
HIGHLIGHT procedure, 6-7, 10-18
output, 6-3
result table, A-3
using, 6-3
highlight result tables
creating, 6-6
releasing, 6-9
structure, A-3
highlighting
composite word queries, 3-5
mark-up, 6-4
text query, 6-7
theme query, 6-8
HIGHTAB table, 6-4, 6-8
structure, A-3
hitlist
result tables, 2-4
sharing, 2-5
hitlist table
composite textkey, A-2
structure, A-2
hits counting, 2-18
homographs
in broader term queries, 3-27
in narrower term queries, 3-27
HTML
embedding viewer control in, 6-10
hyphenated words
querying, 3-47

I

I/O utility, 6-11
ICF highlight output, 6-4
ICFTAB table
structure, A-4
indexing
special characters, 3-46
theme, 4-5
in-memory query, 1-5
example, 2-15, B-6
limitations, 2-17
using, 2-15
with composite textkeys, 2-16
inverse frequency scoring, 1-8
iterative queries, 3-32, 3-34

K

knowledge catalog, 4-2, 7-6
normal forms, 4-4

L

lexicon, 7-6
linguistic output, 7-8
combining with theme/text queries, 8-13
generating, 8-3, 8-13
table structure, A-6
tables, 8-3
linguistic personality, 7-4
linguistic request
about, 1-12, 7-2, 7-4
clearing, 8-8
monitoring status, 8-7
removing, 8-8
submitting, 8-5
linguistic settings
about, 7-12
specifying, 8-2
linguistics
about, 1-12, 7-2
Application Program Interface, 7-3
requirements, 7-2
list of themes, 7-8
generating, 8-4, 10-42
generating hierarchies, 8-5
hierarchies, 7-8
logging linguistic parse information, 8-12
logical operators, 3-7

M

mark-up
highlighting, 6-4
max operator, 3-16, 3-17
stopword transformations, C-7
with first/next, 3-18
MINUS operator, 3-12
example, 3-13
stopword transformations, C-5
monitoring services queue, 8-7
multiple CONTAINS, 2-11
multiple policies
with one-step queries, 2-13, 4-15
MUTAB table, 6-4, 6-8, A-3

N

narrower term generic operator, 3-23
narrower term instance operator, 3-23
narrower term operator, 3-23
narrower term operators
example, 3-26
narrower term partitive operator, 3-23
near operator, 3-12, 3-13
stopword transformations, C-7
with threshold, 3-14
nesting stored query expressions, 3-35
NOFILTAB table, 6-4
structure, A-5
normal forms in knowledge catalog, 4-4
NOT operator, 3-7
example, 3-8
stopword transformations, C-6
with theme queries, 4-13
NT operator, 3-23, 3-26
NTG operator, 3-23, 3-26
NTI operator, 3-23, 3-26
NTP operator, 3-23, 3-26
numbers
querying, 3-48
numgroup character, 3-46
querying, 3-48
numjoin character, 3-46
querying, 3-48

O

OCX
32-bit viewer, 6-10
one-step query, 1-5, 2-10
example, 2-11, B-5
multiple policies, 2-13, 4-15
processing, 2-10
SELECT statement, 9-6
theme query, 4-15
OPEN_CON function, 2-15, 10-21
OPERATION column of feedback table, 5-12
operator
accumulate, 3-12
AND, 3-7
broader term, 3-27
equivalence, 3-7, 3-8
first/next, 3-16, 3-17
fuzzy, 3-20
max, 3-16, 3-17
MINUS, 3-12, 3-13
narrower term, 3-26
near, 3-12, 3-13
NOT, 3-7, 3-8
OR, 3-7
penetration, 3-21
preferred term, 3-26
related term, 3-26
soundex, 3-20
SQE, 3-32
stem, 3-19
synonym, 3-23, 3-24, 3-25
thesaurus, 3-23
threshold, 3-16
top term, 3-28
weight, 3-12, 3-14
WITHIN, 3-10
operator precedence, 3-38
examples, 3-39
viewing with parse trees, 5-5
operators
expansion, 3-19
logical, 3-7
result-set, 3-16
score-changing, 3-12
stem, 3-19
theme query examples, 4-9
thesaurus, 3-23
operators in SQEs, 3-36
optimization of queries
expression feedback, 5-9
OPTIONS column of feedback table, 5-13
OR operator, 3-7
example, 3-7
stopword transformations, C-4
Oracle Worldwide Technical Support
how to contact, xviii
how to contact in Europe, xviii
how to contact in U.S.A., xviii
output
generating linguistic, 8-13
linguistic, 7-8

P

package
CTX_LING, 7-3, 10-32
CTX_QUERY, 10-3
CTX_SVC, 7-4, 10-52
paragraph-level Gist, 7-10
generating, 10-39
paragraph-level theme summary, 7-9
generating, 10-39
parallel processing
two-step queries, 2-9
parent themes
in list of themes, 7-8
parentheses
altering precedence, 3-31, 3-40
grouping character, 3-31
parse logging, 8-12
parse trees
query expansion, 5-6
query optimization, 5-9
stopword transformation, 5-10
theme query normalization, 5-8
understanding, 5-4
parsing engine, 7-7
PENDING requests
removing, 8-8
penetration of operators, 3-21
personality
linguistic, 7-4
PKDECODE function, 10-23
PKENCODE function, 10-24
PL/SQL
in text queries, 3-37
PL/SQL packages
granting privileges, 10-2
PLAINTAB table, 6-4
structure, A-5
pol_hint parameter in SELECT statement, 2-13, 4-15, 9-7
policies
multiple, 2-13, 4-15
precedence of operators, 3-38
altering, 3-31, 3-40
equivalence operator, 3-9
example, 3-39
preferred term operator, 3-23
example, 3-26
presentation
document, 1-12
printjoin character, 3-46
querying with, 3-47
privileges
granting, 10-2
procedures
in queries, 3-37
proximity operator, see near operator
PT operator, 3-23, 3-26
punctuation character, 3-46
querying, 3-47
PURGE_SQE procedure, 3-32, 10-26

Q

qualifiers
using in thesaural queries, 3-27
query
accumulate, 3-12
AND, 3-7
base-letter, 3-5
broader term, 3-27
combined first/next and max, 3-18
composite textkey, 2-6
counting hits, 1-6, 2-18
equivalence, 3-8
executing PL/SQL function in, 3-37
first/next, 3-17
in-memory, 1-5, 2-15
in-memory example, B-6
iterative, 3-32, 3-34
max, 3-17
MINUS, 3-13
narrower term, 3-26
NOT, 3-8
one-step, 1-5
one-step example, B-5
OR, 3-7
preferred term, 3-26
related term, 3-26
remote, 2-8, 2-13, 2-17, 9-6, 10-5, 10-8, 10-21
structured, 2-7
synonym, 3-25
theme, 1-4
threshold, 3-16
top term, 3-28
two-step, 1-5
two-step example, B-5
weight, 3-14
query expansions
viewing with expression feedback, 5-6
query expression
about, 1-7, 3-2
components, 3-3
examples, 3-5
query expression feedback
about, 5-2
obtaining, 5-15
query optimization
viewing with expression feedback, 5-9
query terms, 3-2
query_id parameter in CONTAINS, 2-5, 10-6
querying
continuation characters, 3-47
numbers, 3-48
punctuation chacracters, 3-47
theme, 4-7
querying with stopwords, 3-44
queue
services, see services queue

R

re-evaluation of SQEs, 3-33
refining theme queries, 4-12
REFRESH_SQE procedure, 3-32, 3-34, 10-27
related term operator, 3-23
example, 3-26
relevance ranking
text queries, 1-8
RELTAB procedure, 10-28
remote databases
counting query hits in, 1-6, 2-18, 10-8
in-memory queries in, 2-17, 10-21
one-step queries in, 2-13, 9-6
two-step queries in, 2-8, 10-5
remote queries
in-memory, 2-17, 10-21
one-step, 2-13, 9-6
query hits counting, 10-8
two-step, 2-8, 10-5
REMOVE_SQE procedure, 3-32, 10-29
removing pending requests, 8-8
request
clearing errors, 8-8
monitoring linguistic, 8-7
removing linguistic, 8-8
REQUEST_GIST procedure, 8-4, 10-39
REQUEST_STATUS function, 10-60
REQUEST_THEMES procedure, 8-4, 10-42
reserved words and characters, 3-41
escaping, 3-41
restricting theme query, 4-12
result table
allocating, 6-6
composite textkey, A-2
definition, 1-11
highlight, A-3
hitlist, 2-4, A-2
shared, 2-5
result-set operators, 3-16
rewrite
stopword, 3-44, C-2
RT operator, 3-23, 3-26

S

sample application
CTXLING, B-7
CTXPLUS, B-3
setting up, B-2
SCORE function, 2-10, 2-12, 9-5
score-changing operators, 3-12
scoring, 1-8
DML, 1-10
theme queries, 4-8
two-step queries, 2-4
scoring algorithm
text queries, 1-8
section searching, 3-10
SELECT statement, 2-11, 2-12, 9-6
in one-step queries, 2-11
in two-step queries, 2-3
sentence-level Gist, 7-10
sentence-level Gist and theme summary
generating, 10-39
sentence-level theme summary, 7-9
server personality, 7-4
service request
cancelling, 10-53, 10-54, 10-55
removing errors, 10-56, 10-58, 10-59
services queue
about, 7-4
monitoring, 8-7
session and system SQEs, 3-33
session configuration
setting, 8-2
SET_COMPLETION_CALLBACK procedure, 8-10, 10-44
SET_ERROR_CALLBACK procedure, 8-10, 10-45
SET_FULL_THEMES procedure, 8-5, 10-46
SET_LOG_PARSE procedure, 8-12, 10-47
SET_SETTINGS_LABEL procedure, 8-2, 10-48
settings
linguistic, 7-12, 8-2
sharelevel parameter in CONTAINS, 2-5, 10-5
sharing result table, 2-5
skipjoin character, 3-46
querying with, 3-47
soundex expansions
view with expression feedback, 5-6
soundex operator, 3-19
example, 3-20
special characters
indexing, 3-46
querying, 3-46
SQE operator, 3-32
SQE tables, 3-35
SQEs, see stored query expressions
SQL functions
CONTAINS, 9-3
SCORE, 9-5
startjoin character, 3-46
querying, 3-49
stem expansions
viewing with expression feedback, 5-6
stem operator, 3-19
stoplist, 3-2
stopword transformation, C-2
viewing with expression feedback, 5-10
stopwords, 3-2
case-sensitivity, 3-4, 3-44
querying, 3-44
STORE_SQE procedure, 3-32, 10-30
stored query expressions
behavior with FEEDBACK, 10-13
extending, 3-34
iterative queries, 3-34
nesting, 3-35
re-evaluation, 3-33
session and system, 3-33
support of operators, 3-36
using, 3-32
stripping punctuation characters, 3-47
structured query, 2-7
SUBMIT function, 8-4, 10-50
submitting linguistic requests, 8-5
supported document formats
for Windows 32-bit viewing, 6-11
SYN operator, 3-23, 3-25
synonym operator, 3-23
example, 3-25

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
result, 1-11
SQE, 3-35
SQR, 3-35, 10-27
tagged text
querying, 3-49
searching, 3-10
text query
about, 1-2
case-sensitivity, 1-2, 3-3
combining with linguistic output, 8-13
highlighting, 6-7
scoring, 1-8
selecting method, 2-2
theme hierarchy generation
setting, 10-46
theme indexing, 4-5
theme query, 1-4
about, 4-7
combining with linguistic output, 8-13
constructing, 4-9
generalizing, 4-13
highlighting, 6-8
one-step, 4-15
operators not supported, 4-10
phrasing hints, 4-10
refining, 4-12
restricting, 4-12
scoring, 1-8, 4-8
two-step, 4-15
using operators, 4-9
theme query normalization
viewing with expression feedback, 5-8
theme summaries
about, 7-9
generating, 10-39
theme table
composite textkey, 8-4, A-6
creating, 8-3
structure, A-6
theme weight, 4-6
in theme indexes, 4-6
list of themes, 7-9
themes
generating, 10-42
generating hierarchies, 8-5
generating list of, 8-4
list of, 7-8
thesaurus
calling in queries, 3-25
DEFAULT, 3-25
hierarchy levels, 3-25
thesaurus expansions
viewing with expression feedback, 5-6
thesaurus operators, 3-23
arguments, 3-24
limitations, 3-24
with theme queries, 4-9
threshold operator, 3-16
stopword transformations, C-7
with near operator, 3-14
top term operator, 3-23
example, 3-28
transformation
stopword, 3-44, 5-10, C-2
tree-structure of knowledge catalog, 4-2
TT operator, 3-23, 3-28
two-step query, 1-5, 2-3
alternative, 2-6
example, 2-3, B-5
parallel processing, 2-9
result table, 2-4
scoring, 2-4
tables used in, A-2
theme query, 4-15

V

view
using in two-step query, 2-6
viewer control (32-bit), 6-10
viewing documents, see document presentation
views
CTX_SQES, 3-35
CTX_USER_SQES, 3-35
Visual Basic
using the viewer control with, 6-10

W

weight
in list of themes, 7-9
theme, 4-6
weight operator, 3-12, 3-14
stopword transformations, C-7
wildcard characters, 3-30
with theme queries, 4-10
wildcard expansions
viewing with expression feedback, 5-6
Windows viewer control, 6-10
table used, A-4
WITHIN operator, 3-10
precedence, 3-39
stopword transformations, C-8

Prev
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents