Skip Headers
Oracle® interMedia User's Guide
10
g
Release 2 (10.2)
Part Number B14302-01
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
Send Us Your Comments
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes to This Guide
1
Introduction to Oracle
inter
Media
1.1
Object Relational Technology
1.2
inter
Media 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
Metadata Extraction
1.5.5
Image Processing
1.5.6
Content-Based Retrieval of Images
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
inter
Media Java Classes
1.9.2
Streaming Content from Oracle Database
1.9.3
Support for Web Technologies
1.9.4
inter
Media Custom DataSource and DataSink Classes for JMF 2.0/2.1
1.9.5
inter
Media Support for Java Advanced Imaging (JAI)
1.10
inter
Media Architecture
1.11
Extending Oracle
inter
Media
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
inter
Media 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
inter
Media 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
Media Upload and Retrieval Web Sample Applications
3.1
Oracle
inter
Media 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
Other Photo Album Sample Applications
3.2.1
Oracle
inter
Media Java Servlet Photo Album Sample Application
3.2.1.1
Running the Java Servlet Photo Album Application
3.2.1.2
Description of the
inter
Media Java Servlet Photo Album Application
3.2.2
Oracle
inter
Media JavaServer Pages (JSP) Photo Album Sample Application
3.2.2.1
Running the JSP Photo Album Application
3.2.2.2
Description of the
inter
Media JSP Photo Album Application
3.2.3
Oracle
inter
Media ASP/VBScript Photo Album Sample Application
3.2.3.1
Running the ASP/VBScript Photo Album Application
3.2.3.2
Description of the ASP/VBScript Photo Album Application
3.3
Oracle
inter
Media Code Wizard Sample Application
3.3.1
Using the Code Wizard
3.3.1.1
Creating a New DAD or Choosing an Existing DAD
3.3.1.2
Authorizing a DAD
3.3.1.3
Creating and Testing Media Upload and Retrieval Procedures
3.3.1.4
Creating a Media Upload Procedure
3.3.1.5
Creating a Media Retrieval Procedure
3.3.1.6
Using the PL/SQL Gateway Document Table
3.3.1.7
How Time Zone Information Is Used to Support Browser Caching
3.3.2
Sample Session Using Images
3.3.3
Sample Session Using Multiple Object Columns
3.3.4
Known Restrictions of the Oracle
inter
Media Code Wizard
4
IMExample Java Sample Application
4.1
Overview of the IMExample Application
4.2
Description of the IMExample Application
4.2.1
IMProductDialog Class
4.2.2
IMImagePanel Class
4.2.3
IMGetMetadataDialog Class
4.2.4
IMPutMetadataDialog Class
4.2.5
IMVideoPanel Class
4.2.6
IMAudioPanel Class
4.2.7
IMDocPanel Class
4.2.8
IMLoadFile Class
4.2.9
IMUtil Class
5
Working with Metadata in Images
5.1
Metadata Concepts
5.2
Oracle
inter
Media 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
inter
Media 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
5.8
Extracting and Mapping DICOM Metadata Attributes in Images
5.9
DICOM Image File Format
5.10
Oracle
inter
Media DICOM Image Metadata Example
5.10.1
Creating a Table for DICOM Metadata Storage
5.10.2
Extracting DICOM Image Metadata
5.11
DICOM References
6
Content-Based Retrieval Concepts
6.1
Overview and Benefits of Content-Based Retrieval
6.2
How Content-Based Retrieval Works
6.2.1
Color
6.2.2
Texture
6.2.3
Shape
6.3
How Matching Works
6.3.1
Weight
6.3.2
Score
6.3.3
Similarity Calculation
6.3.4
Threshold Value
6.4
Using an Index to Compare Signatures
6.5
Preparing or Selecting Images for Useful Matching
6.5.1
Image Matching Example 1
6.5.2
Image Matching Example 2
6.5.3
Image Matching Example 3
7
Extending Oracle
inter
Media
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
inter
Media 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
inter
Media 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
inter
Media 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
inter
Media to Support a New Video Data Format
7.2.4
Supporting Other Image Data Formats
7.3
Extending
inter
Media 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 the DBA
8.1
Setting Database Initialization Parameters
8.2
Issues to Consider in Creating Tables with Column Objects Containing BLOBs
8.2.1
Initializing Internal Column Objects Containing BLOBs to NULL or EMPTY
8.2.2
Specifying Tablespace and Storage Characteristics for Column Objects Containing BLOBs
8.2.3
Segment Attributes and Physical Attributes
8.3
Improving Multimedia Data INSERT Performance in Objects Containing LOBs
8.4
Transferring Multimedia Data Using Oracle Data Pump
8.5
Reading Data from an ORDVideo Object Using the readFromSource( ) Method in a PL/SQL Script
8.6
Getting the Best Performance Results
8.7
Improving Multimedia LOB Data Retrieval and Update Performance
9
Oracle
inter
Media 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
Sample Programs
A.1
Sample OCI C Program for Modifying Images or Testing Image Installation
A.1.1
Sample Program Installation Steps
A.1.2
Running the Program
A.2
Java Sample Applications
A.3
Additional PL/SQL Sample Packages
A.4
Additional ASP/VBScript Sample Application
A.5
Other Sample Programs
B
Installing and Upgrading Oracle
inter
Media
B.1
Installing Oracle
inter
Media
B.1.1
Installation Decisions
B.1.2
Preinstallation Steps
B.1.3
Installation Steps
B.2
Upgrading an Installed Version of Oracle
inter
Media
B.3
Verifying an Installed Version of Oracle
inter
Media
B.4
Downgrading an Installed Version of Oracle
inter
Media
Index