Oracle8(TM) ConText(R) Cartridge Application Developer's Guide
Release 2.0
A54630-01

Library
Product
Index

Next

Contents

Title and Copyright Information

Preface

1 Introduction

The ConText Cartridge Solution
Advantages of Oracle ConText
Powerful Text Handling Capabilities
Extensible Framework for Languages and Formats
Database-quality Architecture for Managing Text
Standards-based Development Environment
Text and Linguistic Features
Linguistic Analysis
Theme Queries
Theme Viewing
Roles
End User
Application Developer
Database Administrator
ConText Administrator
Creating the Text Processing Environment

2 Text Concepts and Definitions

Documents
Text Storage
Internal Storage
External Storage
Text Retrieval
Search Options
Text Queries
Theme Queries
Query Methods
Two-step Queries
One-step Queries
In-memory Queries
Counting Query Hits
Query Expressions
Stored Query Expressions
Hitlists
Scoring
Result Tables

3 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

4 Understanding Query Expressions

About Query Expressions
Query Terms
Base-Letter Queries
Query Expression Examples
Logical Operators
AND Operator
OR Operator
NOT Operator
Equivalence Operator
Scoring for Logical Operators
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
Broader Term Operator
Narrower Term Operator
Broader and Narrower Term Operator on Homographs
Top Term Operator
Base-letter Support for Thesaural Queries
Operator Precedence
Precedence Examples
Altering Precedence
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
Escaping Reserved Words and Characters
Example
Querying the Literal Escape Character
Querying with Special Characters
Querying with Punctuation and Continuation Characters
Querying with Printjoins and Skipjoins
Querying with Numjoins and Numgroups

5 Theme Queries

Creating a Theme Index
Document Signatures
Using Theme Queries
Two-Step Query
One-step Query
Case-sensitivity
Ambiguous Queries
Using Operators with Theme Queries

6 Viewing Highlighted Text

Overview of Viewing
CTX_QUERY.HIGHLIGHT Procedure
Highlighting Mark-up
Using CTX_QUERY.HIGHLIGHT
Allocate Result Tables
Perform a Text 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
Point-of-View Gists
Generic 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

CTX_QUERY: Query and Highlighting
CLOSE_CON
CONTAINS
COUNT_HITS
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 CTXQUERY - Forms Sample Application

Overview of CTXQUERY
Distribution and Usage
Concepts
Layout
CTXQUERY Form Architecture
Startup
Enter the query screen
Start the pre-query trigger
Build the query expression
Display an article in the view block
Invoke the HIGHLIGHT procedure
Perform DML Operations
Cleanup

D Input/Output Utility

Using the CTXIO32 Utility
Command-Line Syntax
Parameter File Format
Example

Index


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

Library
Product
Index