Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming


Other DB2 Extenders

The other extenders in the family let you search for a combination of image, video, and voice data types in one SQL query.

As with Text Extender, these extenders define new data types and functions using DB2 UDB 's built-in support for user-defined types and user-defined functions. You can couple any combination of these data types, that is, image, audio, and video, with a text search query.

The extenders exploit DB2 UDB 's support for large objects of up to 2 gigabytes, and for triggers that provide integrity checking across database tables ensuring the referential integrity of the multimedia data.

Image Extender

With the Image Extender, your applications can:

You can integrate an image query with traditional business database queries. For example, you can program an SQL statement in an application to return miniature images of all pictures whose width and height are smaller than 512 x 512 pixels and whose price is less than $500, and also list the names of each picture's photographer. Using the Image Extender, you can also allow your application users to browse the images.

Video Extender

With the Video Extender, your applications can:

You can integrate a video query with traditional business database queries. For example, you can code an SQL statement in an application to return miniature images and names of the advertising agencies of all commercials whose length is less than 30 seconds, whose frame rate is greater than 15 frames a second, and that contain remarks such as "OS/2 Warp" in the commercial script. Using the Video Extender, you can also allow your application users to play the commercials.

Audio Extender

With the Audio Extender, your applications can:

The Audio Extender supports a variety of audio file formats, such as WAVE and MIDI. Like the Video Extender, the Audio Extender works with different file-based audio servers.

Using the Audio Extender, your applications can integrate audio data and traditional business data in a query. For example, you can code an SQL statement in an application to retrieve miniature images of compact disk (CD) album covers, and the name of singers of all music segments on the CD whose length is less than 1 minute and that were produced in 1990. Using the Audio Extender, you can also allow your application users to play the music segments.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]