Articles & Content

Archives

High Performance Free Form Text Searching in DB2: Text Search vrs NSE 9.7 (D14)

Topic: DB2 for LUW

Subtopic: 2010



DATE: 2010-5-14 (09:45 AM - 10:45 AM)
SPEAKERS: Robert Donaldson (LSSiData)

This presentation discusses full text search options in DB2. Solutions compared from a performance perspective are: Word support tables, old legacy NSE, Text Search (introduced in DB2 9.5) and the new NSE introduced in 9.7. Capabilities are compared with main focus on performance and usage limitations and notes. Text searching in DB2 7.2, 8.x, and 9.1, was almost usable. Often unstable if you had lots of text indexes. 9.5 introduced a new Text Search based on the OmniFind engine, solid stability, but indexing performance was not as good. DB2 9.7 brings in a far improved NSE that delivers both the stability we've been waiting for and high performance. Special attention is on the improvements that make NSE 9.7 a true enterprise solution that is has never been in the past. Discard your prior experiences with NSE, it's worth a new look. The old performance and stability limitations of parallel indexing are gone.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Know what free form text search options are available in DB2 UDB 9.1, 9.5, and 9.7. Old NSE (DB2 7.2, 8.x, 9.1, 9.5), Text Search (introduced in DB2 9.5), New NSE 9.7, and the old fashioned word support table method.

Compare the functionality between the text search options.

Real world indexing performance and space requirements.

Text indexing update considerations.

Things I've learned to watch out for and advise on usage, primarily relating to NSE.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.