1/20
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 Multimedia 12
c
Release 1 (12.1)
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
1.6.5
Metadata Extraction
1.6.6
Image Processing
1.6.7
SQL/MM Still Image Standard Support
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
1.10.1
Oracle Multimedia Java API
1.10.2
Streaming Content from Oracle Database
1.10.3
Support for Web Technologies
1.10.4
Oracle Multimedia Support for Java Advanced Imaging (JAI)
1.11
Extending Oracle Multimedia
2
Oracle Multimedia Application Development
2.1
Overview of the Application Development Environment
2.1.1
Java Class Libraries and Other Packages and Interfaces
2.1.2
Integration With PL/SQL Gateway and PL/SQL Web Toolkit
2.1.3
Integration With Components in Other Oracle Development Tools
2.1.4
Integration With Third-Party Streaming Media Servers
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 in PL/SQL
2.2.5.2
Handling Image Processing for Unknown Image Formats in PL/SQL
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 in Java
2.4.4.2
Handling Image Processing for Unknown Image Formats in Java
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 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 1: Using Images
4.4
Sample Session 2: Using Multiple Object Columns
4.5
Known Restrictions of the Oracle Multimedia Code Wizard
5
Oracle Multimedia Java API Sample Application
5.1
Running the Oracle Multimedia Java API Sample Application
5.2
Description of the Oracle Multimedia Java API Sample Application
5.2.1
Operations in the IMProductDialog Class
5.2.2
Operations in the IMImagePanel Class
5.2.3
Operations in the IMGetMetadataDialog Class
5.2.4
Operations in the IMPutMetadataDialog Class
5.2.5
Operations in the IMVideoPanel Class
5.2.6
Operations in the IMAudioPanel Class
5.2.7
Operations in the IMDocPanel Class
5.2.8
Operations in the IMLoadFile Class
5.2.9
Operations in the IMUtil Class
6
Working with Metadata in Oracle Multimedia 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
Oracle Multimedia 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
SecureFiles LOBs and BasicFiles 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
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
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
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.