Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle Multimedia

• New Features for Release 11.2

1 Introduction to Oracle Multimedia

• 1.1 Object Relational Technology
• 1.2 Oracle Multimedia Capabilities
• 1.3 Audio Concepts
  • 1.3.1 Digitized Audio
  • 1.3.2 Audio Components
• 1.4 ORDDoc or Heterogeneous Media Data Concepts
  • 1.4.1 Digitized Heterogeneous Media Data
  • 1.4.2 Heterogeneous Media Data Components
• 1.5 Image Concepts
  • 1.5.1 Digitized Images
  • 1.5.2 Image Components
  • 1.5.3 Metadata in Images
  • 1.5.4 Medical Imaging
  • 1.5.5 Metadata Extraction
  • 1.5.6 Image Processing
  • 1.5.7 SQL/MM Still Image Standard Support
• 1.6 Video Concepts
  • 1.6.1 Digitized Video
  • 1.6.2 Video Components
• 1.7 Multimedia Storage and Querying
  • 1.7.1 Storing Multimedia Data
  • 1.7.2 Querying Multimedia Data
• 1.8 Loading Multimedia Data
• 1.9 Accessing Multimedia Data
  • 1.9.1 Oracle Multimedia Java API
  • 1.9.2 Streaming Content from Oracle Database
  • 1.9.3 Support for Web Technologies
  • 1.9.4 Oracle Multimedia Support for Java Advanced Imaging (JAI)
• 1.10 Oracle Multimedia Architecture
• 1.11 Extending Oracle Multimedia

2 Application Development

• 2.1 Overview of the Application Development Environment
• 2.2 Developing PL/SQL Client Applications Using the PL/SQL API
  • 2.2.1 Setting Up Your Environment for PL/SQL
  • 2.2.2 Media Query in PL/SQL
  • 2.2.3 Media Download in PL/SQL
  • 2.2.4 Media Upload in PL/SQL
  • 2.2.5 Handling Oracle Multimedia Exceptions in PL/SQL
    • 2.2.5.1 Handling the Setting of Properties for Unknown Image Formats
    • 2.2.5.2 Handling Image Processing for Unknown Image Formats
• 2.3 Developing PL/SQL Web Applications
  • 2.3.1 Using the PL/SQL Gateway and PL/SQL Web Toolkit
• 2.4 Developing Java Client Applications Using JDBC
  • 2.4.1 Setting Up Your Environment for Java
  • 2.4.2 Media Retrieval in Java
  • 2.4.3 Media Upload in Java
  • 2.4.4 Handling Oracle Multimedia Exceptions in Java
    • 2.4.4.1 Handling the Setting of Properties for Unknown Image Formats
    • 2.4.4.2 Handling Image Processing for Unknown Image Formats
• 2.5 Developing Java-Based Web Applications
  • 2.5.1 Media Retrieval in Java-Based Web Applications
    • 2.5.1.1 Media URL
    • 2.5.1.2 Media Delivery Component
  • 2.5.2 Media Upload in Java-Based Web Applications

3 Oracle Multimedia Photo Album Sample Applications

• 3.1 Oracle Multimedia PL/SQL Photo Album Sample Application
  • 3.1.1 Running the PL/SQL Photo Album Application
  • 3.1.2 Description of the PL/SQL Photo Album Application
    • 3.1.2.1 Browsing the Photo Album
    • 3.1.2.2 Adding Images to the Photo Album
    • 3.1.2.3 Searching for Images by Keyword or Phrase
    • 3.1.2.4 Viewing Full-Size Images
    • 3.1.2.5 Examining Image Metadata
    • 3.1.2.6 Writing New XMP Metadata to Images
    • 3.1.2.7 Searching for Images That Contain Specific Metadata Attributes
• 3.2 Oracle Multimedia Java Servlet Photo Album Sample Application
  • 3.2.1 Running the Java Servlet Photo Album Application
  • 3.2.2 Description of the Java Servlet Photo Album Application
• 3.3 Oracle Multimedia JSP Photo Album Sample Application
  • 3.3.1 Running the JSP Photo Album Application
  • 3.3.2 Description of the JSP Photo Album Application

4 Oracle Multimedia Code Wizard Sample Application

• 4.1 Overview of the Code Wizard Sample Application
  • 4.1.1 Creating a New DAD or Choosing an Existing DAD
  • 4.1.2 Authorizing a DAD
  • 4.1.3 Creating and Testing Media Upload and Retrieval Procedures
  • 4.1.4 Creating a Media Upload Procedure
  • 4.1.5 Creating a Media Retrieval Procedure
  • 4.1.6 Using the PL/SQL Gateway Document Table
  • 4.1.7 How Time Zone Information Is Used to Support Browser Caching
• 4.2 Sample Session Using Images
• 4.3 Sample Session Using Multiple Object Columns
• 4.4 Known Restrictions of the Oracle Multimedia Code Wizard

5 Oracle Multimedia Java API Sample Application

• 5.1 Overview of the Oracle Multimedia Java API Sample Application
• 5.2 Description of the Oracle Multimedia Java API Sample Application
  • 5.2.1 IMProductDialog Class
  • 5.2.2 IMImagePanel Class
  • 5.2.3 IMGetMetadataDialog Class
  • 5.2.4 IMPutMetadataDialog Class
  • 5.2.5 IMVideoPanel Class
  • 5.2.6 IMAudioPanel Class
  • 5.2.7 IMDocPanel Class
  • 5.2.8 IMLoadFile Class
  • 5.2.9 IMUtil Class

6 Working with Metadata in Images

• 6.1 Metadata Concepts
• 6.2 Oracle Multimedia Image Metadata Concepts
• 6.3 Image File Formats
• 6.4 Image Metadata Formats
  • 6.4.1 EXIF
  • 6.4.2 IPTC–IIM
  • 6.4.3 XMP
• 6.5 Representing Metadata Outside Images
• 6.6 Oracle Multimedia Image Metadata Examples
  • 6.6.1 Creating a Table for Metadata Storage
  • 6.6.2 Extracting Image Metadata
  • 6.6.3 Embedding Image Metadata
• 6.7 Metadata References

7 Extending Oracle Multimedia

• 7.1 Supporting Other External Sources
  • 7.1.1 Packages or PL/SQL Plug-ins
    • 7.1.1.1 ORDPLUGINS.ORDX_FILE_SOURCE Package
    • 7.1.1.2 ORDPLUGINS.ORDX_HTTP_SOURCE Package
    • 7.1.1.3 Extending Oracle Multimedia to Support a New Data Source
• 7.2 Supporting Other Media Data Formats
  • 7.2.1 Supporting Other ORDAudio Data Formats
    • 7.2.1.1 ORDPLUGINS.ORDX_DEFAULT_AUDIO Package
    • 7.2.1.2 Extending Oracle Multimedia to Support a New Audio Data Format
  • 7.2.2 Supporting Other ORDDoc Data Formats
    • 7.2.2.1 ORDPLUGINS.ORDX_DEFAULT_DOC Package
    • 7.2.2.2 Extending Oracle Multimedia to Support a New ORDDoc Data Format
  • 7.2.3 Supporting Other Video Data Formats
    • 7.2.3.1 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package
    • 7.2.3.2 Extending Oracle Multimedia to Support a New Video Data Format
  • 7.2.4 Supporting Other Image Data Formats
• 7.3 Extending Oracle Multimedia with a New Type
• 7.4 Supporting Media Data Processing
  • 7.4.1 Supporting Audio Data Processing
  • 7.4.2 Supporting Video Data Processing

8 Tuning Tips for DBAs

• 8.1 Understanding the Performance Profile of Oracle Multimedia Operations
• 8.2 Choosing LOB Storage Parameters for Oracle Multimedia Objects
  • 8.2.1 SecureFile LOBs and BasicFile LOBs
  • 8.2.2 TABLESPACE
  • 8.2.3 CACHE, NOCACHE, and CACHE READS
  • 8.2.4 LOGGING and NOLOGGING
  • 8.2.5 CHUNK
  • 8.2.6 Example of Setting LOB Storage Options
• 8.3 Setting Database Initialization Parameters

9 Oracle Multimedia Examples

• 9.1 Audio Data Examples
  • 9.1.1 Using Audio Types with Object Views
  • 9.1.2 Scripts for Populating an ORDAudio Object with BLOB Data
    • 9.1.2.1 Create an Audio Data Load Directory
    • 9.1.2.2 Create and Populate the soundtable Table
    • 9.1.2.3 Create the audio_table Table
    • 9.1.2.4 Load the Audio Data
    • 9.1.2.5 Copy the BLOB Data to the ORDAudio Object
    • 9.1.2.6 Show the Properties of the Loaded Audio Data
    • 9.1.2.7 Automate the ORDAudio Examples
    • 9.1.2.8 Clean Up the ORDAudio Examples
• 9.2 Media Data Examples
  • 9.2.1 Scripts for Populating an ORDDoc Object from a File Data Source
    • 9.2.1.1 Create a Media Data Load Directory
    • 9.2.1.2 Create the doc_table Table
    • 9.2.1.3 Load the Media Data
    • 9.2.1.4 Read the Media Data from the BLOB
    • 9.2.1.5 Show the Properties of the Loaded Media Data
    • 9.2.1.6 Automate the ORDDoc Examples
    • 9.2.1.7 Clean Up the ORDDoc Examples
• 9.3 Image Data Examples
  • 9.3.1 Scripts for Populating an ORDImage Object from a File Data Source
    • 9.3.1.1 Create an Image Data Load Directory
    • 9.3.1.2 Create the image_table Table
    • 9.3.1.3 Load the Image Data
    • 9.3.1.4 Read the Image Data from the BLOB
    • 9.3.1.5 Show the Properties of the Loaded Image Data
    • 9.3.1.6 Automate the ORDImage Examples
    • 9.3.1.7 Clean Up the ORDImage Examples
  • 9.3.2 Script for Loading an Image Table from an HTTP Data Source
  • 9.3.3 Addressing Globalization Support Issues
• 9.4 Video Data Examples

A Oracle Multimedia Sample Applications

• A.1 Oracle Multimedia ORDImage OCI C Sample Application
• A.2 Oracle Multimedia PL/SQL Sample Applications
• A.3 Oracle Multimedia Java Sample Applications
• A.4 Other Oracle Multimedia Sample Applications

B Managing Oracle Multimedia Installations

• B.1 Oracle Multimedia Installed Users and Privileges
• B.2 Installing and Configuring Oracle Multimedia
  • B.2.1 Preinstallation Steps
  • B.2.2 Installation and Configuration Steps
• B.3 Verifying an Installed Version of Oracle Multimedia
• B.4 Upgrading an Installed Version of Oracle Multimedia
• B.5 Downgrading an Installed Version of Oracle Multimedia
• B.6 Removing Oracle Multimedia

Glossary

Index