Oracle8 ConText Cartridge

Overview

Prerequisites

Loading Text

Creating an Index

Entering the Query

Text Queries

Theme Queries

Using Operators

Case-Sensitive Searching

Document Section Searching

Structured Field Searching

Rewriting the Query Expression

Presenting Expression Feedback

Executing the Query

Presenting the Hitlist

Presenting Structured Fields

Presenting Score

Presenting Document Hit Count

Presenting Expression Feedback in Hitlist

Presenting Gists (English only)

Presenting the Document

Presenting Highlighted Documents

Presenting CTX_LING Output (English Only)

Selecting a Query Method

Using Two-Step Queries

Two-Step Query Example

Scoring

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

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

About Query Expressions

Query Terms

Case-Sensitive Queries

Composite Word Queries (German and Dutch only)

Base-Letter Queries

Query Expression Examples

Logical Operators

WITHIN Operator

Querying Within Sentence or Paragraphs

Querying Within User-defined Sections

Limitations

Score-Changing Operators

NEAR Operator

Near with Other Operators

Backward Compatibility Near Syntax

Highlighting with the Near Operator

Section Searching and Near

Result-Set Operators

Threshold Operator

Max 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

SQE Tables

Using Operators in Stored Query Expressions

PL/SQL in Query Expressions

Example

Operator Precedence

Escaping Reserved Words and Characters

Example

Reserved Words

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

Understanding Theme Queries

Theme Indexing Concepts

Theme Querying

Constructing Theme Queries

Using Operators

Phrasing Theme Queries

Refining Theme Queries

Restricting a Query

Expanding a Query

Theme Query Examples

Two-Step Query

One-Step Query

The Feedback Process

Understanding ConText Parse Trees

Operator Precedence

Query Expansions

Theme Query Normalization

Query Optimization

Stopword Rewrite

Decompounding of Composite Word Tokens

Understanding the Feedback Table

Table Structure

Example

Obtaining Query Expression Feedback

Creating the Feedback Table

Executing CTX_QUERY.FEEDBACK

Retrieving Data from Feedback Table

Constructing the Parse Tree

Overview of Document Presentation

Using CTX_QUERY.HIGHLIGHT

Output

Highlighting Mark-up

Creating Highlighted Text

Allocating Result Tables

Issuing a Query

Calling CTX_QUERY.HIGHLIGHT

Presenting HIGHLIGHT Output

Release Highlight Result Tables

Overview of ConText Linguistics

What is a Theme?

Theme Weight

Text Input

Theme Extraction System

Knowledge Base

Parsing Engine

Linguistic Settings

Case-Conversion Settings

Gist and Theme Summary Settings

Enabling Linguistic Settings

Overview

Linguistic Personality

Services Queue

List of Themes

Single Themes

Theme Hierarchies

Theme Summaries

Gists

Generating CTX_LING Output

Creating Output Tables

Generating Lists of Themes, Theme Summaries, and Gists

Combining Queries with CTX_LING Output

Implementation

Enabling Linguistic Settings

Monitoring the Services Queue

Monitoring the Status of Requests

Removing Pending Requests

Clearing Requests with Errors

Specifying Completion and Error Procedures

Logging Parse Information

Query Functions

Developing with ConText PL/SQL Packages

CTX_QUERY: Query and Highlighting

CTX_LING: Linguistics

CANCEL

GET_COMPLETION_CALLBACK

SET_COMPLETION_CALLBACK

CTX_SVC: Services Queue Administration

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

CTX_LING Output Table Structures

Theme Table

Gist Table

Scoring Algorithm for Text Queries

Example

DML and Scoring

Setting Up the ConText Sample Applications

Overview of CTXPLUS

Concepts

Using CTXPLUS

CTXPLUS Examples

Overview of CTXLING

Concepts

Using CTXLING

CTXLING Examples

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

Branch 1: science and technology

Branch 2: business and economics

Branch 3: government and military

Branch 4: social environment

Branch 5: geography

Branch 6: abstract ideas and concepts

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Building a Query Application

2 Query Methods

3 Understanding Query Expressions

4 Theme Queries

5 Query Expression Feedback

6 Document Presentation: Highlighting

7 ConText Linguistics

8 Using CTX_LING

9 SQL Functions

10 PL/SQL Packages

A Result Tables

B Scoring Algorithm

C SQL*Plus Sample Code

D Stopword Transformations

E Knowledge Catalog - Category Hierarchy

Index