DB2 Net Search Extender

Net Search Extender for your on demand business

DB2 Net Search Extender V8 is a member of the DB2 Extender family. Intended to serve high end e-business scenarios, it provides unique query performance and scalability by combining advanced database caching and optimization technologies with text search technology.

The main features of DB2 Net Search Extender are:

Indexing

• Provides fast indexing of large data volumes
• Provides incremental updates of indexes
• Allows caching of table columns in main memory at indexing time to avoid expensive physical read operations at search time
• Provides a choice of command line or interface through the DB2 control Center for indexing
• Stores index and search documents in DB2 as well as other relational databases
• Supports presorted text indexes
• Supports language specific stopword lists to reduce the index size and search speed
• Offers partitioned database support for AIX

Search

• SQL scalar search functions, a stored procedure search and an SQL table-valued function support the following search functions:

• Boolean operations
• Proximity search for words in the same sentence or paragraph
• "Fuzzy" searches for words having a similar spelling as the search term
• Wildcard searches, using front, middle, and end masking, for whole words and single characters
• Free-text searches, for documents containing specific text the search argument is expressed in natural language
• Thesaurus support
• Search restricted to sections within documents
• Search on numeric attributes
• Search for attributes that have a certain range

Search results

• Specify how the search results are sorted at indexing time
• Get the best matching documents first
• Specify search result subsets when searching large data volumes where large result lists are expected
• Set a result limit on queries where a high hit count is anticipated
• Built-in SQL functionality is combined with the optimizer to automatically select the best optimization plan according to expected search results
• Search results are highlighted in Unicode databases