Oracle Text. Application Developers Guide

Send Us Your Comments......Page 9
Preface......Page 11
1 Introduction to Oracle Text......Page 19
Document Classification Applications......Page 20
Query Language and Operators......Page 21
Prerequisites For Building Your Query Application......Page 22
Loading Your Text Table......Page 23
Storing URLs......Page 24
Supported Document Formats......Page 25
Loading Text from File-System......Page 26
Type of Index......Page 27
General Defaults for All Languages......Page 28
Customizing Your CONTEXT Index......Page 29
Index Maintenance......Page 30
A Simple Text Query Application......Page 32
Word Query Example......Page 34
Structured Field Searching......Page 35
Other Query Features......Page 36
Hitlist Example......Page 38
Presenting Document Hit Count......Page 40
Document Presentation and Highlighting......Page 41
Highlighting Example......Page 42
Document List of Themes Example......Page 43
Gist Example......Page 44
2 Indexing......Page 45
Structure of the Oracle Text CONTEXT Index......Page 46
Merged Word and Theme Index......Page 47
Datastore Object......Page 48
Indexing Engine......Page 49
Parallel Indexing......Page 50
Indexing Views......Page 51
Considerations For Indexing......Page 52
Type of Index......Page 53
Location of Text......Page 54
Document Formats and Filtering......Page 55
Document Character Set......Page 56
Indexing Special Characters......Page 57
Other Characters......Page 58
Base-Letter Conversion for Characters with Diacritical Marks......Page 59
Composite Words......Page 60
Better Wildcard Query Performance......Page 61
Multi-Language Stoplists......Page 62
Procedure for Creating a CONTEXT Index......Page 64
Specifying MULTI_COLUMN_DATASTORE......Page 65
PROCEDURE_FILTER Example......Page 66
MULTI_LEXER Example: Indexing a Multi-Language Table......Page 67
BASIC_WORDLIST Example: Enabling Substring and Prefix Indexing......Page 68
Using Stopwords and Stoplists......Page 69
PL/SQL Procedures for Managing Stoplists......Page 70
Default CONTEXT Index Example......Page 71
Custom CONTEXT Index Example: Indexing HTML Documents......Page 72
About CTXCAT Sub-Indexes and Their Costs......Page 73
Creating CTXCAT Sub-indexes......Page 74
Structured Query Clause Category B......Page 75
Create a Table of Queries......Page 76
Classifying a Document......Page 77
Resuming Failed Index......Page 78
Example......Page 79
Synchronizing the Index......Page 80
Index Fragmentation......Page 81
Examples: Optimizing the Index......Page 82
3 Querying......Page 85
CONTAINS SQL Example......Page 86
Structured Query with CONTAINS......Page 87
CATSEARCH SQL Query......Page 88
MATCHES SQL Query......Page 89
MATCHES PL/SQL Example......Page 90
Word and Phrase Queries......Page 91
ABOUT Queries and Themes......Page 92
CATSEARCH Operator......Page 93
Stopwords and Case-Sensitivity......Page 94
Query Explain Plan......Page 95
Logical Operators......Page 97
Stored Query Expressions......Page 99
Calling PL/SQL Functions in CONTAINS......Page 100
Query Operators for CATSEARCH......Page 102
Retrieving a Range of Documents......Page 103
PL/SQL Count Hits Example......Page 105
4 Document Presentation......Page 107
Highlight Procedure......Page 108
Filter Procedure......Page 109
In-Memory Themes......Page 110
In-Memory Gist......Page 111
Theme Summary......Page 112
5 Query Tuning......Page 115
Collecting Statistics......Page 116
Re-Collecting Statistics......Page 117
Deleting Statistics......Page 118
Better Response Time with FIRST_ROWS......Page 119
Better Response Time with CHOOSE......Page 120
FIRST_ROWS Mode......Page 122
Tuning Queries with Blocking Operations......Page 123
6 Document Section Searching......Page 125
Create a Section Group......Page 126
Path Searching with INPATH and HASPATH Operators......Page 128
Zone Section......Page 129
Nested Zone Sections......Page 130
Visible and Invisible Field Sections......Page 131
Attribute Section......Page 132
Special Section......Page 133
Searching HTML Meta Tags......Page 134
Example: Creating Sections for Tags......Page 135
Attribute Searching......Page 136
Creating Document Type Sensitive Sections......Page 137
Path Section Searching......Page 138
Any-Level Tag Searching......Page 139
Attribute Value Testing......Page 140
Section Equality Testing with HASPATH......Page 141
7 Working With a Thesaurus......Page 143
ctxload Utility......Page 144
Case-insensitive Thesauri......Page 145
Supplied Thesaurus Structure and Content......Page 146
Supplied Thesaurus Location......Page 147
Defining Hierarchical Relations......Page 148
Limitations......Page 150
Limitations......Page 151
Loading a Thesaurus with ctxload......Page 152
Compiling a Loaded Thesaurus......Page 153
Knowledge Base Character Set......Page 154
Limitations......Page 155
8 Administration......Page 157
Granting Roles and Privileges to Users......Page 158
DML Queue......Page 159
The CTX_OUTPUT Package......Page 160
Servers......Page 161
Administration Tool......Page 162
A A CONTEXT Query Application......Page 163
The PSP Web Application......Page 164
Building the Web Application......Page 165
loader.ctl......Page 168
loader.dat......Page 169
search_htmlservices.sql......Page 170
search_html.psp......Page 172
Index......Page 175