Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Conventions
• Understanding Oracle Text Application Development
  • Introduction to Oracle Text
  • Document Collection Applications
    • About Document Collection Applications
    • Flowchart of Text Query Application
  • Catalog Information Applications
    • About Catalog Information Applications
    • Flowchart for Catalog Query Application
  • Document Classification Applications
  • XML Search Applications
    • The CONTAINS Operator with XML Search Applications
    • Combining Oracle Text Features with Oracle XML DB (XML Search Index)
      • Using the xml_enable Method for an XML Search Index
      • Using the Text-on-XML Method
      • Indexing JSON Data
• Getting Started with Oracle Text
  • Overview of Getting Started with Oracle Text
  • Creating an Oracle Text User
  • Query Application Quick Tour
    • Creating the Text Table
    • Using SQL*Loader to Load the Table
  • Catalog Application Quick Tour
    • Creating the Table
    • Using SQL*Loader to Load the Table
  • Classification Application Quick Tour
    • About Classification of a Document
    • Creating a Classification Application
• Indexing with Oracle Text
  • About Oracle Text Indexes
    • Types of Oracle Text Indexes
    • Structure of the Oracle Text CONTEXT Index
    • Oracle Text Indexing Process
      • Datastore Object
      • Filter Object
      • Sectioner Object
      • Lexer Object
      • Indexing Engine
    • About Updates to Indexed Columns
    • Partitioned Tables and Indexes
    • Online Indexes
    • Parallel Indexing
    • Indexing and Views
  • Considerations for Oracle Text Indexing
    • Location of Text
    • Supported Column Types
    • Storing Text in the Text Table
    • Storing File Path Names
    • Storing URLs
    • Storing Associated Document Information
    • Format and Character Set Columns
    • Supported Document Formats
    • Summary of DATASTORE Types
    • Document Formats and Filtering
      • No Filtering for HTML
      • Mixed-Format Columns Filtering
      • Custom Filtering
    • Bypass Rows
    • Document Character Set
  • Document Language
  • Special Characters
  • Case-Sensitive Indexing and Querying
  • Improved Document Services Performance with a Forward Index
    • Enabling Forward Index
    • Forward Index with Snippets
    • Forward Index with Save Copy
    • Forward Index Without Save Copy
    • Save Copy Without Forward Index
  • Language-Specific Features
    • Theme Indexing
    • Base-Letter Conversion for Characters with Diacritical Marks
    • Alternate Spelling
    • Composite Words
    • Korean, Japanese, and Chinese Indexing
  • About Entity Extraction and CTX_ENTITY
    • Basic Example of Using Entity Extraction
    • Example of Creating a New Entity Type by Using a User-Defined Rule
  • About Fuzzy Matching and Stemming
  • Better Wildcard Query Performance
  • Document Section Searches
  • Stopwords and Stopthemes
  • Index Performance
  • Query Performance and Storage of Large Object (LOB) Columns
  • Mixed Query Performance
  • In-Memory Full Text Search and JSON Full Text Search
• Creating Oracle Text Indexes
  • Summary of the Procedure for Creating an Oracle Text Index
  • Creating Preferences
  • Section Searching Example: Creating HTML Sections
  • Using Stopwords and Stoplists
    • Multilanguage Stoplists
    • Stopthemes and Stopclasses
    • PL/SQL Procedures for Managing Stoplists
  • Creating a CONTEXT Index
    • CONTEXT Index and DML
    • Default CONTEXT Index Example
    • Incrementally Creating a CONTEXT Index
    • Custom CONTEXT Index Example: Indexing HTML Documents
    • CONTEXT Index Example: Query Processing with FILTER BY and ORDER BY
  • Creating a CTXCAT Index
    • CTXCAT Index and DML Operations
    • About CTXCAT Subindexes and Their Costs
    • Creating CTXCAT Subindexes
    • Creating CTXCAT Index
  • Creating a CTXRULE Index
  • Creating a JSON Search Index
  • Creating an Oracle Text Search Index
  • Creating a Hybrid Vector Index
• Maintaining Oracle Text Indexes
  • Viewing Index Errors
  • Dropping an Index
  • Resuming a Failed Index
  • Re-creating an Index
    • Re-creating a Global Index
    • Re-creating a Local Partitioned Index
  • Rebuilding an Index
  • Dropping a Preference
  • Managing DML Operations for a CONTEXT Index
    • Viewing Pending DML Operations
    • Synchronizing the Index
    • Optimizing the Index
      • Index Fragmentation
      • Document Invalidation and Garbage Collection
      • Single Token Optimization
      • Viewing Index Fragmentation and Garbage Data
  • Using Automatic Maintenance for an Index
    • About Automatic Maintenance
    • Requirements and Restrictions for Automatic Maintenance
    • Asynchronous Maintenance Framework
    • Enabling and Disabling Automatic Maintenance
    • Switching between Automatic and Manual Maintenance
    • Monitoring Maintenance Events and Errors
• Querying with Oracle Text
  • Overview of Queries
    • Querying with CONTAINS
      • CONTAINS SQL Example
      • CONTAINS PL/SQL Example
      • Structured Query with CONTAINS Example
    • Querying with CATSEARCH
      • CATSEARCH SQL Query Example
      • CATSEARCH Example
    • Querying with MATCHES
      • MATCHES SQL Query
      • MATCHES PL/SQL Examples
    • Word and Phrase Queries
    • Querying Stopwords
    • ABOUT Queries and Themes
  • Oracle Text Query Features
    • Query Expressions
      • CONTAINS Operators
      • CATSEARCH Operator
      • MATCHES Operator
    • Case-Sensitive Searching
    • Query Feedback
    • Query Explain Plan
    • Using a Thesaurus in Queries
    • Document Section Searching
    • Using Query Templates
      • Query Rewrite
      • Query Relaxation
      • Query Language
      • Ordering by SDATA Sections
      • Alternative and User-Defined Scoring
      • Alternative Grammar
    • Query Analysis
    • Other Query Features
• Working with CONTEXT and CTXCAT Grammars in Oracle Text
  • The CONTEXT Grammar
    • ABOUT Query
    • Logical Operators
    • Section Searching and HTML and XML
    • Proximity Queries with NEAR, and NEAR2 Operators
    • Fuzzy, Stem, Soundex, Wildcard and Thesaurus Expansion Operators
    • Using CTXCAT Grammar
    • Defined Stored Query Expressions
      • Defining a Stored Query Expression
      • SQE Example
    • Calling PL/SQL Functions in CONTAINS
    • Optimizing for Response Time
    • Counting Hits
    • Using DEFINESCORE and DEFINEMERGE for User-Defined Scoring
  • The CTXCAT Grammar
• Presenting Documents in Oracle Text
  • Highlighting Query Terms
    • Text highlighting
    • Theme Highlighting
    • CTX_DOC Highlighting Procedures
      • Markup Procedure
      • Highlight Procedure
      • Concordance
  • Obtaining Part-of-Speech Information for a Document
  • Obtaining Lists of Themes, Gists, and Theme Summaries
    • Lists of Themes
    • Gist and Theme Summary
  • Presenting and Highlighting Documents
• Classifying Documents in Oracle Text
  • Overview of Document Classification
  • Classification Applications
  • Classification Solutions
  • Rule-Based Classification
    • Rule-Based Classification Example
    • CTXRULE Parameters and Limitations
  • Supervised Classification
    • Decision Tree Supervised Classification
    • Decision Tree Supervised Classification Example
    • SVM-Based Supervised Classification
    • SVM-Based Supervised Classification Example
  • Unsupervised Classification (Clustering)
  • Unsupervised Classification (Clustering) Example
• Tuning Oracle Text
  • Optimizing Queries with Statistics
    • Collecting Statistics
    • Query Optimization with Statistics Example
    • Re-Collecting Statistics
    • Deleting Statistics
  • Optimizing Queries for Response Time
    • Other Factors That Influence Query Response Time
    • Improved Response Time with the FIRST_ROWS(n) Hint for ORDER BY Queries
    • Improved Response Time Using the DOMAIN_INDEX_SORT Hint
    • Improved Response Time Using the Local Partitioned CONTEXT Index
    • Improved Response Time with the Local Partitioned Index for Order by Score
    • Improved Response Time with the Query Filter Cache
    • Improved Response Time Using the BIG_IO Option of CONTEXT Index
    • Improved Response Time Using the SEPARATE_OFFSETS Option of the CONTEXT Index
    • Improved Response Time Using the STAGE_ITAB, STAGE_ITAB_MAX_ROWS, and STAGE_ITAB_PARALLEL Options of CONTEXT Index
  • Optimizing Queries for Throughput
  • Composite Domain Index in Oracle Text
  • Performance Tuning with CDI
  • Solving Index and Query Bottlenecks by Using Tracing
  • Using Parallel Queries
    • Parallel Queries on a Local Context Index
    • Parallelizing Queries Across Oracle RAC Nodes
  • Tuning Queries with Blocking Operations
  • Frequently Asked Questions About Query Performance
    • What is query performance?
    • What is the fastest type of Oracle Text query?
    • Should I collect statistics on my tables?
    • How does the size of my data affect queries?
    • How does the format of my data affect queries?
    • What is the difference between an indexed lookup and a functional lookup
    • What tables are involved in queries?
    • How is the $R table contention reduced?
    • Does sorting the results slow a text-only query?
    • How do I make an ORDER BY score query faster?
    • Which memory settings affect querying?
    • Does out-of-line LOB storage of wide base table columns improve performance?
    • How can I speed up a CONTAINS query on more than one column?
    • Can I have many expansions in a query?
    • How can local partition indexes help?
    • Should I query in parallel?
    • Should I index themes?
    • When should I use a CTXCAT index?
    • When is a CTXCAT index NOT suitable?
    • What optimizer hints are available and what do they do?
  • Frequently Asked Questions About Indexing Performance
    • How long should indexing take?
    • Which index memory settings should I use?
    • How much disk overhead will indexing require?
    • How does the format of my data affect indexing?
    • Can parallel indexing improve performance?
    • How can I improve index performance when I create a local partitioned index?
    • How can I tell how much indexing has completed?
  • Frequently Asked Questions About Updating the Index
    • How often should I index new or updated records?
    • How can I tell when my indexes are fragmented?
    • Does memory allocation affect index synchronization?
• Searching Document Sections in Oracle Text
  • About Oracle Text Document Section Searching
    • Enabling Oracle Text Section Searching
      • Create a Section Group
      • Define Your Sections
      • Index Your Documents
      • Search Sections with the WITHIN Operator
      • Search Paths with INPATH and HASPATH Operators
      • Mark an SDATA Section to Be Searchable
    • Oracle Text Section Types
      • Zone Section
      • Field Section
      • Stop Section
      • MDATA Section
      • NDATA Section
      • SDATA Section
      • Attribute Section
      • Special Sections
    • Oracle Text Section Attributes
  • HTML Section Searching with Oracle Text
    • Creating HTML Sections
    • Searching HTML Meta Tags
  • XML Section Searching with Oracle Text
    • Automatic Sectioning
    • Attribute Searching
    • Document Type Sensitive Sections
    • Path Section Searching
      • Creating an Index with PATH_SECTION_GROUP
      • Top-Level Tag Searching
      • Any-Level Tag Searching
      • Direct Parentage Searching
      • Tag Value Testing
      • Attribute Searching
      • Attribute Value Testing
      • Path Testing
      • Section Equality Testing with HASPATH
• Using Oracle Text Name Search
  • Overview of Name Search
  • Name Search Examples
• Performing Ubiquitous Search with DBMS_SEARCH APIs
  • About Ubiquitous Search and Ubiquitous Search Indexes
  • Perform Ubiquitous Search: End-to-End Examples
    • Create and Query DBMS_SEARCH Indexes Using Multiple Tables and Views
    • Use JSON Duality Views with DBMS_SEARCH Indexes
    • Examine DBMS_SEARCH Indexes Using Dictionary Views
• Working with a Thesaurus in Oracle Text
  • Overview of Oracle Text Thesaurus Features
    • Oracle Text Thesaurus Creation and Maintenance
    • Using a Case-Sensitive Thesaurus
    • Using a Case-Insensitive Thesaurus
    • Default Thesaurus
    • Supplied Thesaurus
  • Defining Terms in a Thesaurus
    • Defining Synonyms
    • Defining Hierarchical Relations
  • Using a Thesaurus in a Query Application
  • Loading a Custom Thesaurus and Issuing Thesaurus-Based Queries
  • Augmenting the Knowledge Base with a Custom Thesaurus
    • Advantages
    • Limitations
  • Linking New Terms to Existing Terms
  • Example of Loading a Thesaurus with ctxload
  • Example of Loading a Thesaurus with the CTX_THES.IMPORT_THESAURUS PL/SQL procedure
  • Compiling a Loaded Thesaurus
  • About the Supplied Knowledge Base
    • Adding a Language-Specific Knowledge Base
    • Limitations for Adding Knowledge Bases
• Using Faceted Navigation
  • About Faceted Navigation
  • Defining Sections As Facets
  • Querying Facets by Using the Result Set Interface
  • Refining Queries by Using Facets As Filters
  • Multivalued Facets
• Using Result Set Interface
  • Overview of the XML Query Result Set Interface
  • Using the XML Query Result Set Interface
  • Creating XML-Only Applications with Oracle Text
  • Example of a Result Set Descriptor
  • Identifying Collocates
  • Overview of the JSON Result Set Interface
  • Using the JSON Result Set Interface
• Performing Sentiment Analysis Using Oracle Text
  • Overview of Sentiment Analysis
    • About Sentiment Analysis
    • About Sentiment Classifiers
    • About Performing Sentiment Analysis
    • Sentiment Analysis Interfaces
  • Creating a Sentiment Classifier Preference
  • Training Sentiment Classifiers
  • Performing Sentiment Analysis with the CTX_DOC Package
  • Performing Sentiment Analysis with the RSI
• Working with Sharded Databases
  • Running Oracle Text PL/SQL APIs in a Sharded Database
  • Supported APIs in a Sharded Database
• Administering Oracle Text
  • Oracle Text Users and Roles
    • CTXSYS User
    • CTXAPP Role
    • Granting Roles and Privileges to Users
  • DML Queue
  • CTX_OUTPUT Package
  • CTX_REPORT Package
  • Text Manager in Oracle Enterprise Manager
    • Using Text Manager
    • Viewing General Information for an Oracle Text Index
    • Checking Oracle Text Index Health
  • Servers and Indexing
  • Tracking Database Feature Usage in Oracle Enterprise Manager
  • Oracle Text on Oracle Real Application Clusters
  • Configuring Oracle Text in Oracle Database Vault Environment
  • Unsupported Oracle Text Operations in Oracle Database Vault Realm
  • Export and Import of Schemas Containing Oracle Text Settings
• Migrating Oracle Text Applications
  • Performing a Rolling Upgrade with a Logical Standby Database
    • CTX_DDL PL/SQL Procedures
    • CTX_OUTPUT PL/SQL Procedures
    • CTX_DOC PL/SQL Procedures
  • Identifying and Copying Oracle Text Files to a New Oracle Home
• CONTEXT Query Application
  • Web Query Application Overview
  • The PL/SQL Server Pages (PSP) Web Application
    • PSP Web Application Prerequisites
    • Building the PSP Web Application
    • PSP Web Application Sample Code
      • loader.ctl
      • loader.dat
      • HTML Files for loader.dat Example
      • search_htmlservices.sql
      • search_html.psp
  • The Java Server Pages (JSP) Web Application
    • JSP Web Application Prerequisites
    • JSP Web Application Sample Code
• CATSEARCH Query Application
  • CATSEARCH Web Query Application Overview
  • The JSP Web Application
    • Building the JSP Web Application
    • JSP Web Application Sample Code
      • loader.ctl
      • loader.dat
      • catalogSearch.jsp
• Custom Index Preference Examples
  • Datastore Examples
  • NULL_FILTER Example: Indexing HTML Documents
  • PROCEDURE_FILTER Example
  • BASIC_LEXER Example: Setting Printjoin Characters
  • MULTI_LEXER Example: Indexing a Multilanguage Table
  • BASIC_WORDLIST Example: Enabling Substring and Prefix Indexing
  • BASIC_WORDLIST Example: Enabling Wildcard Index