Oracle ConText Option Application Developer's Guide, Rel. 2.3 Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Index
Index


Preface

1 Query Concepts

Text Queries
Section Searching
Theme Queries
Query Methods
Two-step Queries
One-step Queries
In-memory Queries
Counting Query Hits
Query Expressions
Stored Query Expressions
Query Expression Feedback
Scoring
Score Range
Scoring Algorithm for Text Queries
Result Tables
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
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
Multiple CONTAINS
Scoring
Restrictions
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
Query Terms
Base-Letter Queries
Query Expression Examples
Logical Operators
AND Operator
OR Operator
NOT Operator
Equivalence Operator
WITHIN Operator
Score-Changing Operators
Accumulate Operator
MINUS Operator
Near Operator
Weight Operator
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
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
Group 1
Group 2
Procedural Operators
Precedence Examples
Altering Precedence
Escaping Reserved Words and Characters
Example
Reserved Words
Querying Escape Characters
Querying with Stopwords
Stopwords by Themselves
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
Theme Indexing
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

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
Example
Obtaining Query Expression Feedback
Creating the Feedback Table
Executing CTX_QUERY.FEEDBACK
Retrieving Data from Feedback Table
Constructing the Parse Tree

6 Viewing Highlighted Text

Overview of Viewing
CTX_QUERY.HIGHLIGHT Procedure
Highlighting Mark-up
Using CTX_QUERY.HIGHLIGHT
Allocate Result Tables
Issue Query
Call CTX_QUERY.HIGHLIGHT
Display HIGHLIGHT Output
Release Result Tables
CTX_QUERY.HIGHLIGHT Sample
Code Sample
Example
Viewing in Windows
Viewing Without the OCX

7 Linguistic Concepts

Overview of ConText Linguistics
Requirements
Linguistic Personality
Services Queue
Creating Linguistic Output
Application Program Interface (API)
CTX_LING Package
CTX_SVC Package
Linguistic Core
Lexicon
Knowledge Catalog
Parsing Engine
Text Input Requirements
Punctuation
Paragraph Separation
Document Size
Writing Styles
Case-sensitivity
Linguistic Output
Theme Indexes
List of Themes
Theme Summaries
Gists
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
Implementation

9 SQL Functions

Query Functions
CONTAINS
SCORE
SELECT Statement

10 PL/SQL Packages

Developing with ConText PL/SQL Packages
CTX_QUERY: Query and Highlighting
CLOSE_CON
CONTAINS
COUNT_HITS
COUNT_LAST
FEEDBACK
FETCH_HIT
GETTAB
HIGHLIGHT
OPEN_CON
PKDECODE
PKENCODE
PURGE_SQE
REFRESH_SQE
RELTAB
REMOVE_SQE
STORE_SQE
CTX_LING:Linguistics
CANCEL
GET_COMPLETION_CALLBACK
GET_ERROR_CALLBACK
GET_LOG_PARSE
GET_SETTINGS_LABEL
REQUEST_GIST
REQUEST_THEMES
SET_COMPLETION_CALLBACK
SET_ERROR_CALLBACK
SET_LOG_PARSE
SET_SETTINGS_LABEL
SUBMIT
CTX_SVC: Services Queue Administration
CANCEL
CANCEL_ALL
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
Theme Table
Gist Table

B SQL*Plus Sample Code

Setting Up the ConText Sample Applications
Overview of CTXPLUS
Concepts
Using CTXPLUS
CTXPLUS Examples
Overview of CTXLING
Concepts
Using 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

Index


Oracle Corporation
Copyright © 1997 Oracle Corporation
500 Oracle Parkway, Redwood City, CA 94065


Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Index
Index