Oracle Multimedia (formerly Oracle interMedia) enables Oracle Database to store, manage, and retrieve images, DICOM format medical images and other objects, audio, video, or other heterogeneous media data in an integrated fashion with other enterprise information.
Oracle Multimedia extends Oracle Database reliability, availability, and data management to multimedia content in traditional, medical, Internet, electronic commerce, and media-rich applications.
1.1 About Multimedia PL/SQL Packages
Oracle Multimedia provides the ORD_AUDIO, ORD_DOC, ORD_IMAGE, and ORD_VIDEO PL/SQL packages, which contain functions and procedures for managing image, audio, and video data stored in BLOBs and BFILEs in Oracle Database. Developers can use these PL/SQL packages to include common operations such as these in their applications:
Extracting information directly from multimedia data, either as an XML string or as XML and individual attributes
Exporting multimedia data from Oracle Database into operating system files
Loading multimedia data from operating system files into Oracle Database
Creating thumbnail images
Converting images to Web-compatible formats
See the following chapters for more information about these Oracle Multimedia PL/SQL packages:
1.2 Multimedia Object Types and Methods
Oracle Multimedia provides the ORDAudio, ORDDoc, ORDImage, ORDVideo, and SI_StillImage object types and methods for:
Extracting metadata and attributes from multimedia data
Embedding metadata created by applications into image files
Getting and managing multimedia data from Oracle Multimedia, Web servers, file systems, and other servers
Performing manipulation operations on image data
Oracle Multimedia also provides the ORDDicom object type and methods for storing, managing, and manipulating DICOM format medical images and other data.
SQL Syntax for Complex Objects
The object syntax for accessing attributes within a complex object is the dot notation (except in Java):
The syntax for invoking methods of a complex object is also the dot notation (except in Java):
variable.function(parameter1, parameter2, ...)
In keeping with recommended programming practices, a complete set of media attribute accessors (get methods) and setters (set methods) are provided for accessing attributes for each media type.
Oracle Database Concepts for more information about complex objects
1.3 Multimedia Storage
Oracle Multimedia provides the ORDSource object type and methods for multimedia data source manipulation. The ORDAudio, ORDDoc, ORDImage, and ORDVideo object types all contain an attribute of type ORDSource.
Do not call ORDSource methods directly. Instead, invoke the wrapper method of the media object corresponding to the ORDSource method. ORDSource method information is presented only for users who want to write their own user-defined sources.
See Oracle Multimedia ORDSource Object Type for more information about ORDSource methods.