 | Level: Introductory Prashant Shettar (pshettar@in.ibm.com), System Software Engineer,
IBM
Marion Behnen (mbehnen@us.ibm.com), DB2 Text Search Development, IBM
Shantanu Mundkur (mundkur@us.ibm.com), DB2 Text Search Development,
IBM
15 Oct 2008 DB2® Text Search enables an IBM® DB2 for Linux®,
UNIX®, and Windows® database user to create applications with full-text search capabilities by embedding full-text search clauses in SQL and XQuery statements. In this tutorial, you'll set up a database to support text search and walk through a scenario to get some experience for setting up your own text searches.
Objectives - Prepare the database setup
- Create text indexes for text data and XML documents
- Populate text indexes
- Search in plain text
- Determine the relevance of results
- Search in XML documents
- Update text indexes
- Clean up
Prerequisites
Make sure that you have DBADM authority on the DB2 database server that you want to use.
System requirements
To complete the following steps, you must have at least IBM DB2 9.5 for Linux, UNIX, and Windows, Fixpack 1 installed on the system. Note that you cannot activate the text search services on a system that uses the Database Partitioning Feature.
Formats html, pdf
Tutorial overview
DB2 Text Search is an integrated component of DB2 9.5 and is powered by the IBM OmniFind™ Text Search server. It provides the following features:
- Full-text search in text, HTML, and XML documents, including Boolean and wildcard search
- Fully integrated SQL, SQL/XML, and XQuery support, including XPath syntax subset to search XML documents
- Linguistic processing with optional synonyms definition
- Asynchronous index update with scheduling option
This tutorial demonstrates how to use the basic features of DB2 Text Search to
search in plain text and XML documents stored in the database
| | | |
