Text Extender

DB2 Text Extender was designed to perform advanced text search faster and more efficiently than regular SQL. Databases are more often storing large text documents. Traditional data types can be difficult to search when exact information is not known. SQL is unaware of linguistic properties in determining a search match. DB2 Text Extender can interpret text fields and formatted documents. DB2 Text Extender can identify language, sentence, and paragraph structure. It is a useful addition to DB2 for providing assistance in searching text data.

Traditional Text Searching

Traditional data types store a single property of an entity into a single database field. Tables are used to group these properties together. For example, a table may ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.