List of Examples

3-1 Define a Song Object

3-2 Create a Table Named SongsTable

3-3 Create a List Object Containing a List of References to Songs

3-4 Define the Implementation of the songList Object

3-5 Create a CD Table Containing CD Information

3-6 Insert a Song into the SongsTable Table

3-7 Insert a CD into the CdTable Table

3-8 Load a Song into the SongsTable Table

3-9 Insert a Reference to a Song Object into the Songs List in the CdTable Table

3-10 Add a CD Reference to a Song

3-11 Retrieve Audio Data from a Song in a CD

3-12 Define a Relational Table Containing No ORDAudio Object

3-13 Define an Object View Containing an ORDAudio Object and Relational Columns

3-14 Define a Media Object

3-15 Create a Table Named DocumentsTable

3-16 Create a List Object Containing a List of References to Media

3-17 Define the Implementation of the documentList Object

3-18 Create a Library Table Containing Library Information

3-19 Insert Media into the DocumentsTable Table

3-20 Insert a Library into the LibraryTable Table

3-21 Load Media into the DocumentsTable Table

3-22 Insert a Reference to a Document Object into the Documents List in the LibraryTable Table

3-23 Add a Library Reference to a Document

3-24 Build a Repository of Media

3-25 Add New Columns of Type ORDImage and ORDImageSignature to the stockphotos Table

3-26 Create the stockphotos Table and Add ORDImage and ORDImageSignature Types

3-27 Insert a Row into a Table with Empty Data in the ORDImage Type Column

3-28 Populate a Row with ORDImage BLOB Data

3-29 Insert a Row into a Table Pointing to an External Image Data File

3-30 Populate a Row with ORDImage External File Data

3-31 Query Rows of ORDImage Data for Widths Greater Than 32 Pixels

3-32 Query Rows of ORDImage Data for Widths Greater Than 32 Pixels and a Minimum Content Length

3-33 Import an Image from an External File

3-34 Table stockphotos Definition Used for Content-Based Retrieval of Images

3-35 Load the stockphotos Table with Image Data

3-36 Check the Contents of the stockphotos Table

3-37 Create the Tablespaces for the Index

3-38 Retrieve an Image (Simple Read)

3-39 Retrieve Images Similar to a Comparison Image

3-40 Find photo_id and Score of Similar Image

3-41 Create an interMedia Index

3-42 Copy an Image

3-43 Convert an Image Format

3-44 Copy and Convert an Image Format

3-45 Extend Oracle interMedia with a New Object Type

3-46 Define a Relational Table Containing No ORDImage Object

3-47 Define an Object View Containing an ORDImage Object and Relational Columns

3-48 Address a Globalization Support Issue

3-49 Define a Clip Object

3-50 Create a Table Named ClipsTable

3-51 Create a List Object Containing a List of Clips

3-52 Define the Implementation of the clipList Object

3-53 Create a Video Table Containing Video Information

3-54 Insert a Video Clip into the ClipsTable Table

3-55 Insert a Row into the VideoTable Table

3-56 Load a Video into the ClipsTable Table

3-57 Insert a Reference to a Clip Object into the Clips List in the VideoTable Table

3-58 Insert a Reference to a Video Object into the Clip

3-59 Retrieve a Video Clip

3-60 Define a Relational Table Containing No ORDVideo Object

3-61 Define an Object View Containing an ORDVideo Object and Relational Columns

6-1 Show the Package Body for Extending Support to a New Audio
Data Format

7-1 Show the Package Body for Extending Support to a New Media
Data Format

9-1 Show the Package Body for Extending Support to a New Video
Data Format

11-1 Create a Separate Tablespace to Store an interMedia Column Object Containing LOB Data

11-2 Show the Load1.bat File

11-3 Show the T1.SQL File

11-4 Show the Load1.sql File that Executes the load_image Stored Procedure

11-5 Show the Control File for Loading Video Data

11-6 Read Data from an ORDVideo Column Object Using interMedia readFromSource( ) Method in a PL/SQL Stored Procedure

F-1 Execute the Demo from the Command Line

I-1 Show the Package Body for Extending Support to a New Data Source