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

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Query Concepts

Case-Sensitivity

Section Searching

Two-step Queries

One-step Queries

In-memory Queries

Counting Query Hits

Query Expressions

Stored Query Expressions

Query Expression Feedback

Scoring Algorithm for Text Queries

Document Presentation

Presenting Highlighted Documents

Presenting Linguistic Output (English Only)

2 Query Methods

Selecting a Query Method

Using Two-Step Queries

Two-Step Query Example

Hitlist Result Tables

SELECT from a Pre-defined View

Composite Textkey Queries

Structured Queries

Querying Columns in Remote Databases

Two-Step Queries in Parallel

Using One-Step Queries

One-Step Query Processing

One-Step Query Example

Multiple CONTAINS

Multiple Policies

Composite Textkey Queries

Querying Columns in Remote Databases

Using In-Memory Queries

In-Memory Query Example

In-Memory Queries and Composite Textkeys

In-Memory Query Limitations

Querying Columns in Remote Databases

Counting Query Hits

Using COUNT_HITS Before the Query

Using COUNT_LAST After the Query

3 Understanding Query Expressions

About Query Expressions

Case-Sensitive Queries

Composite Word Queries for German

Base-Letter Queries

Query Expression Examples

Logical Operators

Equivalence Operator

WITHIN Operator

Score-Changing Operators

Accumulate Operator

Weight Operator

Result-Set Operators

Threshold Operator

First/Next Operator

Combined First/Next and Max Queries

Expansion Operators

Stem Expansions

Soundex Expansions

Fuzzy Expansions

Penetration in Expansion Operators

Examining Query Expansions

Base-letter Support

Thesaurus Operators

Thesaurus Arguments

Synonym Operator

Preferred Term Operator

Related Term Operator

Narrower Term Operators

Broader Term Operators

Broader and Narrower Term Operator on Homographs

Top Term Operator

Thesaural Expansions and Case-Sensitivity

Base-letter Support for Thesaural Queries

Wildcard Characters

Grouping Characters

Stored Query Expressions

Using Stored Query Expressions

Session and System SQEs

Re-evaluation of Stored Query Expressions

Iterative Queries

Using Operators in Stored Query Expressions

PL/SQL in Query Expressions

Operator Precedence

Procedural Operators

Precedence Examples

Altering Precedence

Escaping Reserved Words and Characters

Querying Escape Characters

Querying with Stopwords

Stopwords by Themselves

Stopwords with Non-stopwords

Stopwords with Operators

Querying with Special Characters

Querying with Punctuation and Continuation Characters

Querying with Printjoins and Skipjoins

Querying with Numjoins and Numgroups

Querying with Startjoin and Endjoin Characters

4 Theme Queries

Understanding Theme Queries

The Knowledge Catalog

Constructing Theme Queries

Using Operators

Phrasing Theme Queries

Refining Theme Queries

Restricting a Query

Expanding a Query

Theme Query Examples

5 Query Expression Feedback

The Feedback Process

Understanding ConText Parse Trees

Operator Precedence

Query Expansions

Theme Query Normalization

Query Optimization

Stopword Rewrite

Understanding the Feedback Table

Table Structure

Obtaining Query Expression Feedback

Creating the Feedback Table

Executing CTX_QUERY.FEEDBACK

Retrieving Data from Feedback Table

Constructing the Parse Tree

6 Document Presentation

Overview of Document Presentation

Using CTX_QUERY.HIGHLIGHT

Creating Highlighted Text

Allocating Result Tables

Issuing a Query

Calling CTX_QUERY.HIGHLIGHT

Presenting HIGHLIGHT Output

Release Highlight Result Tables

Document Presentation in Windows

Viewing Without the ConText Viewer Control

7 Linguistic Concepts

Overview of ConText Linguistics

Application Program Interface (API)

Linguistic Personality

Creating Linguistic Output

Linguistic Core

Knowledge Catalog

Linguistic Output

Theme Summaries

Linguistic Settings

8 Using ConText Linguistics

Specifying Linguistic Settings

Generating Linguistic Output

Creating Output Tables

Generating Themes and Gists

Monitoring the Services Queue

Monitoring the Status of Requests

Removing Pending Requests

Clearing Requests with Errors

Specifying Completion and Error Procedures

Logging Parse Information

Combining Theme/Text Queries with Linguistic Output

9 SQL Functions

Query Functions

SELECT Statement

10 PL/SQL Packages

Developing with ConText PL/SQL Packages

CTX_QUERY: Query and Highlighting

REFRESH_SQE

CTX_LING:Linguistics

GET_COMPLETION_CALLBACK

GET_ERROR_CALLBACK

GET_FULL_THEMES

GET_LOG_PARSE

GET_SETTINGS_LABEL

REQUEST_GIST

REQUEST_THEMES

SET_COMPLETION_CALLBACK

SET_ERROR_CALLBACK

SET_FULL_THEMES

SET_LOG_PARSE

SET_SETTINGS_LABEL

CTX_SVC: Services Queue Administration

CANCEL_USER

CLEAR_ALL_ERRORS

CLEAR_ERROR

CLEAR_INDEX_ERRORS

CLEAR_LING_ERRORS

REQUEST_STATUS

A Result Tables

Hitlist Table Structure

Composite Textkey Hitlist Tables

Highlight Table Structures

HIGHTAB Highlight Table

MUTAB Highlight Table

ICFTAB Highlight Table

Display Table Structures

NOFILTAB Display Table

PLAINTAB Display Table

Linguistic Output Table Structures

B SQL*Plus Sample Code

Setting Up the ConText Sample Applications

Overview of CTXPLUS

CTXPLUS Examples

Overview of CTXLING

CTXLING Examples

C Stopword Transformations

Understanding Stopword Transformations

Word Transformations

AND Transformations

OR Transformations

Accumulate Transformations

MINUS Transformations

NOT Transformations

Equivalence Transformations

NEAR Transformations

Weight Transformations

Threshold Transformations

Max Transformations

First/Next Transformations

WITHIN Transformations

Copyright © 1997 Oracle Corporation.
All Rights Reserved.