IBM Books

Image, Audio, and Video Extenders Administration and Programming


An extender scenario

The personnel department of a company wants to create a personnel database (in DB2 for AIX) that includes pictures of each employee.

A Database with pictures: As the following figure shows, an employee table in the database will contain the identification and name of each employee, as well as the employee's picture.




REQTEXT

To prepare the personnel database for image processing, a system administrator, that is, someone with SYSADM authority, begins by starting extender services. The system administrator then creates the database and enables it for use by the Image Extender.

A database administrator (DBA), or someone with equivalent authority, creates the employee table and then enables it and the employee picture column for use by the Image Extender.

A Database with sound: After the personnel database and employee table are prepared for image processing, the personnel department decides to add an audio recording for each employee to the table. This is shown in the following figure.




REQTEXT

The system administrator alters the table by adding a new column and enables the database, table, and column for use by the Audio Extender.

Users in the personnel department then insert data into, select and display data from, update data in, and delete data from the table.


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