An advertising agency maintains a DB2 database of its advertisements. In the past, the agency stored numeric and character data about each ad campaign, such as the name of the client and the date that an advertisement was completed. With the installation of DB2 UDB and the DB2 extenders, the agency now also stores the content of the advertisements in the database. This includes images of print advertisements, videos of television advertisements, and recordings of radio advertisements. As the following figure shows, all of the related advertising information is in one database table that is named ADS. The table contains image, audio, and video data as well as traditional data types. A video, audio, and image are shown.
Figure 1. A multimedia database table
![]() |