Skip Headers
Oracle® Multimedia User's Guide
11g Release 1 (11.1)
Part Number B28415-02
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New
Changes Since Release 10.2
New Features for Release 11.1
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 Classes
1.9.2
Streaming Content from Oracle Database
1.9.3
Support for Web Technologies
1.9.4
Oracle Multimedia Custom DataSource and DataSink Classes for JMF 2.0/2.1
1.9.5
Oracle Multimedia Support for Java Advanced Imaging (JAI)
1.10
Oracle Multimedia Architecture
1.11
Extending Oracle Multimedia
2
Application Development
2.1
Developing PL/SQL Client Applications Using the PL/SQL API
2.1.1
Setting Up Your Environment for PL/SQL
2.1.2
Media Query in PL/SQL
2.1.3
Media Download in PL/SQL
2.1.4
Media Upload in PL/SQL
2.1.5
Handling Oracle Multimedia Exceptions in PL/SQL
2.1.5.1
Handling the Setting of Properties for Unknown Image Formats
2.1.5.2
Handling Image Processing for Unknown Image Formats
2.2
Developing PL/SQL Web Applications
2.2.1
Using the PL/SQL Gateway and PL/SQL Web Toolkit
2.3
Developing Java Client Applications Using JDBC
2.3.1
Setting Up Your Environment for Java
2.3.2
Media Retrieval in Java
2.3.3
Media Upload in Java
2.3.4
Handling Oracle Multimedia Exceptions in Java
2.3.4.1
Handling the Setting of Properties for Unknown Image Formats
2.3.4.2
Handling Image Processing for Unknown Image Formats
2.4
Developing Java-Based Web Applications
2.4.1
Media Retrieval in Java-Based Web Applications
2.4.1.1
Media URL
2.4.1.2
Media Delivery Component
2.4.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
3.4
Oracle Multimedia ASP/VBScript Photo Album Sample Application
3.4.1
Running the ASP/VBScript Photo Album Application
3.4.2
Description of the ASP/VBScript Photo Album Application
4
Oracle Multimedia Code Wizard Sample Application
4.1
Using 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 IMExample Sample Application
5.1
Overview of the IMExample Application
5.2
Description of the IMExample 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
6.8
Extracting and Mapping DICOM Metadata Attributes in Images
6.9
DICOM Image File Format
6.10
Oracle Multimedia DICOM Image Metadata Example
6.10.1
Creating a Table for DICOM Metadata Storage
6.10.2
Extracting DICOM Image Metadata
6.11
DICOM 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 and Populate 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 and Populate 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 and Populate 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 Image OCI C Sample Application
A.2
Oracle Multimedia Java Sample Applications
A.3
Oracle Multimedia PL/SQL Sample Applications
A.4
Oracle Multimedia ASP/VBScript Sample Application
A.5
Other Oracle Multimedia Sample Applications
B
Managing Oracle Multimedia Installations
B.1
Installing Oracle Multimedia
B.1.1
Installation Decisions
B.1.2
Preinstallation Tasks
B.1.3
Installation Steps
B.2
Upgrading an Installed Version of Oracle Multimedia
B.3
Verifying an Installed Version of Oracle Multimedia
B.4
Downgrading an Installed Version of Oracle Multimedia
B.5
Removing Oracle Multimedia
Glossary
Index