6
Running Oracle Data Option Demos

• Additional Documentation

• Oracle8i interMedia

• Oracle8i Time Series Demos

• Oracle8i Visual Information Retrieval

• Oracle8i Spatial

Additional Documentation

The following documents provide in-depth information about the Oracle options available in Oracle8i Release 2 (8.1.6):

• Oracle8i interMedia Audio, Image, and Video User's Guide and Reference

• Oracle8i interMedia Audio, Image, and Video Java Client User's Guide and Reference

• Using Oracle8i interMedia with the Web

• Oracle8i interMedia Locator User's Guide and Reference

• Oracle8i interMedia Text Reference

• Oracle8i ConText to interMedia Text Migration

• Oracle8i Visual Information Retrieval User's Guide

• Oracle8i Visual Information Retrieval Java Client User's Guide

• Oracle8i Time Series User's Guide

• Oracle8i Spatial User's Guide and Reference

Oracle8i interMedia

Oracle8i interMedia includes the following components:

• Text

• Audio, Video, and Image

• Locator

• Web Agent and Clipboard

Text

See Also: Oracle8i interMedia Text Reference, and Oracle8i ConText interMedia Text Migration.

There are no demos for Text in Oracle8i. However, interMedia Text now includes code samples. Point your browser at the following URL:

$ORACLE_HOME/ctx/sample/api/index.html

Audio, Video, and Image

See Also: Oracle8i interMedia Audio, Image, and Video User's Guide and Reference and Oracle8i interMedia Audio, Image, and Video Java Client User's Guide and Reference.

Oracle8i interMedia includes a number of scripts and sample programs in the following directories:

$ORACLE_HOME/ord/aud/demo/
$ORACLE_HOME/ord/img/demo/
$ORACLE_HOME/ord/vid/demo/

Sample Audio Scripts

The audio scripts consist of the following files:

• auddemo.sql - audio demonstration that shows features of the audio object including:
  • checking interMedia objects

  • creating a sample table with audio in it

  • inserting NULL rows into the audio table

  • checking the rows out

  • checking all the audio attributes directly

  • checking all the audio attributes by calling methods

  • installing your own format plug-in using the two files, fplugins.sql and fpluginb.sql described in the next two list items and in Oracle8i interMedia Audio, Image, and Video User's Guide and Reference on how to extend interMedia Audio to support a new audio data format

• fplugins.sql - demo format plug-in specification that you can use as a guideline to write any format plug-in you want to support.

• fpluginb.sql - demo format plug-in body that you can use as a guideline to write any format plug-in you want to support.

See the README.txt file in the $ORACLE_HOME/ord/aud/demo directory for requirements and instructions on running this SQL demo.

Sample Program for Modifying Images or Testing the Image Installation

Once you have installed Oracle8i interMedia Image, you can run the Oracle8i interMedia Image demonstration program. This program can also be used as a test to confirm successful installation.

This section contains the steps required to build and run the interMedia image demo.

The interMedia Image demo files are located in $ORACLE_HOME/ord/img/demo, where $ORACLE_HOME is the ORACLE_HOME directory.

Demonstration (Demo) Installation Steps

1. The Oracle8i interMedia Image demo uses the SCOTT/TIGER database user. If this user does not exist, you must create it:

   % svrmgrl     
   SVRMGRL> connect internal;     
   SVRMGRL> create user SCOTT identified by tiger;     
   SVRMGRL> grant connect,resource to SCOTT;
   
   

2. Create the image demo directory where $ORACLE_HOME is the
   $ORACLE_HOME directory.

   % svrmgrl     
   SVRMGRL> connect internal;    
   SVRMGRL> create or replace directory imgdemodir as `$ORACLE_HOME/ord/img/ 
   demo';
   
   

3. Grant privileges on the directory to PUBLIC:

   SVRMGRL> grant read on directory imgdemodir to public with grant option;
   
   

4. If needed, make the imgdemo program.

   % cd $ORACLE_HOME/ord/img/demo     
   % make -f demo_ordimg.mk imgdemo
   
   
   

Running the Demo

The imgdemo file is a sample program that shows how Oracle8i interMedia Image can be used from within a program. The demo is written in C and uses OCI (Oracle Call Interface) to access the database and exercise Oracle8i interMedia Image.

The program operates on imgdemo.dat, which is a bitmap (BMP) image in the demo directory. Optionally, you can supply an image file name on the command line, provided the file resides in the same directory as the demo. In either case, once the image has been manipulated by Oracle8i interMedia Image, the resulting image is written to the file imgdemo.out and can then be viewed with common rendering tools that you supply.

When the demo is run, it deletes and re-creates a table named IMGDEMOTAB in the SCOTT/TIGER schema of the default database. This table is used to hold the demo data. Once the table is created, a reference to the image file is inserted into the table. The data is then loaded into the table and converted to JFIF using the
processCopy( ) method of ORDImage.

The image properties are extracted within the database using the setProperties( ) method. An UPDATE command is issued after the setProperties( ) invocation. This is required because the setProperties( ) invocation has only updated a local copy of the type attributes.

Next, the Oracle8i interMedia Image process( ) method is used to cut and scale the image within the database. This is followed by an update that commits the change. The program cuts a portion of the image 100 pixels wide by 100 pixels high starting from pixel location (100,100). This sub-image is scaled to twice its original size and the resulting image is written to a file named imgdemo.out in the current directory.

Example 6-1 Execute the Demo from the Command Line

Execute the demo by typing imgdemo on the command line. Optionally, you can use a different image in the demo by first copying the file to the directory in which the demo resides and then specifying its file name on the command line as an argument to imgdemo.

Use the following command:

   $ imgdemo optional-image-filename

The demo displays a number of messages describing its progress, along with any errors encountered if something was not set up correctly. Expect to see the following messages:

Dropping table IMGDEMOTAB... 
Creating and populating table IMGDEMOTAB... 
Loading data into cartridge... 
Modifying image characteristics... 
Writing image to file imgdemo.out... 
Disconnecting from database... 
Logged off and detached from server. 
Demo completed successfully. 

If the program encounters any errors, it is likely that either Oracle8i interMedia software has not been installed correctly or the database has not been started. If the program completes successfully, the original image and the resultant image, which has undergone the cutting and scaling described earlier, can be viewed with common image rendering tools.

Sample Video Scripts

The Video scripts consist of the following files:

• viddemo.sql - video demo that shows features of the video object including:
  • checking interMedia objects

  • creating a sample table with video in it

  • inserting NULL rows into the video table

  • checking the rows out

  • checking all the video attributes directly

  • checking all the video attributes by calling methods

  • installing your own format plug-in using the two files, fplugins.sql and fpluginb.sql described in the next two list items and in Oracle8i interMedia Audio, Image, and Video User's Guide and Reference on how to extend interMedia Video to support a new video data format

• fplugins.sql - demo format plug-in specification that you can use as a guideline to write any format plug-in you want to support

• fpluginb.sql - demo format plug-in body that you can use as a guideline to write any format plug-in you want to support

See the README.txt file in the $ORACLE_HOME/ord/vid/demo directory for requirements and instructions on how to run this SQL demo.

Java Demo

A Java demo has been provided to help you learn to use both the audio and video client-side Java classes so you can build your own applications. In these two demos, the audio and video object is instantiated at the client side and a number of accessor methods are invoked. The audio Java demo files are located in the
ORACLE_HOME/ord/aud/demo directory and the video Java demo files are located in the $ORACLE_HOME/ord/vid/demo directory. See the README.txt file in each directory for requirements and instructions on how to run each respective Java demo.

MediaAnnotator

The MediaAnnotator program is not contained on the Oracle8i interMedia CD. It (along with other free Oracle software) can be found at the following URL:

http://www.oracle.com/products/free_software/

Locator

Oracle8i interMedia Locator includes a number of scripts that you can modify and run.

See Also: Oracle8i interMedia Locator User's Guide and Reference.

Sample Scripts

Sample Oracle8i interMedia Locator scripts are available in the following directory after you install this product:

$ORACLE_HOME/md/demo/geocoder

These scripts consist of the following files:

• geohttp.sql

  This file contains two parts. One part is for running a geocode function in interactive mode and the other is for running the geocode function in batch mode.

  • Interactive mode.

    See Example 1 in "GEOCODE1 Function (with lastline field)"in the Oracle8i interMedia Locator User's Guide and Reference for a listing of this part of the file.

  • Batch mode.

    You must update the setup tables in the nh_cs.sql file before you run the geohttp.sql in batch mode. See the Oracle8i interMedia Locator User's Guide and Reference for Example 2 in "GEOCODE1 Function (with lastline field)"or Example 3 in "GEOCODE1 Function (with lastline field)"for a listing of this part of the file.

• geoindex.sql

  This file contains:

  • A function named ESTIMATE_LEVEL to better estimate the index level for use with the spatial locator index for within-distance queries that use a radius distance greater than 100 miles. For a listing of this file, see the example in "ESTIMATE_LEVEL"in the Oracle8i interMedia Locator User's Guide and Reference.

  • A procedure statement named SETUP_LOCATOR_INDEX that builds a setup spatial locator index on the location column that contains the spatial information within the cust_table table where the spatial information is stored. For a listing of this file, see the example in
    "SETUP_LOCATOR_INDEX" in Oracle8i interMedia Locator User's Guide and Reference.

• geolocate.sql

  This file contains a routine that dynamically creates a geometry of interest and then queries against the NH_COMPUTER_STORES table to find out how many stores are within a 10-mile radius of the office. For a listing of this file, see Example 2 in "LOCATOR_WITHIN_DISTANCE" Oracle8i interMedia Locator User's Guide and Reference.

Web Agent and Clipboard

See Also: Using Oracle8i interMedia with the Web

For this release, two components of Oracle8i interMedia, the Clipboard and Web Agent, are not available on the Oracle8i media. You can download the components from the Oracle Technology Network web site:

http://technet.oracle.com

Choose products, then go to interMedia to find the interMedia free software downloads.

The documentation, which includes README files and the manual Using Oracle8i interMedia with the Web, is included in the download.

Oracle8i Time Series Demos

See Also: Oracle8i Time Series User's Guide

Table 6-1 shows the demos included with Oracle8i Time Series. This table includes a description of each demo and the default directory in which its files are installed.

The demo directory can be found at $ORACLE_HOME/ord/ts..

Table 6-1 Oracle8i Time Series Demos  

Description	Directory
Quick-start demo: quick and easy start using Oracle8i Time Series (See Chapter 1 in Oracle8i Time Series User's Guide.)	demo/tsquick
Usage demo for end users and product developers who want to use existing Oracle8i Time Series features (See Chapter 1 in Oracle8i Time Series User's Guide.)	demo/usage
Electric utility application demonstrating how to compute peak and off-peak summaries of 15-minute data	demo/usageutl
Java-based retrieval of time series data, using the prototype Oracle8i Time Series Java API and designed to run in a Web browser (See Chapter 1 in Oracle8i Time Series User's Guide.)	demo/applet
Simple Java code segments that perform time series operations and print the results (See Chapter 1 in Oracle8i Time Series User's Guide.)	demo/java
Demo showing the use of administrative tools procedures to "retrofit" existing time series detail tables; also, how to support time series queries for multiple qualifier columns in the time series detail table.	demo/retrofit
Advanced-developer demo for those who want to extend Oracle8i Time Series features	demo/extend
OCI demo showing how to call Oracle8i Time Series functions using the Oracle Call Interface	demo/oci
PRO*C/C++ demo showing how to call Oracle8i Time Series functions in applications created using the Oracle Pro*C/C++ Precompiler	demo/proc
Oracle Developer demo showing how to call Oracle8i Time Series functions in an Oracle Forms application	demo/dev2k

The README.txt file in the demo directory introduces the demos. Also, the directory for each demo contains a README.txt file with a more detailed description of that demo.

Oracle8i Visual Information Retrieval

See Also: Oracle8i Visual Information Retrieval User's Guide and Reference and Oracle8i Visual Information Retrieval Java Client User's Guide and Reference

A sample program is included with Visual Information Retrieval. The sample program demonstrates how to load two images into the database, generate their signatures, and then compare their signatures using a weighted similarity function.

This program uses two data files, virdemo1.dat and virdemo2.dat, as its input. No other input or parameters are required.

Environment

The following assumptions are made:

• Visual Information Retrieval has been installed and PUBLIC has EXECUTE privilege on it.

• The install script has been run. VIRDEMODIR directory has been created and granted PUBLIC READ access in order that the image data file can be read into the database.

• virdemo1.dat and virdemo2.dat are valid image files that reside in the VIRDEMODIR directory and the user has read/write access to the directory.

• User SCOTT has the default "TIGER" password. You may need to increase the tablespace allocated to SCOTT in order to successfully run this sample program.

Running the Sample Program

There are two ways to run the sample program: using the included sample images, or using your own images.

Example 6-2 runs the sample program using the included image files. The images are compared using equal attribute weights:

• Globalcolor = 1.0

• Localcolor = 1.0

• Texture = 1.0

• Structure = 1.0

Example 6-2 Run the Sample Program with Included Images

% virdemo
Image 1 and 2 have a similarity score of 0.0

Example 6-3 shows how to specify your own images on the command line. The images must reside in the $ORACLE_HOME/ord/vir/demo directory.

Example 6-3 Run the Sample Program with Your Own Images

% virdemo image1 image2 global_color local_color texture structure

You must specify all six parameters, the 2 file names and 4 attribute weights (ranging from 0.0 to 1.0) in this sample program. Note that when using the VIRScore( ) operator in your own applications, it is only necessary to provide at least one attribute weight.

The VIRDEMODIR directory provides several other sample image files to demonstrate the effects of emphasizing the different visual attributes. You can use an image viewer (such as xv) to display the images, and then compare them using the sample program, experimenting with different weights.

See Also: Appendix B in the Oracle8i Visual Information Retrieval User's Guide and Reference for more information.

Oracle8i Spatial

See Also: Oracle8i Spatial User's Guide and Reference

The reader should refer to $ORACLE_HOME/md/demo/readme.txt to find more information.