1/18

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Multimedia User's Guide

• Changes in Oracle Database 12c Release 2 (12.2)

1 Introduction to Oracle Multimedia

• 1.1 Oracle Multimedia Architecture
• 1.2 Object Relational Technology
• 1.3 Oracle Multimedia Capabilities
  • 1.3.1 Oracle Multimedia Support for CDBs
  • 1.3.2 Data Guard Rolling Upgrade Support for Oracle Multimedia
• 1.4 Audio Concepts
  • 1.4.1 Digitized Audio
  • 1.4.2 Audio Components
• 1.5 ORDDoc or Heterogeneous Media Data Concepts
  • 1.5.1 Digitized Heterogeneous Media Data
  • 1.5.2 Heterogeneous Media Data Components
• 1.6 Image Concepts
  • 1.6.1 Digitized Images
  • 1.6.2 Image Components
  • 1.6.3 Metadata in Images
  • 1.6.4 Medical Imaging (Deprecated)
  • 1.6.5 Metadata Extraction
  • 1.6.6 Image Processing
• 1.7 Video Concepts
  • 1.7.1 Digitized Video
  • 1.7.2 Video Components
• 1.8 Loading Multimedia Data
• 1.9 Multimedia Storage and Querying
  • 1.9.1 Storing Multimedia Data
  • 1.9.2 Querying Multimedia Data
• 1.10 Accessing Multimedia Data

2 Oracle Multimedia Application Development

• 2.1 Developing Multimedia Applications Using SQL Developer
• 2.2 Developing Multimedia Applications Using Application Express
• 2.3 Developing Multimedia Applications Using Java and JDBC
  • 2.3.1 Setting Up Your Environment for Java
  • 2.3.2 Media Upload in Java
  • 2.3.3 Retrieval of Image Properties in Java
  • 2.3.4 Thumbnail Image Creation in Java
  • 2.3.5 Handling Oracle Multimedia Exceptions in Java
    • 2.3.5.1 Handling the Setting of Properties for Unknown Image Formats in Java
    • 2.3.5.2 Handling Image Processing for Unknown Image Formats in Java
• 2.4 Developing Multimedia Applications Using PL/SQL
  • 2.4.1 Setting Up Your Environment for PL/SQL
  • 2.4.2 Media Upload in PL/SQL
  • 2.4.3 Media Query in PL/SQL
  • 2.4.4 Media Download in PL/SQL
  • 2.4.5 Handling Oracle Multimedia Exceptions in PL/SQL
    • 2.4.5.1 Handling the Setting of Properties for Unknown Image Formats in PL/SQL
    • 2.4.5.2 Handling Image Processing for Unknown Image Formats in PL/SQL
• 2.5 Developing PL/SQL Web Applications
  • 2.5.1 Using the PL/SQL Gateway and PL/SQL Web Toolkit

3 Oracle Multimedia Photo Album Sample Application

• 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

4 Oracle Multimedia Code Wizard Sample Application for the PL/SQL Gateway

• 4.1 Running the Code Wizard Sample Application
• 4.2 Description of the Code Wizard Sample Application
  • 4.2.1 Creating a New DAD or Choosing an Existing DAD
  • 4.2.2 Authorizing a DAD
  • 4.2.3 Creating and Testing Media Upload and Retrieval Procedures
  • 4.2.4 Creating a Media Upload Procedure
  • 4.2.5 Creating a Media Retrieval Procedure
  • 4.2.6 Using the PL/SQL Gateway Document Table
  • 4.2.7 How Time Zone Information Is Used to Support Browser Caching
• 4.3 Sample Session: Using Images
• 4.4 Known Restrictions of the Oracle Multimedia Code Wizard

5 Working with Metadata in Oracle Multimedia Images

• 5.1 Metadata Concepts
• 5.2 Oracle Multimedia Image Metadata Concepts
• 5.3 Image File Formats
• 5.4 Image Metadata Formats
  • 5.4.1 EXIF
  • 5.4.2 IPTC–IIM
  • 5.4.3 XMP
• 5.5 Representing Metadata Outside Images
• 5.6 Oracle Multimedia Image Metadata Examples
  • 5.6.1 Creating a Table for Metadata Storage
  • 5.6.2 Extracting Image Metadata
  • 5.6.3 Embedding Image Metadata
• 5.7 Metadata References

6 Oracle Multimedia Tuning Tips for DBAs

• 6.1 Understanding the Performance Profile of Oracle Multimedia Operations
• 6.2 Choosing LOB Storage Parameters for Multimedia LOBs
  • 6.2.1 SecureFiles LOBs
  • 6.2.2 TABLESPACE
  • 6.2.3 CACHE, NOCACHE, and CACHE READS
  • 6.2.4 LOGGING and NOLOGGING
  • 6.2.5 Example of Setting LOB Storage Options
• 6.3 Setting Database Initialization Parameters

A Managing Oracle Multimedia Installations

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

B Extending Oracle Multimedia

• B.1 Supporting Other External Sources
  • B.1.1 Packages or PL/SQL Plug-ins
    • B.1.1.1 ORDPLUGINS.ORDX_FILE_SOURCE Package
    • B.1.1.2 ORDPLUGINS.ORDX_HTTP_SOURCE Package
    • B.1.1.3 Extending Oracle Multimedia to Support a New Data Source
• B.2 Supporting Other Media Data Formats
  • B.2.1 Supporting Other ORDAudio Data Formats
    • B.2.1.1 ORDPLUGINS.ORDX_DEFAULT_AUDIO Package
    • B.2.1.2 Extending Oracle Multimedia to Support a New Audio Data Format
  • B.2.2 Supporting Other ORDDoc Data Formats
    • B.2.2.1 ORDPLUGINS.ORDX_DEFAULT_DOC Package
    • B.2.2.2 Extending Oracle Multimedia to Support a New ORDDoc Data Format
  • B.2.3 Supporting Other Video Data Formats
    • B.2.3.1 ORDPLUGINS.ORDX_DEFAULT_VIDEO Package
    • B.2.3.2 Extending Oracle Multimedia to Support a New Video Data Format
  • B.2.4 Supporting Other Image Data Formats
• B.3 Supporting Media Data Processing
  • B.3.1 Supporting Audio Data Processing
  • B.3.2 Supporting Video Data Processing

C Oracle Multimedia Sample Applications

• C.1 Oracle Multimedia ORDImage OCI C Sample Application
• C.2 Oracle Multimedia PL/SQL Sample Applications

Glossary

Index