| Oracle® interMedia Reference 10g Release 2 (10.2) Part Number B14297-01 |
|
|
PDF · Mobi · ePub |
| Oracle® interMedia Reference 10g Release 2 (10.2) Part Number B14297-01 |
|
|
PDF · Mobi · ePub |
Oracle interMedia ("interMedia") contains the following information about object types that comply with the first edition of the ISO/IEC 13249-5:2001 SQL MM Part5:StillImage standard (commonly referred to as the SQL/MM Still Image standard):
Describes the average color feature of an image.
Encapsulates color values of a digitized image.
Describes the relative frequencies of the colors exhibited by samples of an image.
Describes an image that is represented by a composite feature. The composite feature is based on up to four basic image features (SI_AverageColor, SI_ColorHistogram, SI_PositionalColor, and SI_Texture) and their associated feature weights.
SI_PositionalColor Object Type
Describes the positional color feature of an image. Assuming that an image is divided into n by m rectangles, the positional color feature characterizes an image by the n by m most significant colors of the rectangles.
Represents digital images with inherent image characteristics such as height, width, format, and so on.
Describes the texture feature of the image characterized by the size of repeating items (coarseness), brightness variations (contrast), and predominant direction (directionality).
A public synonym with the corresponding object type name is created for each of these StillImage object types. Therefore, you do not need to specify the ORDSYS schema name when specifying a StillImage object type.
This chapter also includes the following topics:
Provides an overview of how the SQL functions and procedures are presented in this guide, as well as how they are created.
Example Media Table and User Definition
Presents the media table definition upon which the examples in this chapter are based. The examples in this chapter assume that the test media table SI_MEDIA has been created and filled with data.
Describes the views in the SI_INFORMTN_SCHEMA that you can query for information about the supported image formats and implementation-defined values.
Provides syntax for attributes that are VARRAY types.
See Oracle interMedia User's Guide for a list of ORDImage features that are not available for StillImage objects because the SQL/MM Still Image standard does not specify them.
For each Still Image constructor or method, there is an equivalent SQL function or procedure. Each function or procedure is presented with its equivalent constructor or method. Although the description, parameters, usage notes, and exceptions subsections frequently refer to the method, these subsections are also applicable to the equivalent SQL function or procedure.
All SQL functions and procedures are created as standalone functions in the ORDSYS schema with invoker rights. A public synonym with the corresponding function or procedure name is created for all SQL functions and procedures. Therefore, you do not need to specify the schema name when a function or procedure is called. For example:Use ORDSYS.SI_MkAvgClr(averageColor) to make the call without the synonym.Use SI_MkAvgClr(averageColor) to make the call with the synonym.All database users can call these functions and procedures.
The methods described in this reference chapter show examples based on a media table SI_MEDIA. Refer to the SI_MEDIA table definition that follows when reading through the examples. Before using methods, you will need to load some data into the table using one of the examples provided with the reference information for each object type's constructors. You will also need to verify that the user "ron" already exists or create that user if necessary.
SI_MEDIA Table Definition
CREATE TABLE PM.SI_MEDIA( PRODUCT_ID NUMBER(6), PRODUCT_PHOTO SI_StillImage, AVERAGE_COLOR SI_AverageColor, COLOR_HISTOGRAM SI_ColorHistogram, FEATURE_LIST SI_FeatureList, POSITIONAL_COLOR SI_PositionalColor, TEXTURE SI_Texture, CONSTRAINT id_pk PRIMARY KEY (PRODUCT_ID)); COMMIT;
PM.IMAGETAB Table Definition
Create this table in preparation for Example 2 for the SI_StillImage(content) method, which begins:
CREATE TABLE PM.IMAGETAB (id number, imgblob blob); COMMIT;
User Ron Definition
For a user "ron" to use the examples, the following statements must be issued before ron executes the examples, where "/mydir" is the directory where ron will find the audio, video, and image data:
GRANT INSERT, UPDATE, SELECT, DELETE on OE.ORDERS to ron;GRANT INSERT, UPDATE, SELECT, DELETE on PM.ONLINE_MEDIA to ron; GRANT EXECUTE on SYS.DBMS_LOB to ron; GRANT CREATE SESSION TO ron; CREATE OR REPLACE DIRECTORY FILE_DIR as '/mydir'; GRANT READ ON DIRECTORY FILE_DIR TO 'user';
The SI_AverageColor object type describes the average color feature of an image. It is created in the ORDSYS schema with invoker rights. It is declared as an INSTANTIABLE and NOT FINAL type.
Note:
Use the SI_AverageColor object type constructors and method rather than accessing attributes directly to protect yourself from changes to the internal representation of the SI_AverageColor object.The AverageColor object type is defined as follows:
CREATE OR REPLACE TYPE SI_AverageColor
AUTHID CURRENT_USER
AS OBJECT
(
-------------------
-- TYPE ATTRIBUTES
-------------------
SI_AverageColorSpec SI_Color,
---------------------
-- METHOD DECLARATION
---------------------
-- CONSTRUCTORS
--
CONSTRUCTOR FUNCTION SI_AverageColor
(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC,
CONSTRUCTOR FUNCTION SI_AverageColor
(SI_AverageColorSpec IN SI_Color)
return SELF AS RESULT DETERMINISTIC,
-- Methods associated with the source attribute
MEMBER FUNCTION SI_Score
(image in SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC
) INSTANTIABLE
NOT FINAL;
/
where:
SI_AverageColorSpec: the average color of the object.
This section describes the SI_AverageColor object constructors, which are the following:
SI_AverageColor(averageColorSpec IN SI_Color)
RETURN SELF AS RESULT DETERMINISTIC;
Format of Equivalent SQL Function
SI_MkAvgClr(avgClr IN SI_Color) RETURN SI_AverageColor DETERMINISTIC;
Constructs an SI_AverageColor object. The SI_AverageColorSpec attribute is initialized with the value of the specified color.
The color used to construct an SI_AverageColor object.
None.
None.
An error message is returned if one or more of the following conditions are true:
The value of the specified averageColorSpec is NULL.
The value of the specified averageColorSpec is not a valid SI_Color value.
Construct an SI_AverageColor object from a specified color using the SI_AverageColor(averageColorSpec) constructor:
DECLARE myColor SI_Color; myAvgColor SI_AverageColor; BEGIN myColor := NEW SI_COLOR(null, null, null); myColor.SI_RGBColor(10, 100, 200); myAvgColor := NEW SI_AverageColor(myColor); INSERT INTO PM.SI_MEDIA (product_id, average_color) VALUES (75, myAvgColor); COMMIT; END; /
Construct an SI_AverageColor object from a specified color using the SI_MkAvgClr( ) function:
DECLARE
myColor SI_Color;
myAvgColor SI_AverageColor;
BEGIN
myColor := NEW SI_COLOR(null, null, null);
myColor.SI_RGBColor(10, 100, 200);
myAvgColor := SI_MkAvgClr(myColor);
INSERT INTO PM.SI_MEDIA (product_id, average_color)
VALUES (89, myAvgColor);
COMMIT;
END;
/
SI_AverageColor(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC;
Format of Equivalent SQL Function
SI_FindAvgClr(sourceImage IN SI_StillImage) RETURN SI_AverageColor DETERMINISTIC;
Derives an SI_AverageColor value from the specified image. The image is divided into n samples. Then, each component (red, green, blue) of all the samples is added separately and divided by the number of samples. This gives the values of the components of the specified image. The process by which SI_AverageColor is determined can also be described by the following expression, where n is the number of samples:
Description of the illustration si_averagecolor.gif
The image from which the average color feature is extracted.
None.
None.
An error is returned if one or more of the following conditions are true:
The value of the specified image is NULL.
The value of sourceImage.SI_Content is NULL.
The average color feature is not supported for the format of the specified image. This is determined by looking up the SI_IMAGE_FORMAT_FEATURES view or SI_IMAGE_FRMT_FTRS view.
Derive an SI_AverageColor value using the SI_AverageColor(sourceImage) constructor:
DECLARE myimage SI_StillImage; myAvgColor SI_AverageColor; BEGIN SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=1; myAvgColor := NEW SI_AverageColor(myimage); END; /
Derive an SI_AverageColor object from an image using the SI_FindAvgClr( ) function:
DECLARE myimage SI_StillImage; myAvgColor SI_AverageColor; BEGIN SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=1; myAvgColor := SI_FindAvgClr(myimage); END; /
This section presents reference information on the SI_AverageColor method used for image matching:
SI_Score(image in SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_ScoreByAvgClr(feature IN SI_AverageColor, image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC;
Determines and returns the score of the specified image as compared to the SI_AverageColor object instance to which you apply the method. This method returns a DOUBLE PRECISION value between 0 and 100. A value of 0 indicates that the average color of the specified image and the SI_AverageColor object instance are identical. A value of 100 indicates that average color of the specified image and the SI_AverageColor object instance are completely different.
The image whose average color feature is compared with the SI_AverageColor object instance to which you apply this method.
An SI_AverageColor value.
This method returns a NULL value if any of the following is true:
The value of the SI_AverageColor to which the method is applied is NULL.
The value of the specified image is NULL.
The value of image.content_SI is NULL.
The SI_AverageColor feature is not supported for the specified image format.
None.
None.
Compare an image to an SI_AverageColor object and return the score using the SI_Score( ) method:
DECLARE
score DOUBLE PRECISION;
myimage SI_StillImage;
myotherimage SI_StillImage;
myAvgColor SI_AverageColor;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=1;
myAvgColor := NEW SI_AverageColor(myimage);
SELECT product_photo INTO myotherimage FROM PM.SI_MEDIA
WHERE product_id=2;
score := myAvgColor.SI_Score(myotherimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
Compare an image to an SI_AverageColor object and return the score using the SI_ScoreByAvgClr( ) function:
DECLARE
score DOUBLE PRECISION;
myimage SI_StillImage;
myotherimage SI_StillImage;
myAvgColor SI_AverageColor;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=1;
myAvgColor := NEW SI_AverageColor(myimage);
SELECT product_photo INTO myotherimage FROM PM.SI_MEDIA WHERE product_id=2;
score := SI_ScoreByAvgClr(myAvgColor, myotherimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
The SI_Color object type represents color values of a digitized image as an RGB color value. It is created in the ORDSYS schema with invoker rights. It is declared as an INSTANTIABLE and NOT FINAL type.
Note:
Use the SI_Color method rather than accessing attributes directly to protect yourself from changes to the internal representation of the SI_Color object.The SI_Color object is defined as follows:
CREATE OR REPLACE TYPE SI_Color AUTHID CURRENT_USER AS OBJECT ( ------------------- -- TYPE ATTRIBUTES ------------------- redValue INTEGER, greenValue INTEGER, blueValue INTEGER, --------------------- -- METHOD DECLARATION --------------------- MEMBER PROCEDURE SI_RGBColor (redValue IN INTEGER, greenValue IN INTEGER, blueValue IN INTEGER) ) INSTANTIABLE NOT FINAL;
where:
redValue: the integer value of the red component of the RGB color value.
greenValue: the integer value of the green component of the RGB color value.
blueValue: the integer value of the blue component of the RGB color value.
This section presents reference information on the SI_Color method used for constructing an SI_Color object using RGB color values:
SI_RGBColor(redValue IN INTEGER,
greenValue IN INTEGER,
blueValue IN INTEGER);
Format of Equivalent SQL Function
SI_MkRGBClr(redValue IN INTEGER,
greenValue IN INTEGER,
blueValue IN INTEGER)
RETURN SI_Color;
Constructs an SI_Color object in the RGB color space using the specified red, blue, and green values.
An integer value between 0 and 255.
An integer value between 0 and 255.
An integer value between 0 and 255.
You must call the system default constructor and specify NULL values, then call the SI_RGBColor method to set the RGB values. This two-step process is required because:
The SQL/MM standard does not specify an object constructor for this type, therefore, the need to use the system default constructor.
The default constructor does not perform any argument validation. By calling the SI_RGBColor method, specified values will be validated before assigning them to the color attributes.
An error is returned if any of the specified values is NULL or if any of the specified values is not between 0 and 255.
None.
None.
Construct an SI_Color value using the SI_RGBColor( ) method:
DECLARE myColor SI_Color; BEGIN myColor := NEW SI_COLOR(null, null, null); -- Set myColor to represent the color red: myColor.SI_RGBColor(255, 0, 0); END; /
Construct an SI_Color value using the SI_MkRGBClr ( ) function:
DECLARE myColor SI_Color; BEGIN myColor := NEW SI_COLOR(null, null, null); -- Set myColor to represent the color red: myColor := SI_MkRGBClr(255, 0, 0); END; /
The SI_ColorHistogram object represents the color histogram image feature. It describes the relative frequencies of the colors exhibited by samples of an image. It is created in the ORDSYS schema with invoker rights. It is declared as an INSTANTIABLE and NOT FINAL type. This object type is defined as follows. (See "Internal Helper Types" for the colorsList and colorFrequenciesList attribute syntax.)
Note:
Use the SI_ColorHistogram constructors and methods rather than accessing attributes directly to protect yourself from changes to the internal representation of the SI_ColorHistogram object.The SI_ColorHistogram object is defined as follows:
CREATE OR REPLACE TYPE SI_ColorHistogram
AUTHID CURRENT_USER
AS OBJECT
(
-------------------
-- TYPE ATTRIBUTES
-------------------
SI_ColorsList colorsList,
SI_FrequenciesList colorFrequenciesList,
---------------------
-- METHOD DECLARATION
---------------------
-- CONSTRUCTORS
CONSTRUCTOR FUNCTION SI_ColorHistogram
(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC,
CONSTRUCTOR FUNCTION SI_ColorHistogram
(firstColor IN SI_Color,
frequency IN DOUBLE PRECISION)
RETURN SELF AS RESULT DETERMINISTIC,
CONSTRUCTOR FUNCTION SI_ColorHistogram
(SI_ColorsList IN colorsList,
SI_FrequenciesList IN colorFrequenciesList)
RETURN SELF AS RESULT DETERMINISTIC,
MEMBER PROCEDURE SI_Append
(color IN SI_Color,
frequency IN DOUBLE PRECISION),
MEMBER FUNCTION SI_Score
(image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC
) INSTANTIABLE
NOT FINAL;
/
where:
SI_ColorsList: array of the SI_Color object type that represents the color values of the image.
SI_FrequenciesList: array of the colorFrequencies attribute that represents the color frequencies of the image. Its values range from 0 to 100. Each array element represents the frequency of the corresponding color in the SI_ColorsList array.
This section describes the SI_ColorHistogram object constructors, which are the following:
SI_ColorHistogram(SI_ColorsList IN colorsList,
SI_FrequenciesList IN colorFrequenciesList)
RETURN SELF AS RESULT DETERMINISTIC;
Constructs an SI_ColorHistogram object. The following attributes are initialized:
The SI_ColorsList array attribute is initialized with the value of the specified colors.
The SI_FrequenciesList array attribute is initialized with the value of the specified frequencies.
See "Internal Helper Types" for the SI_ColorsList and colorFrequenciesList attribute syntax.
None.
Format of Equivalent SQL Function
SI_ArrayClrHstgr(colors IN SI_ColorsList,
frequencies IN colorFrequenciesList),
RETURN SI_ColorHistogram DETERMINISTIC;
An array of colors with a maximum size of SI_MaxHistogramLength. Query the SI_VALUES view in SI_INFORMTN_SCHEMA for the value of SI_MaxHistogramLength.
An array of color frequencies with a maximum size of SI_MaxHistogramLength.
None.
An error is returned if any one of the following conditions is true:
Any one of the specified values is NULL.
Any one of the specified frequency values is less than 0 or greater than 100.
Construct an SI_ColorHistogram object using the SI_ColorHistogram(colors, frequencies) constructor:
DECLARE
myColors ordsys.colorsList;
myFreqs ordsys.colorFrequenciesList;
myColorHist SI_ColorHistogram;
BEGIN
--Create the varray objects colors and frequencies:
myColors := ordsys.colorsList();
myFreqs := ordsys.colorFrequenciesList();
--Create 100 empty elements in the varray:
myColors.extend(100);
myFreqs.extend(100);
--Add three colors to the varray:
myColors := ordsys.colorslist(SI_mkRGBClr(10, 20, 255),
SI_mkRGBClr(200,200,255),
SI_mkRGBClr(35,100,100));
--Add three frequencies to the varray:
myFreqs := ordsys.colorFrequenciesList(10, 1, 90);
--Construct the histogram using the colors and frequency varrays:
myColorHist := NEW SI_ColorHistogram(myColors, myFreqs);
END;
/
Construct an SI_ColorHistogram object using the SI_ArrayClrHstgr( ) function:
DECLARE
myColors ordsys.colorsList;
myFreqs ordsys.colorFrequenciesList;
myColorHist SI_ColorHistogram;
BEGIN
--Create the varray objects colors and frequencies:
myColors := ordsys.colorsList();
myFreqs := ordsys.colorFrequenciesList();
--Create 100 empty elements in the varray:
myColors.extend(100);
myFreqs.extend(100);
--Add three colors to the varray:
myColors := ordsys.colorslist(SI_mkRGBClr(10, 20, 255),
SI_mkRGBClr(200,200,255),
SI_mkRGBClr(35,100,100));
--Add three frequencies to the varray:
myFreqs := ordsys.colorFrequenciesList(10, 1, 90);
--Construct the histogram using the colors and frequency varrays:
myColorHist := SI_ArrayClrHstgr(myColors, myFreqs);
END;
/
SI_ColorHistogram(firstColor IN SI_Color,
frequency IN DOUBLE PRECISION)
RETURN SELF AS RESULT DETERMINISTIC;
Format of the Equivalent SQL Function
SI_MkClrHstgr(firstColor IN SI_Color, frequency IN DOUBLE PRECISION)
RETURN SI_ColorHistogram DETERMINISTIC;
Creates a single color/frequency pair in an SI_ColorHistogram object. The following attributes are initialized:
The SI_ColorsList array attribute is initialized with the value of the specified firstColor.
The SI_FrequenciesList array attribute is initialized with the value of the specified frequency.
A color value of SI_ColorHistogram.
The frequency value of SI_ColorHistogram for the firstColor parameter.
None.
None.
An error is returned if any of the following conditions is true:
Any one of the specified values is NULL.
The frequency specified is less than 0 or greater than 100.
Create a single color/frequency pair for an SI_ColorHistogram object using the SI_ColorHistogram(firstColor, frequency) constructor:
DECLARE myColor SI_Color; myClrHist SI_ColorHistogram; BEGIN -- Initialize myColor: myColor := new SI_Color(null, null, null); myColor.SI_RGBColor(10, 45, 200); -- Construct the histogram using myColor and a frequency of 10.0: myClrHist := new SI_ColorHistogram(myColor, 10.0); END; /
Construct a single color/frequency pair for an SI_ColorHistogram object using the SI_MkClrHstgr( ) function:
DECLARE myColor SI_Color; myClrHist SI_ColorHistogram; BEGIN -- Initialize myColor: myColor := new SI_Color(null, null, null); myColor.SI_RGBColor(10, 45, 200); -- Construct the histogram using myColor and a frequency of 10.0: myClrHist := SI_MkClrHstgr(myColor, 10.0); END; /
SI_ColorHistogram(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC;
Format of Equivalent SQL Function
SI_FindClrHstgr (sourceImage IN SI_StillImage)
RETURN SI_ColorHistogram DETERMINISTIC;
Extracts a color histogram from the specified image. The following attributes are initialized:
The SI_ColorsList attribute is initialized with the color values derived from the specified image.
The SI_FrequenciesList attribute is initialized with the frequencies derived from the specified image.
The image from which the color histogram is extracted.
None.
None.
An error is returned if any of the following conditions is true:
The value of the specified image is NULL.
The value of sourceImage.SI_Content is NULL.
The color histogram feature is not supported for this image format.
To determine whether or not the color histogram feature is supported for a given image format, query the SI_IMAGE_FORMAT_FEATURES view or SI_IMAGE_FRMT_FTRS view.
Extract an SI_ColorHistogram object from an image using the SI_ColorHistogram(sourceImage) constructor:
DECLARE myColorHist SI_ColorHistogram; myimage SI_StillImage; BEGIN -- Select a product_photo from the si_media table: SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=2 FOR UPDATE; -- Extract the color histogram from the source image: myColorHist := NEW SI_ColorHistogram(myimage); -- Update the color_histogram column with the extracted value: UPDATE PM.SI_MEDIA SET color_histogram = myColorHist WHERE product_id=2; COMMIT; END; /
Extract an SI_ColorHistogram object from an image using the SI_FindClrHstgr( ) function:
DECLARE myColorHist SI_ColorHistogram; myimage SI_StillImage; BEGIN SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=2 FOR UPDATE; myColorHist := SI_FindClrHstgr(myimage); UPDATE PM.SI_MEDIA SET color_histogram = myColorHist WHERE product_id=2; COMMIT; END; /
This section presents reference information on the SI_ColorHistogram methods used for color histogram construction and image matching, which are the following:
SI_Append(color IN SI_Color,
frequency IN DOUBLE PRECISION);
Format of Equivalent SQL Procedure
SI_AppendClrHstgr(feature IN OUT NOCOPY SI_ColorHistogram,
color IN SI_Color,
frequency IN DOUBLE PRECISION);
Extends a specified SI_ColorHistogram value by a color/frequency pair.
The color value to be added to the histogram.
The corresponding frequency value of the specified color that is to be added to the histogram.
The color histogram to which the color and frequency values are appended.
An error is returned if any one of the following conditions is true:
Any of the specified values is NULL.
The frequency is less than 0 or greater than 100.
The attribute SI_ColorsList already has SI_MaxHistogramLength elements.
None.
None.
Extend an SI_ColorHistogram value by a color/frequency pair using the SI_Append( ) method:
DECLARE myColor SI_Color; myClrHist SI_ColorHistogram; BEGIN -- Initialize myColor: myColor := new SI_Color(null, null, null); myColor.SI_RGBColor(10, 45, 200); -- Construct a histogram using a single color/frequency pair -- consisting of myColor and a frequency of 10.0: myClrHist := new SI_ColorHistogram(myColor, 10.0); -- Append myClrHist with another color/frequency pair: myColor.SI_RGBColor(60, 55, 100); myClrHist.SI_Append(myColor, 20.0); END; /
Extend an SI_ColorHistogram value by a color/frequency pair using the SI_AppendClrHstgr( ) procedure:
DECLARE myColor SI_Color; myClrHist SI_ColorHistogram; BEGIN -- Initialize myColor: myColor := new SI_Color(null, null, null); myColor.SI_RGBColor(10, 45, 200); -- Construct a histogram using a single color/frequency pair -- consisting of myColor and a frequency of 10.0: myClrHist := new SI_ColorHistogram(myColor, 10.0); -- Append myClrHist with another color/frequency pair: myColor.SI_RGBColor(60, 55, 100); SI_AppendClrHstgr(myClrHist, myColor, 20.0); END; /
SI_Score(image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_ScoreByClrHstgr(feature IN SI_ColorHistogram,
image IN SI_StillImage) RETURN DOUBLE PRECISION DETERMINISTIC;
Determines and returns the score of the color histogram of the specified image as compared to the SI_ColorHistogram object instance to which you apply this method. This method returns a DOUBLE PRECISION value between 0 and 100. A value of 0 means that the color histogram of the specified image and the SI_ColorHistogram object instance are identical. A value of 100 indicates that the color histogram of the specified image and the SI_ColorHistogram object instance are completely different. A NULL value is returned if any one of the following is true:
The value of the SI_ColorHistogram object instance is NULL.
The value of the specified image is NULL.
The value of image.SI_Content is NULL.
The value of the color histogram feature is not supported for the format of the specified image.
The image whose color histogram feature is extracted and used for comparison.
The histogram to be compared with the color histogram of the specified image.
None.
None.
None.
Compare a color histogram of an image to an SI_ColorHistogram value and return the score using the SI_Score method:
DECLARE
myClrHistConstructed SI_ColorHistogram;
myImage SI_StillImage;
myColor SI_Color;
score DOUBLE PRECISION;
BEGIN
-- Get a stored image:
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=2;
-- Initialize myColor
myColor := new SI_Color(null, null, null);
myColor.SI_RGBColor(10, 45, 200);
-- Construct a histogram using a single color/frequency pair
-- consisting of myColor and a frequency of 10.0:
myClrHistConstructed := new SI_ColorHistogram(myColor, 10.0);
-- Compare the color histogram of the stored image to myClrHistConstructed:
score := myClrHistConstructed.SI_Score(myImage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
Compare the color histogram of an image to an SI_ColorHistogram value and return the score using the SI_ScoreByClrHstgr( ) function:
DECLARE
myClrHistConstructed SI_ColorHistogram;
myImage SI_StillImage;
myColor SI_Color;
score DOUBLE PRECISION;
BEGIN
-- Get a stored image
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=2;
-- Initialize myColor:
myColor := new SI_Color(null, null, null);
myColor.SI_RGBColor(10, 45, 200);
-- Construct a histogram using a single color/frequency pair
-- consisting of myColor and a frequency of 10.0:
myClrHistConstructed := new SI_ColorHistogram(myColor, 10.0);
-- Compare the color histogram of the stored image to myClrHistConstructed:
score := SI_ScoreByClrHstgr(myClrHistConstructed, myImage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
A composite feature that contains up to four different basic features and their associated feature weights. A weight value specifies the importance given to a particular feature during image matching. Each weight value can have a value from 0.0 and 1.0. A feature weight value of 0.0 indicates that the feature is not considered for image matching. This object type is created in the ORDSYS schema with invoker rights. It is declared as an INSTANTIABLE and NOT FINAL type.
Note:
Use the SI_FeatureList constructor and methods rather than accessing attributes directly to protect yourself from changes to the internal representation of the SI_FeatureList object.The SI_FeatureList object type is defined as follows:
CREATE OR REPLACE TYPE SI_FeatureList
AUTHID CURRENT_USER
AS OBJECT
(
--attributes
AvgClrFtr_SI SI_AverageColor,
AvgClrFtrWght_SI DOUBLE PRECISION,
ClrHstgrFtr_SI SI_ColorHistogram,
ClrHstgrFtrWght_SI DOUBLE PRECISION,
PstnlClrFtr_SI SI_PositionalColor,
PstnlClrFtrWght_SI DOUBLE PRECISION,
TextureFtr_SI SI_Texture,
TextureFtrWght_SI DOUBLE PRECISION,
--
--
--Methods
CONSTRUCTOR FUNCTION SI_FeatureList
(AvgClrFtr_SI IN SI_AverageColor,
AvgClrFtrWght_SI IN DOUBLE PRECISION,
ClrHstgrFtr_SI IN SI_ColorHistogram,
ClrHstgrFtrWght_SI IN DOUBLE PRECISION,
PstnlClrFtr_SI IN SI_PositionalColor,
PstnlClrFtrWght_SI IN DOUBLE PRECISION,
TextureFtr_SI IN SI_Texture,
TextureFtrWght_SI IN DOUBLE PRECISION)
return SELF AS RESULT DETERMINISTIC,
--
--
MEMBER PROCEDURE SI_SetFeature
(averageColorFeature IN SI_AverageColor,
averageColorFeatureWeight IN DOUBLE PRECISION),
--
MEMBER PROCEDURE SI_SetFeature
(colorHistogramFeature IN SI_ColorHistogram,
colorHistogramFeatureWeight IN DOUBLE PRECISION),
--
MEMBER PROCEDURE SI_SetFeature
(positionalColorFeature IN SI_PositionalColor,
positionalColorFeatureWeight IN DOUBLE PRECISION),
--
MEMBER PROCEDURE SI_SetFeature
(textureFeature IN SI_Texture,
textureFeatureWeight IN DOUBLE PRECISION),
--
MEMBER FUNCTION SI_Score
(image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC,
--
MEMBER FUNCTION SI_AvgClrFtr( )
RETURN SI_AverageColor DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_AvgClrFtr, WNDS, WNPS, RNDS, RNPS),
--
MEMBER FUNCTION SI_AvgClrFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_AvgClrFtrWght, WNDS, WNPS, RNDS, RNPS),
--
MEMBER FUNCTION SI_ClrHstgrFtr( )
RETURN SI_ColorHistogram DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_ClrHstgrFtr, WNDS, WNPS, RNDS, RNPS),
--
MEMBER FUNCTION SI_ClrHstgrFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_ClrHstgrFtrWght, WNDS, WNPS, RNDS, RNPS),
--
MEMBER FUNCTION SI_PstnlClrFtr( )
RETURN SI_PositionalColor DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_PstnlClrFtr, WNDS, WNPS, RNDS, RNPS),
--
MEMBER FUNCTION SI_PstnlClrFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_PstnlClrFtrWght, WNDS, WNPS, RNDS, RNPS),
--
MEMBER FUNCTION SI_TextureFtr( )
RETURN SI_Texture DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_TextureFtr, WNDS, WNPS, RNDS, RNPS),
--
MEMBER FUNCTION SI_TextureFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_TextureFtrWght, WNDS, WNPS, RNDS, RNPS)
--
)
INSTANTIABLE
NOT FINAL;
/
where:
AvgClrFtr_SI: average color.
AvgClrFtrWght_SI: average color feature weight with a default value of 0.0.
ClrHstgrFtr_SI: color histogram.
ClrHstgrFtrWght_SI: color histogram weight with a default value of 0.0.
PstnlClrFtr_SI: positional color.
PstnlClrFtrWght_SI: positional color weight with a default value of 0.0.
TextureFtr_SI: texture.
TextureFtrWght_SI: texture weight with a default value of 0.0.
This section describes the SI_FeatureList constructor.
The SI_FeatureList constructor is as follows:
SI_FeatureList((AvgClrFtr_SI IN SI_AverageColor,
AvgClrFtrWght_SI IN DOUBLE PRECISION,
ClrHstgrFtr_SI IN SI_ColorHistogram,
ClrHstgrFtrWght_SI IN DOUBLE PRECISION,
PstnlClrFtr_SI IN SI_PositionalColor,
PstnlClrFtrWght_SI IN DOUBLE PRECISION,
TextureFtr_SI IN SI_Texture,
TextureFtrWght_SI IN DOUBLE PRECISION)
Format of Equivalent SQL Function
SI_MkFtrList(averageColorFeature IN SI_AverageColor,
averageColorFeatureWeight IN DOUBLE PRECISION,
colorHistogramFeature IN SI_ColorHistogram,
colorHistogramFeatureWeight IN DOUBLE PRECISION,
positionalColorFeature IN SI_PositionalColor,
positionalColorFeatureWeight IN DOUBLE PRECISION,
textureFeature IN SI_Texture,
textureFeatureWeight IN DOUBLE PRECISION)
RETURN SI_FeatureList;
Constructs an SI_FeatureList object. All the feature and feature weight attributes are set to the corresponding values of the input parameters.
The average color of SI_FeatureList.
The average color weight of SI_FeatureList. The default value is 0.0. The weight value can range from 0.0 to 1.0. A value of 0.0 indicates that the feature should not be considered during image matching.
The color histogram of SI_FeatureList.
The color histogram weight of SI_FeatureList. The default value is 0.0. The weight value can range from 0.0 to 1.0. A value of 0.0 indicates that the feature should not be considered during image matching.
The positional color of SI_FeatureList.
The positional color weight of SI_FeatureList. The default value is 0.0. The weight value can range from 0.0 to 1.0. A value of 0.0 indicates that the feature should not be considered during image matching.
The texture of SI_FeatureList.
The texture weight of SI_FeatureList. The default value is 0.0. The weight value can range from 0.0 to 1.0. A value of 0.0 indicates that the feature should not be considered during image matching.
None.
None.
An error is returned if any of the following conditions is true:
The AvgClrFtr_SI attribute is not a NULL value and the AvgClrFtrWght_SI attribute value is NULL or less than zero.
The ClrHstgrFtr_SI attribute is not a NULL value and the ClrHstgrFtrWght_SI attribute value is NULL or less than zero.
The PstnlClrFtr_SI attribute is not a NULL value and the PstnlClrFtrWght_SI attribute value is NULL or less than zero.
The TextureFtr_SI attribute is not a NULL value and the TextureFtrWght_SI attribute value is NULL or less than zero.
Create an SI_FeatureList object using the SI_FeatureList( ) constructor:
DECLARE
myimage SI_StillImage;
myAvgColor SI_AverageColor;
myColorHist SI_ColorHistogram;
myPosColor SI_PositionalColor;
myTexture SI_Texture;
myFeatureList SI_FeatureList;
BEGIN
SELECT product_photo INTO myimage FROM pm.si_media WHERE product_id=1 FOR
UPDATE;
myAvgColor := NEW SI_AverageColor(myimage);
myColorHist := NEW SI_ColorHistogram(myimage);
myPosColor := NEW SI_PositionalColor(myimage);
myTexture := NEW SI_Texture(myimage);
myFeatureList := new SI_FeatureList(myAvgColor,0.25,myColorHist,0.35,
myPosColor,0.10, myTexture,0.5);
UPDATE pm.si_media SET feature_list = myFeatureList WHERE product_id=1;
COMMIT;
END;
/
Create an SI_FeatureList object using the SI_MkFtrList( ) function:
DECLARE
myimage SI_StillImage;
myAvgColor SI_AverageColor;
myColorHist SI_ColorHistogram;
myPosColor SI_PositionalColor;
myTexture SI_Texture;
myFeatureList SI_FeatureList;
BEGIN
SELECT product_photo INTO myimage
FROM pm.si_media WHERE product_id=2 FOR
UPDATE;
myAvgColor := NEW SI_AverageColor(myimage);
myColorHist := NEW SI_ColorHistogram(myimage);
myPosColor := NEW SI_PositionalColor(myimage);
myTexture := NEW SI_Texture(myimage);
myFeatureList := SI_MkFtrList(myAvgColor,0.25,myColorHist,0.35,
myPosColor,0.10, myTexture,0.5);
UPDATE pm.si_media SET feature_list = myFeatureList WHERE product_id=2;
COMMIT;
END;
/
This section presents reference information on the SI_FeatureList methods used for image matching, which are the following:
SI_SetFeature(averageColorFeature, averageColorFeatureWeight)
SI_SetFeature(colorHistogramFeature, colorHistogramFeatureWeight)
SI_SetFeature(positionalColorFeature, positionalColorFeatureWeight)
SI_AvgClrFtr( )
RETURN SI_AverageColor DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetAvgClrFtr(featureList IN SI_FeatureList)
RETURN SI_AverageColor DETERMINISTIC;
Returns the value of the AvgClrFtr_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the AvgClrFtr_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_AvgClrFtr, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetAvgClrFtr, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the AvgClrFtr_SI attribute of an SI_FeatureList object using the SI_AvgClrFtr( ) method:
DECLARE
myFeatureList SI_FeatureList;
AvgColor SI_AverageColor;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
AvgColor := myFeatureList.SI_AvgClrFtr( );
END;
/
Get the AvgClrFtr_SI attribute of an SI_FeatureList object using the SI_GetAvgClrFtr( ) function:
DECLARE myFeatureList SI_FeatureList; AvgColor SI_AverageColor; BEGIN SELECT feature_list INTO myFeatureList FROM pm.si_media WHERE product_id=1; AvgColor := SI_GetAvgClrFtr(myFeatureList); END; /
SI_AvgClrFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetAvgClrFtrW(featureList IN SI_FeatureList)
RETURN DOUBLE PRECISION DETERMINISTIC;
Returns the value of the AvgClrFtrWght_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the AvgClrFtrWght_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_AvgClrFtrWght, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetAvgClrFtrW, WNDS, WNPS, RNDS, RNPS)
None.
Get the AvgClrFtrWght_SI attribute value of an SI_FeatureList object using the SI_AvgClrFtrWght( ) method:
DECLARE
myFeatureList SI_FeatureList;
AvgColorWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
AvgColorWght := myFeatureList.SI_AvgClrFtrWght( );
DBMS_OUTPUT.PUT_LINE('Average color feature weight is ' || AvgColorWght);
END;
/
Get the AvgClrFtrWght_SI attribute value of an SI_FeatureList object using the SI_GetAvgClrFtrW( ) function:
DECLARE
myFeatureList SI_FeatureList;
AvgColorWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
AvgColorWght := SI_GetAvgClrFtrW(myFeatureList);
DBMS_OUTPUT.PUT_LINE('Average color feature weight is ' || AvgColorWght);
END;
/
SI_ClrHstgrFtr( )
RETURN SI_ColorHistogram DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetClrHstgrFtr(featureList IN SI_FeatureList)
RETURN SI_ColorHistogram DETERMINISTIC;
Returns the value of the ClrHstgrFtr_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the ColorHistogram_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_ClrHstgrFtr, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetClrHstgrFtr, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the ClrHstgrFtr_SI attribute of an SI_FeatureList object using the SI_ClrHstgrFtr( ) method:
DECLARE
myFeatureList SI_FeatureList;
ClrHstgrFtr SI_ColorHistogram;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
ClrHstgrFtr := myFeatureList.SI_ClrHstgrFtr( );
END;
/
Get the value of the ClrHstgrFtr_SI attribute of an SI_FeatureList object using the SI_GetClrHstgrFtr( ) function:
DECLARE
myFeatureList SI_FeatureList;
ClrHstgrFtr SI_ColorHistogram;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
ClrHstgrFtr := SI_GetClrHstgrFtr(myFeatureList);
END;
/
SI_ClrHstgrFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetClrHstgrFtrW(featureList IN SI_FeatureList)
RETURN DOUBLE PRECISION DETERMINISTIC;
Returns the value of the ClrHstgrFtrWght_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the ClrHstgrFtrWght_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_ClrHstgrFtrWght, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetClrHstgrFtrW, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the ClrHstgrFtrWght_SI attribute of an SI_FeatureList object using the SI_ClrHstgrFtrWght( ) method:
DECLARE
myFeatureList SI_FeatureList;
ClrHstgrFtrWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
ClrHstgrFtrWght := myFeatureList.SI_ClrHstgrFtrWght( );
DBMS_OUTPUT.PUT_LINE('Color histogram feature weight is ' || ClrHstgrFtrWght);
END;
/
Get the value of the ClrHstgrFtrWght_SI attribute of an SI_FeatureList object using the SI_GetClrHstgrFtrW( ) function:
DECLARE
myFeatureList SI_FeatureList;
ClrHstgrFtrWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
ClrHstgrFtrWght := SI_GetClrHstgrFtrW(myFeatureList);
DBMS_OUTPUT.PUT_LINE('Color histogram feature weight is ' || ClrHstgrFtrWght);
END;
/
SI_PstnlClrFtr( )
RETURN SI_PositionalColor DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetPstnlClrFtr(featureList IN SI_FeatureList)
RETURN SI_PositionalColor DETERMINISTIC;
Returns the value of the PstnlClrFtr_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the PstnlClrFtr_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_PstnlClrFtr, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetPstnlClrFtr, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the PstnlClrFtr_SI attribute of an SI_FeatureList object using the SI_PstnlClrFtr( ) method:
DECLARE
myFeatureList SI_FeatureList;
PstnlClrFtr SI_PositionalColor;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
PstnlClrFtr := myFeatureList.SI_PstnlClrFtr( );
END;
/
Get the value of the PstnlClrFtr_SI attribute of an SI_FeatureList object using the SI_GetPstnlClrFtr( ) function:
DECLARE myFeatureList SI_FeatureList; PstnlClrFtr SI_PositionalColor; BEGIN SELECT feature_list INTO myFeatureList FROM pm.si_media WHERE product_id=1; PstnlClrFtr := SI_GetPstnlClrFtr(myFeatureList); END; /
SI_PstnlClrFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetPstnlClrFtrW(featureList IN SI_FeatureList)
RETURN DOUBLE PRECISION DETERMINISTIC;
Returns the value of the PstnlClrFtrWght_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the PstnlClrFtrWght_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_PstnlClrFtrWght, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetPstnlClrFtrW, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the PstnlClrFtrWght_SI attribute of an SI_FeatureList object using the SI_PstnlClrFtrWght( ) method:
DECLARE
myFeatureList SI_FeatureList;
PstnlClrFtrWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
PstnlClrFtrWght := myFeatureList.SI_PstnlClrFtrWght( );
DBMS_OUTPUT.PUT_LINE('Positional color feature weight is ' || PstnlClrFtrWght);
END;
/
Get the value of the PstnlClrFtrWght_SI attribute of an SI_FeatureList object using the SI_GetPstnlClrFtrW( ) function:
DECLARE
myFeatureList SI_FeatureList;
PstnlClrFtrWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
PstnlClrFtrWght := SI_GetPstnlClrFtrW(myFeatureList);
DBMS_OUTPUT.PUT_LINE('Positional color feature weight is ' || PstnlClrFtrWght);
END;
/
SI_Score(image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_ScoreByFtrList(featureList IN SI_FeatureList,
image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC;
Determines and returns the score of a specified image to a given SI_FeatureList value. The lower the returned score value, the better the image is characterized by the SI_FeatureList object used for scoring the image. The return score value is computed as follows:
Let n be the number of non-NULL feature attributes of the FeatureList object to which you are applying the method. For i ranging from 1 to n, let fi be the feature attribute and Wi be the value of the corresponding feature weight. The result is the sum of fi.SI_Score(image) * Wi divided by the sum of Wi. The process by which the score value is determined can also be described by the following expression:
Description of the illustration si_score_featurelist.gif
A DOUBLE PRECISION value between 0 and 100 is returned. A value of 0 means that the image is identical to the feature list object. A value of 100 means that the image is completely different from the feature list object.
The SI_FeatureList object to which the image will be compared.
The image whose features are extracted and compared with the specified SI_FeatureList object to get a score value.
This method returns a NULL value if any of the following conditions is true:
The feature list to which this method is applied is a NULL value.
The value of the specified image is NULL.
The values of AvgClrFtr_SI, ClrHstgrFtr_SI, PstnlClrFtr_SI, and TextureFtr_SI are all NULL.
The sum of all the feature weights, AvgClrFtrWght_SI, ClrHstgrFtrWght_SI, PstnlClrFtrWght_SI, and TextureFtrWght_SI is 0.
None.
None.
Compare an image to an SI_FeatureList value and return the score using the SI_Score( ) method:
DECLARE
myimage SI_StillImage;
myFeatureList SI_FeatureList;
score DOUBLE PRECISION;
BEGIN
--Check to see if stored feature list is accurate for the stored image:
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
SELECT product_photo INTO myimage FROM pm.si_media
WHERE product_id=1;
-- The score will be 0 if the feature list is accurate for the stored image:
score := myFeatureList.SI_Score(myimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
Compare an image to an SI_FeatureList value and return the score using the SI_ScoreByFtrList( ) function:
DECLARE
score DOUBLE PRECISION;
myimage SI_StillImage;
myFeatureList SI_PositionalColor;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
SELECT product_photo INTO myimage FROM pm.si_media
WHERE product_id=1;
score := SI_ScoreByFtrList(myFeatureList, myimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
SI_SetFeature(averageColorFeature IN SI_AverageColor,
averageColorFeatureWeight IN DOUBLE PRECISION);
Format of Equivalent SQL Procedure
SI_SetAvgClrFtr (featureList IN OUT NOCOPY SI_FeatureList,
averageColorFeature IN SI_AverageColor,
averageColorFeatureWeight IN DOUBLE PRECISION);
Modifies the SI_AvgClrFtr and SI_AvgClrFtrWght attributes in the specified SI_FeatureList object.
The new average color value.
The new average color weight.
The SI_FeatureList object for which you want to update the averageColorFeature and averageColorFeatureWeight values.
If the value of the averageColorFeature parameter is NULL, then the attribute AvgClrFtrWght_SI is set to zero and the value of the averageColorFeatureWeight parameter is disregarded.
An error is returned if the value of the averageColorFeature parameter is not a NULL value and the corresponding averageColorFeatureWeight parameter value is NULL or less than zero.
None.
None.
Modify the SI_AvgClrFtr and SI_AvgClrFtrWght attributes in an SI_FeatureList value using the SI_SetFeature(averageColorFeature, averageColorFeatureWeight) method:
DECLARE myColor SI_Color; myAvgColor SI_AverageColor; myFeatureLIst SI_FeatureList; BEGIN -- Create a new average color: myColor := NEW SI_COLOR(null, null, null); myColor.SI_RGBColor(30, 120, 200); myAvgColor := NEW SI_AverageColor(myColor); -- Get an existing feature list: SELECT feature_list INTO myFeatureList FROM pm.si_media WHERE product_id=1; -- Modify the average color and weight of the SI_FeatureList value: myFeatureList.SI_SetFeature(myAvgColor, 0.5); END; /
Modify the SI_AvgClrFtr and SI_AvgClrFtrWght attributes in an SI_FeatureList object using the SI_SetAvgClrFtr ( ) procedure:
DECLARE myColor SI_Color; myAvgColor SI_AverageColor; myFeatureLIst SI_FeatureList; BEGIN myColor := NEW SI_COLOR(null, null, null); myColor.SI_RGBColor(30, 120, 200); myAvgColor := NEW SI_AverageColor(myColor); SELECT feature_list INTO myFeatureList FROM pm.si_media WHERE product_id=1; SI_SetAvgClrFtr(myFeatureList, myAvgColor, 0.5); END; /
SI_SetFeature(colorHistogramFeature IN SI_ColorHistogram,
colorHistogramFeatureWeight IN DOUBLE PRECISION);
Format of Equivalent SQL Procedure
SI_SetClrHstgrFtr (featureList IN OUT NOCOPY SI_FeatureList,
colorHistogramFeature IN SI_ColorHistogram,
colorHistogramFeatureWeight IN DOUBLE PRECISION);
Modifies the ClrHstgrFtr_SI attribute and ClrHstgrFtrWght_SI attribute in the specified SI_FeatureList object.
The new color histogram value.
The new color histogram weight value.
The SI_FeatureList object for which you want to update the colorHistogram and colorHistogramFeatureWeight attribute values.
If the value of the colorHistogramFeature parameter is NULL, then the attribute ClrHstgrFtrWght_SI is set to zero and the value of the colorHistogramFeatureWeight parameter is disregarded.
An error is returned if the value of the colorHistogramFeature parameter is not a NULL value and the corresponding colorHistogramFeatureWeight parameter value is NULL or less than zero.
None.
None.
Modify the color histogram feature and feature weight of an SI_FeatureList object using the SI_SetFeature( ) method:
DECLARE myColor SI_Color; myClrHist SI_ColorHistogram; myFeatureList SI_FeatureList; BEGIN myColor := new SI_Color(null, null, null); myColor.SI_RGBColor(10, 45, 200); myClrHist := new SI_ColorHistogram(myColor, 10.0); SELECT feature_list INTO myFeatureList FROM pm.si_media WHERE product_id=1; myFeatureList.SI_SetFeature(myClrHist, 10.5); END; /
Modify the color histogram feature and feature weight of an SI_FeatureList object using the SI_SetClrHstgrFtr( ) procedure:
DECLARE
myColor SI_Color;
myClrHist SI_ColorHistogram;
myFeatureList SI_FeatureList;
BEGIN
myColor := new SI_Color(null, null, null);
myColor.SI_RGBColor(10, 45, 200);
myClrHist := new SI_ColorHistogram(myColor, 10.0);
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
SI_SetClrHstgrFtr(myFeatureList, myClrHist, 10.5);
END;
/
SI_SetFeature(positionalColorFeature IN SI_PositionalColor,
positionalColorFeatureWeight IN DOUBLE PRECISION);
Format of Equivalent SQL Procedure
SI_SetPstnlClrFtr(featureList IN OUT NOCOPY SI_FeatureList,
positionalColorFeature IN SI_PositionalColor,
positionalColorFeatureWeight IN DOUBLE PRECISION);
Modifies the PstnlClrFtr_SI and the PstnlClrFtrWght_SI attributes in the specified SI_FeatureList object.
The new positional color value.
The new positional color weight value.
The SI_FeatureList object for which you want to update the positionalColor and positionalColorFeatureWeight attributes.
If the value of the positionalColorFeature parameter is NULL, the attribute PstnlClrFtrWght_SI is set to zero and the value of the positionalColorFeatureWeight parameter is disregarded.
An error is returned if the value of the positionalColorFeature parameter is not NULL and the positionalColorFeatureWeight parameter value is NULL or less than zero.
None.
None.
Modify the positional color feature and feature weight of one image by updating it with the positional color feature value from another image using the SI_SetFeature( ) method and specifying a desired feature weight value:
DECLARE
PosColor2 SI_PositionalColor;
myFeatureList SI_FeatureList;
BEGIN
SELECT positional_color INTO PosColor2 FROM pm.si_media
WHERE product_id=2;
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
myFeatureList.SI_SetFeature(PosColor2, 10.5);
END;
/
Modify the positional color feature and feature weight of one image by updating it with the positional color feature value from another image using the SI_SetPstnlClrFtr( ) procedure and specifying a desired feature weight value:
DECLARE
PosColor1 SI_PositionalColor;
myFeatureList2 SI_FeatureList;
myFeatureListnew SI_FeatureList;
BEGIN
SELECT positional_color INTO PosColor1
FROM pm.si_media WHERE product_id=1;
SELECT feature_list INTO myFeatureList2
FROM pm.si_media WHERE product_id=2;
SI_SetPstnlClrFtr(myFeatureList2, PosColor1, 10.5);
END;
/
SI_SetFeature(textureFeature IN SI_Texture,
textureFeatureWeight IN DOUBLE PRECISION);
Format of Equivalent SQL Procedure
SI_SetTextureFtr(featureList IN OUT NOCOPY SI_FeatureList,
textureFeature IN SI_Texture,
textureFeatureWeight IN DOUBLE PRECISION);
Modifies the TextureFtr_SI attribute and TextureFtrWght_SI attribute in the specified SI_FeatureList object.
The new texture value.
The new texture weight value.
The SI_FeatureList object for which you want to update the textureFeature and textureFeatureWeight attributes.
If the value of the textureFeature parameter is a NULL value and the attribute TextureFtrWght_SI is set to zero, then the value of the textureFeatureWeight parameter is disregarded.
An error is returned if the value of the textureFeature parameter is NULL and the textureFeatureWeight parameter value is NULL or less than zero.
None.
None.
Modify the texture feature and feature weight of an SI_FeatureList value using the SI_SetFeature( ) method:
DECLARE
texture1 SI_Texture;
myFeatureList1 SI_FeatureList;
myFeatureList2 SI_FeatureList;
BEGIN
SELECT texture INTO texture1 FROM pm.si_media
WHERE product_id=1;
SELECT feature_list INTO myFeatureList1 FROM pm.si_media
WHERE product_id=2;
myFeatureList2.SI_SetFeature(texture1, 20);
END;/
Modify the texture feature and feature weight of an SI_FeatureList value using the SI_SetTextureFtr( ) procedure:
DECLARE
texture1 SI_Texture;
myFeatureList SI_FeatureList;
BEGIN
SELECT texture INTO texture1 FROM pm.si_media
WHERE product_id=1;
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=2;
SI_SetTextureFtr(myFeatureList, texture1, 20);
END;/
SI_TextureFtr( )
RETURN SI_Texture DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetTextureFtr (featureList IN SI_FeatureList)
RETURN SI_Texture DETERMINISTIC;
Returns the value of the TextureFtr_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the TextureFtr_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_TextureFtr, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetTextureFtr, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the TextureFtr_SI attribute of an SI_FeatureList object using the SI_TextureFtr( ) method:
DECLARE
myFeatureList SI_FeatureList;
mytexture SI_Texture;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
mytexture := myFeatureList.SI_TextureFtr( );
END;
/
Get the value of the TextureFtr_SI attribute of an SI_FeatureList object using the SI_GetTextureFtr ( ) function:
DECLARE myFeatureList SI_FeatureList; mytexture SI_Texture; BEGIN SELECT feature_list INTO myFeatureList FROM pm.si_media WHERE product_id=1; mytexture := SI_GetTextureFtr(myFeatureList); END; /
SI_TextureFtrWght( )
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetTextureFtrW(featureList in SI_FeatureList)
RETURN DOUBLE PRECISION DETERMINISTIC;
Returns the value of the TextureFtrWght_SI attribute of the specified SI_FeatureList object.
The SI_FeatureList object for which you want the TextureFtrWght_SI attribute returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_TextureFtrWght, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetTextureFtrW, WNDS, WNPS, RNDS, RNPS)
None.
Get the TextureFtrWght_SI attribute of an SI_FeatureList object using the SI_TextureFtrWght( ) method:
DECLARE
myFeatureList SI_FeatureList;
myTextureWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
myTextureWght := myFeatureList.SI_TextureFtrWght( );
DBMS_OUTPUT.PUT_LINE('Texture feature weight is ' || myTextureWght);
END;
/
Get the value of the TextureFtrWght_SI attribute of an SI_FeatureList object using the SI_GetTextureFtrW( ) function:
DECLARE
myFeatureList SI_FeatureList;
myTextureWght DOUBLE PRECISION;
BEGIN
SELECT feature_list INTO myFeatureList FROM pm.si_media
WHERE product_id=1;
myTextureWght := SI_GetTextureFtrW(myFeatureList);
DBMS_OUTPUT.PUT_LINE('Texture feature weight is ' || myTextureWght);
END;
/
The SI_PositionalColor object represents the most significant color positions of an image. If an image is divided into n by m rectangles, positional color is a feature that characterizes the image by the n by m most significant colors of the rectangles. This object type is created in the ORDSYS schema with invoker rights. It is declared as an INSTANTIABLE and NOT FINAL type. (See "Internal Helper Types" for the colorPositions attribute syntax.)
Note:
Use the SI_PositionalColor object constructor and method rather than accessing attributes directly to protect yourself from changes to the internal representation of the SI_PositionalColor object.The SI_PositionalColor object is defined as follows:
CREATE OR REPLACE TYPE SI_PositionalColor
AUTHID CURRENT_USER
AS OBJECT
(
--attributes
SI_ColorPositions colorPositions,
--
--Methods
CONSTRUCTOR FUNCTION SI_PositionalColor
(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC,
--
MEMBER FUNCTION SI_Score
(image IN SI_StillImage),
RETURN DOUBLE PRECISION DETERMINISTIC
) INSTANTIABLE
NOT FINAL;
/
where:
SI_ColorPositions: an array of SI_Color that represents the most significant color positions of an image.
This section describes the SI_PositionalColor object constructor, which is as follows:
SI_PositionalColor(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC;
Format of Equivalent SQL Function
SI_FindPstnlClr(sourceImage IN SI_StillImage)
RETURN SI_PositionalColor DETERMINISTIC;
Constructs an SI_PositionalColor object from a specified image. The SI_ColorPositions array attribute is initialized with the most significant color values derived from the specified image.
To derive the SI_PositionalColor object, the image is assumed to be divided into n by m rectangles such that the product of n by m is equal to the value of SI_NumberSections. (Query the SI_VALUES view in SI_INFORMTN_SCHEMA for the value of SI_NumberSections.) The most significant color of each rectangle is determined. The array thus computed is the value of the SI_ColorPositions array attribute.
Image whose positional color feature is extracted.
None.
None.
An error is returned if any of the following conditions is true:
The value of the sourceImage parameter is NULL.
The value of sourceImage.SI_Content is NULL.
The positional color feature is not supported for this image format.
You can determine whether or not the positional color feature is supported for an image format by querying the SI_IMAGE_FORMAT_FEATURES view or the SI_IMAGE_FRMT_FTRS view.
Create an SI_PositionalColor object from an image using the SI_PositionalColor( ) method:
DECLARE
myPosColor SI_PositionalColor;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id=1 FOR UPDATE;
myPosColor := NEW SI_PositionalColor(myimage);
UPDATE PM.SI_MEDIA SET positional_color = myPosColor WHERE product_id=1;
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id=2 FOR UPDATE;
myPosColor := NEW SI_PositionalColor(myimage);
UPDATE PM.SI_MEDIA SET positional_color = myPosColor WHERE product_id=2;
COMMIT;
END;
/
Create an SI_PositionalColor object from an image using the SI_FindPstnlClr( ) function:
DECLARE
myPosColor SI_PositionalColor;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id=2 FOR UPDATE;
UPDATE PM.SI_MEDIA SET positional_color = SI_FindPstnlClr(myimage)
WHERE product_id=2;
COMMIT;
END;
/
This section presents reference information on the SI_PositionalColor method used for image matching, which is as follows:
SI_Score(image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_ScoreByPstnlClr(feature IN SI_PositionalColor,
image IN SI_StillImage),
RETURN DOUBLE PRECISION DETERMINISTIC;
Determines and returns the score of the specified image when compared to the SI_PositionalColor object to which this method is applied. For scoring an image, that image is divided into n by m rectangles such that the product (m * n) is equal to SI_NumberSections. (Query the SI_VALUES view in SI_INFORMTN_SCHEMA for the value of SI_NumberSections.) The lower the returned value, the better the n by m most significant colors of the image are characterized by the most significant colors in SI_PositionalColor to which you apply this method.
This method returns a DOUBLE PRECISION value between 0 and 100, unless any one of the following is true, in which case a NULL value is returned:
The value of the SI_PositionalColor object to which you apply this method is NULL.
The value of the image parameter is NULL.
The value of image.content_SI attribute is NULL.
The positional color feature is not supported for the specified image.
The positional color to be compared with the positional color of the specified image.
The image whose positional color feature is extracted and used for comparison.
None.
None.
None.
Compare an image to an SI_PositionalColor object and return the score using the SI_Score( ) method:
DECLARE
score DOUBLE PRECISION;
myimage SI_StillImage;
myPosColor SI_PositionalColor;
BEGIN
SELECT positional_color INTO myPosColor FROM PM.SI_MEDIA
WHERE product_id=1;
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=2;
score := myPosColor.SI_Score(myimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
Compare an image to an SI_PositionalColor object and return the score using the SI_ScoreByPstnlClr( ) function:
DECLARE
score DOUBLE PRECISION;
myimage SI_StillImage;
myPosColor SI_PositionalColor;
BEGIN
SELECT positional_color INTO myPosColor FROM PM.SI_MEDIA
WHERE product_id=1;
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=2;
score := SI_ScoreByPstnlClr(myPosColor, myimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
The SI_StillImage object type represents digital images with inherent image characteristics such as height, width, format, and so on. It is created in the ORDSYS schema with invoker rights and it is declared as INSTANTIABLE and NOT FINAL.
Note:
Use the SI_StillImage constructors and methods rather than accessing attributes directly to protect yourself from changes to the internal representation of the SI_StillImage object.This object type is defined as follows:
CREATE OR REPLACE TYPE SI_StillImage
AUTHID CURRENT_USER
AS OBJECT
(
-------------------
-- TYPE ATTRIBUTES
-------------------
content_SI ORDSYS.ORDSOURCE,
contentLength_SI INTEGER,
format_SI VARCHAR2(4000),
height_SI INTEGER,
width_SI INTEGER,
-- Oracle attribute extensions
mimeType_ora VARCHAR2(4000),
contentFormat_ora VARCHAR2(4000),
compressionFormat_ora VARCHAR2(4000),
-- Flag to
retainFeatures_SI INTEGER,
-- Oracle extension attributes to cache image features
averageColorSpec_ora SI_Color,
colorsList_ora colorsList,
frequenciesList_ora colorFrequenciesList,
colorPositions_ora colorPositions,
textureEncoding_ora textureEncoding,
-- METHOD DECLARATION
---------------------
-- CONSTRUCTORS
--
CONSTRUCTOR FUNCTION
SI_StillImage(content IN BLOB) RETURN SELF as RESULT DETERMINISTIC,
CONSTRUCTOR FUNCTION
SI_StillImage(content IN BLOB,
explicitFormat IN VARCHAR2
) RETURN SELF AS RESULT DETERMINISTIC,
CONSTRUCTOR FUNCTION
SI_StillImage(content IN BLOB,
explicitFormat IN VARCHAR2,
height IN INTEGER,
width IN INTEGER) RETURN SELF as RESULT DETERMINISTIC,
-- Accessor methods for StillImage attributes
MEMBER FUNCTION SI_Height RETURN INTEGER DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_Height, WNDS, WNPS, RNDS, RNPS),
MEMBER FUNCTION SI_Width RETURN INTEGER DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_Width, WNDS, WNPS, RNDS, RNPS),
MEMBER FUNCTION SI_Format RETURN VARCHAR2 DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_Format, WNDS, WNPS, RNDS, RNPS),
MEMBER FUNCTION SI_Content RETURN BLOB DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_Content, WNDS, WNPS, RNDS, RNPS),
MEMBER FUNCTION SI_ContentLength RETURN INTEGER DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_ContentLength, WNDS, WNPS, RNDS, RNPS),
--Accessor method for retainFeatures_SI attribute
MEMBER FUNCTION SI_retainFeatures return BOOLEAN DETERMINISTIC,
PRAGMA RESTRICT_REFERENCES(SI_retainFeatures, WNDS, WNPS, RNDS, RNPS),
-- Methods associated with image processing
MEMBER PROCEDURE SI_SetContent(content IN BLOB),
MEMBER PROCEDURE SI_ChangeFormat(targetFormat IN VARCHAR2),
MEMBER FUNCTION SI_Thumbnail( )
return SI_StillImage DETERMINISTIC,
MEMBER FUNCTION SI_Thumbnail(height IN INTEGER,
width IN INTEGER)
return SI_StillImage DETERMINISTIC,
-- Methods associated with the Oracle extension for image feature caching
MEMBER PROCEDURE SI_InitFeatures,
MEMBER PROCEDURE SI_ClearFeatures
) INSTANTIABLE
NOT FINAL;
/
where:
content_SI: an ORDSource object that contains the binary image or BLOB. (SQL/MM specifies the SI_Content attribute as a BLOB.)
contentLength_SI: the content length of the image, in bytes.
format_SI: the image format.
height_SI: the number of lines of the image.
width_SI: the number of columns of the image.
mimeType_ora: the MIME type information. (This is an Oracle extension to the SQL/MM Still Image standard.)
contentFormat_ora: the type of image (monochrome and so on). (This is an Oracle extension to the SQL/MM Still Image standard.)
compressionFormat_ora: the compression algorithm used on the image data. (This is an Oracle extension to the SQL/MM Still Image standard.)
retainFeatures_SI: a flag that indicates whether or not image features will be extracted and cached.
averageColorSpec_ora: the cached SI_Color object.
colorsList_ora: the cached array of colors.
frequenciesList_ora: the cached array of color frequencies.
colorPositions_ora: the cached array of color positions.
textureEncoding_ora: the cached array of textures.
This section describes the SI_StillImage object constructors, which are the following:
SI_StillImage(content, explicitFormat, height, width)
This is an Oracle extension to the SQL/MM Still Image standard.
Note:
To construct SI_StillImage objects, Oracle strongly recommends that you use one of the constructors in the previous list, not the default SI_StillImage object constructor.SI_StillImage(content IN BLOB)
RETURN SELF as RESULT DETERMINISTIC;
Format of Equivalent SQL Function
SI_MkStillImage1(content in BLOB)
RETURN SI_StillImage DETERMINISTIC;
Returns a new SI_StillImage object. This constructor initializes the SI_StillImage attributes as follows:
content_SI.localData is initialized with the specified image.
contentLength_SI is initialized with the length of the image extracted from the specified image.
format_SI is initialized with the format of image extracted from the specified image.
height_SI is initialized with the height of image extracted from the specified image.
width_SI is initialized with the width of image extracted from the specified image.
The image data.
None.
ORDImageSIExceptions.NULL_CONTENT
This exception is raised if the content parameter is NULL.
See Appendix G for more information about this exception.
None.
The following examples demonstrate how to insert a StillImage object into a database table. The first two examples use the SI_StillImage(content) constructor; the third example uses the SI_MkStillImage1( ) function. In addition, the first and third examples use the PL/SQL package DBMS_LOB.LOADFROM FILE and the second example uses SQL*Loader. Typically, you would use the PL/SQL package if you were inserting objects one-by-one, and you would use SQL*Loader to insert objects in a batch job.
Example 1: Insert a BLOB into a StillImage object column using DBMS_LOB.LOADFROMFILE.
This example demonstrates how to insert an image into a StillImage object column using the PL/SQL package DBMS_LOB.LOADFROMFILE.
Connect as SYSDBA, create a BFILE to indicate where the image you want to load is located, and grant the READ privilege to the user who will be loading the image:
DECLARE
lobd blob;
fils BFILE := BFILENAME('FILE_DIR','speaker.jpg');
BEGIN
DBMS_LOB.CREATETEMPORARY(lobd, TRUE);
DBMS_LOB.fileopen(fils, DBMS_LOB.file_readonly);
DBMS_LOB.LOADFROMFILE(lobd, fils, DBMS_LOB.GETLENGTH(fils));
DBMS_LOB.FILECLOSE(fils);
INSERT INTO PM.SI_MEDIA (product_id, product_photo)
VALUES(1, new ORDSYS.SI_StillImage(lobd));
DBMS_LOB.FREETEMPORARY(lobd);
COMMIT;
END;
/
Example 2: Insert a BLOB into a StillImage object column using SQL*Loader.
This example demonstrates how to insert a StillImage object into a database table using SQL*Loader. This example assumes that the image file, speaker.jpg, is in the same directory as the parameter file and the control file.
From the command prompt, run SQL*Loader:
sqlldr parfile= blob_load.par
When the phrase 'commit point reached' is returned, connect to the database as user ron and issue a SQL COMMIT statement. (This example assumes that user ron has been created and granted privileges as shown in Example 1.)
sqlplus CONNECT ron/ron
Run the SQL script to insert the SI_StillImage object in the SI_MEDIA table:
@insert_object.sql
This example assumes that the blob_load.par, blob_load.ctl, and insert_object.sql files have been defined as follow and that the PM.IMAGETAB table has been created as shown in Example Media Table and User Definition.
blob_load.par:
userid=ron/ron control=/homedir/user3/blob_load.ctl log=/homedir/user3/blob_load.log
blob_load.ctl:
LOAD DATA INFILE * INTO TABLE PM.IMAGETAB REPLACE FIELDS TERMINATED BY ',' (id , imgblob_fname FILLER CHAR(20), imgblob LOBFILE(imgblob_fname) raw terminated by EOF) BEGINDATA 1,speakers.jpg
insert_object.sql:
DECLARE myblob BLOB; myid NUMBER; BEGIN SELECT id, imgblob into myid, myblob FROM PM.IMAGETAB WHERE id = 2; INSERT INTO PM.SI_MEDIA (product_id, product_photo) VALUES(myid, new ordsys.SI_StillImage(myblob)); COMMIT; END; /
Example 3: Create a new SI_StillImage object using the SI_MkStillImage1( ) function and the PL/SQL package DBMS_LOB.LOADFROM FILE:
DECLARE
lobd blob;
fils BFILE := BFILENAME('FILE_DIR','modem.jpg');
BEGIN
DBMS_LOB.CREATETEMPORARY(lobd, TRUE);
DBMS_LOB.FILEOPEN(fils, dbms_lob.file_readonly);
DBMS_LOB.LOADFROMFILE(lobd, fils, dbms_lob.getlength(fils));
DBMS_LOB.FILECLOSE(fils);
INSERT INTO PM.SI_MEDIA (product_id, product_photo)
VALUES (66, SI_MkStillImage1(lobd));
DBMS_LOB.FREETEMPORARY(lobd);
COMMIT;
END;
/
SI_StillImage(content IN BLOB,
explicitFormat IN VARCHAR2)
RETURN SELF as RESULT DETERMINISTIC;
Format of Equivalent SQL Function
SI_MkStillImage2(content in BLOB, explicitFormat in VARCHAR2)
RETURN SI_StillImage DETERMINISTIC;
Constructs an SI_StillImage object from a specified image and a format. This constructor lets you specify the image format when the specified image is in an unsupported image format. Query the SI_IMAGE_FORMATS view in SI_INFORMTN_SCHEMA for a list of the supported image formats.
This constructor initializes the SI_StillImage attributes as follows:
content_SI.localData is initialized with the specified image.
contentLength_SI is initialized with the length of the image extracted from the specified image.
format_SI is initialized with the specified image format.
height_SI is initialized with the height of the image extracted from the specified image. If the constructor function is not able to extract the height value from the specified image, then you can assign a height value to the height_SI attribute -- for example: myImage.height_SI := height.
width_SI is initialized with the width of the image extracted from the specified image. If the constructor function is not able to extract the width value from the specified image, then you can assign a width value to the width_SI attribute -- for example: myImage.width_SI := width.
The image data.
The format that you want interMedia to use if the specified image is in an unsupported image format.
None.
ORDImageSIExceptions.NULL_CONTENT
This exception is raised if the content parameter is NULL.
See Appendix G for more information about this exception.
An error is returned if the explicitFormat parameter is a NULL value, or if either of the following statements is true:
The explicitFormat parameter value is a supported format, but it is not equivalent to the format extracted from the specified image.
The explicitFormat parameter value is an unsupported format, but the format extracted from the specified image is not a NULL value.
The following table presents values for the explicitFormat parameter and the actual image format, and whether or not that combination of values will result in an error. A image format of NULL indicates that the format cannot be extracted from the image.
| explicitFormat | Image Format | Error Returned? |
|---|---|---|
| GIF (a supported format) | GIF | No |
| GIF (a supported format) | JPEG | Yes |
| xyz (an unsupported format) | GIF | Yes |
| xyz (an unsupported format) | Null | No |
Create an SI_StillImage object from a specified image and format using the SI_StillImage(content, explicitFormat) constructor:
DECLARE
lobd BLOB;
fils BFILE := BFILENAME('FILE_DIR','window.psp');
newimage SI_StillImage;
height NUMBER;
width NUMBER;
myimage SI_StillImage;
BEGIN
-- Put the blob in a temporary LOB:
DBMS_LOB.CREATETEMPORARY(lobd, TRUE);
DBMS_LOB.FILEOPEN(fils, DBMS_LOB.FILE_READONLY);
DBMS_LOB.LOADFROMFILE(lobd, fils, DBMS_LOB.GETLENGTH(fils));
DBMS_LOB.FILECLOSE(fils);
-- Create a new SI_StillImage object for this image (which has an
-- unsupported format):
newimage := NEW SI_StillImage(lobd, 'psp');
-- If the stored height and width values are NULL, the following will set
-- them appropriately. Alternatively, you could use the
-- SI_StillImage(content, explicitFormat, height,width) constructor:
height := 570;
width := 1168;
IF (newimage.SI_Height is NULL) THEN
newimage.height_SI := height;
END IF;
IF (newimage.SI_Width is NULL) THEN
newimage.width_SI := width;
END IF;
-- Insert the image into the si_media table, then free the temporary LOB:
INSERT INTO PM.SI_MEDIA (product_id, product_photo) VALUES (3, newimage);
DBMS_LOB.FREETEMPORARY(lobd);
-- Make sure that the height and width were stored as expected:
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=3;
height := myimage.SI_height;
width := myimage.SI_width;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
COMMIT;
END;
/
Create a new SI_StillImage object from a specified image and format using the SI_MkStillImage2( ) function:
DECLARE
lobd BLOB;
fils BFILE := BFILENAME('FILE_DIR','window.psp');
newimage SI_StillImage;
height NUMBER;
width NUMBER;
myimage SI_StillImage;
BEGIN
-- Put the blob in a temporary LOB:
DBMS_LOB.CREATETEMPORARY(lobd, TRUE);
DBMS_LOB.FILEOPEN(fils, DBMS_LOB.FILE_READONLY);
DBMS_LOB.LOADFROMFILE(lobd, fils, DBMS_LOB.GETLENGTH(fils));
DBMS_LOB.FILECLOSE(fils);
-- Create a new SI_StillImage object for this image (which has an
-- unsupported format):
newimage := SI_MkStillImage2(lobd, 'psp');
-- If the stored height and width values are NULL, the following will set
-- them appropriately:
height := 570;
width := 1168;
IF (SI_GetHeight(newimage) is NULL) THEN
newimage.height_SI := height;
END IF;
IF (SI_GetWidth(newimage) is NULL) THEN
newimage.width_SI := width;
END IF;
-- Insert the image into the si_media table, then free the temporary LOB:
INSERT INTO PM.SI_MEDIA (product_id, product_photo) VALUES (77, newimage);
DBMS_LOB.FREETEMPORARY(lobd);
-- Make sure that the height and width were stored as expected:
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=77;
height := myimage.SI_height;
width := myimage.SI_width;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
COMMIT;
END;
/
SI_StillImage(content IN BLOB,
explicitFormat IN VARCHAR2,
height IN INTEGER,
width IN INTEGER)
RETURN SI_STILLIMAGE as RESULT DETERMINISTIC;
Format of Equivalent SQL Function
ora_SI_MkStillImage(content IN BLOB)
explicitFormat IN VARCHAR2,
height IN INTEGER,
width IN INTEGER)
RETURN SI_StillImage DETERMINISTIC;
Constructs an SI_StillImage value from a specified image. This constructor lets you specify the image format, height, and width when the specified image is an unsupported image format. Query the SI_IMAGE_FORMATS view in SI_INFORMTN_SCHEMA for a list of the supported image formats.
This constructor and its equivalent SQL function are Oracle extensions to the SQL/MM Still Image standard.
This constructor initializes the SI_StillImage attributes as follows:
content_SI.localData is initialized with the specified image.
contentLength_SI is initialized with the length of the image extracted from the specified image.
format_SI is initialized with the specified format.
height_SI is initialized with the specified height if the height cannot be extracted from the specified image.
width_SI is initialized with the specified width if the width cannot be extracted from the specified image.
The image data.
The format that you want interMedia to use if the image is in an unsupported format.
The value for the height_SI attribute that you want interMedia to use if the image is in an unsupported format.
The value for the width_SI attribute that you want interMedia to use if the image is in an unsupported format.
None.
ORDImageSIExceptions.ILLEGAL_HEIGHT_WIDTH_SPEC
This exception is raised if the value of the height or width parameter is NULL or is a negative value.
ORDImageSIExceptions.NULL_CONTENT
This exception is raised if the content parameter is NULL.
See Appendix G for more information about these exceptions.
An error message is returned if the explicitFormat parameter value is a NULL value, or if either of the following statements is true:
The explicitFormat parameter value is a supported format, but it is not equivalent to the format extracted from the image.
The explicitFormat parameter value is an unsupported format, but the format extracted from the image is not a NULL value.
The following table presents values for the explicitFormat parameter and the actual image format, and whether or not that combination of values will result in an error. An image format of NULL indicates that the format cannot be extracted from the image.
| explicitFormat | Image Format | Error Returned? |
|---|---|---|
| GIF (a supported format) | GIF | No |
| GIF (a supported format) | JPEG | Yes |
| xyz (an unsupported format) | GIF | Yes |
| xyz (an unsupported format) | Null | No |
Construct an SI_StillImage value from an image using the SI_StillImage(content, explicitFormat, height, width) constructor:
DECLARE
lobd BLOB;
fils BFILE := BFILENAME('FILE_DIR','window.psp');
newimage SI_StillImage;
height NUMBER;
width NUMBER;
myimage SI_StillImage;
BEGIN
-- Put the blob in a temporary LOB:
DBMS_LOB.CREATETEMPORARY(lobd, TRUE);
DBMS_LOB.FILEOPEN(fils, DBMS_LOB.FILE_READONLY);
DBMS_LOB.LOADFROMFILE(lobd, fils, DBMS_LOB.GETLENGTH(fils));
DBMS_LOB.FILECLOSE(fils);
-- Create a new SI_StillImage object for this image (which has an
-- unsupported format):
newimage := NEW SI_StillImage(lobd, 'psp', 570, 1168);
-- Insert the image into the si_media table, then free the temporary LOB:
INSERT INTO PM.SI_MEDIA (product_id, product_photo) VALUES (4, newimage);
DBMS_LOB.FREETEMPORARY(lobd);
-- Make sure that the height and width were stored as expected:
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=4;
height := myimage.SI_height;
width := myimage.SI_width;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
COMMIT;
END;
/
Construct an SI_StillImage value from an image using the ora_SI_StillImage(content, explicitFormat, height, width) function:
DECLARE
lobd BLOB;
fils BFILE := BFILENAME('FILE_DIR','window.psp');
newimage SI_StillImage;
height NUMBER;
width NUMBER;
myimage SI_StillImage;
BEGIN
-- Put the blob in a temporary LOB:
DBMS_LOB.CREATETEMPORARY(lobd, TRUE);
DBMS_LOB.FILEOPEN(fils, DBMS_LOB.FILE_READONLY);
DBMS_LOB.LOADFROMFILE(lobd, fils, DBMS_LOB.GETLENGTH(fils));
DBMS_LOB.FILECLOSE(fils);
-- Create a new SI_StillImage object for this image (which has an
-- unsupported format):
newimage := ora_SI_StillImage(lobd, 'psp', 570, 1168);
-- Insert the image into the si_media table, then free the temporary LOB:
INSERT INTO PM.SI_MEDIA (product_id, product_photo) VALUES (6, newimage);
DBMS_LOB.FREETEMPORARY(lobd);
-- Make sure that the height and width were stored as expected:
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id=6;
height := myimage.SI_height;
width := myimage.SI_width;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
COMMIT;
END;
/
This section presents reference information on the SI_StillImage methods used for image data manipulation, which are the following:
SI_ClearFeatures( );
Disables image feature caching and sets the value of all internal image feature attributes to NULL. You can call this method to remove the processing overhead associated with feature synchronization if you are not performing image matching. This method does nothing for unsupported image formats.
This method is not in the first edition of the SQL/MM Still Image standard, but has been accepted for inclusion in the next version.
None.
None.
None
None.
Disable image feature caching and set the value of all internal image feature attributes for a specified image to NULL:
DECLARE
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
UPDATE PM.SI_MEDIA
SET product_photo = myimage where product_id=1;
myimage.SI_ClearFeatures;
DBMS_OUTPUT.PUT_LINE('Image feature caching diasbled');
COMMIT;
END;
/
SI_InitFeatures( );
Extracts the image features and caches them in the SI_StillImage object. This method needs to be called once, after which SI_StillImage will manage the image features such that every time the image is processed, new image features will automatically be extracted. This method is recommended for image-matching users.
This method is not in the first edition of the SQL/MM Still Image standard, but has been accepted for inclusion in the next version.
None.
The performance impacts associated with image feature caching are:
Image processing methods such as SI_SetContent and SI_ChangeFormat will be slower.
Image matching methods such as SI_Score will be faster.
Image feature extraction and caching are not available for unsupported image formats.
None.
ORDImageSIExceptions.UNSUPPORTED_IMAGE_FORMAT
This exception is raised if this method is invoked on an unsupported image format.
See Appendix G for more information about this exception.
Extract the image features and cache them in an SI_StillImage object:
DECLARE
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 1 FOR UPDATE;
myimage.SI_InitFeatures;
UPDATE PM.SI_MEDIA
SET product_photo = myimage where product_id=1;
DBMS_OUTPUT.PUT_LINE('Image feature caching enabled');
COMMIT;
END;
/
SI_ChangeFormat(targetFormat IN VARCHAR2);
Format of Equivalent SQL Procedure
SI_ConvertFormat(image IN OUT NOCOPY SI_StillImage,
targetFormat IN VARCHAR2);
Converts the format of an SI_StillImage object and adjusts the affected attributes as follows:
content_SI is converted to the value specified with the targetFormat parameter.
contentLength_SI is updated with the new image length extracted from the content_SI attribute.
format_SI is set equal to the targetFormat parameter value.
height_SI is updated with the new height extracted from the content_SI attribute.
width_SI is updated with the new width extracted from the content_SI attribute.
The image whose content you want to convert.
The format to which you want the image to be converted.
An error message is returned if any of the following is true:
The value of the format_SI attribute is NULL.
The value of the targetFormat parameter is NULL.
The conversion from format_SI to targetFormat is not supported. (Oracle interMedia determines this by looking up the values in the SI_IMAGE_FORMAT_CONVERSIONS view or the SI_FORMAT_CONVRSNS view in SI_INFORMTN_SCHEMA.)
None.
None.
Convert the format of an SI_StillImage object to WBMP using the SI_ChangeFormat( ) method:
DECLARE
origformat VARCHAR2 (10);
newformat VARCHAR2 (10);
myimage SI_StillImage;
currentformat VARCHAR2 (10);
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 1 FOR UPDATE;
origformat := myimage.SI_Format;
DBMS_OUTPUT.PUT_LINE('Original format is ' || origformat);
newformat := 'WBMP';
myimage.SI_ChangeFormat(newformat);
INSERT INTO PM.SI_MEDIA (product_id, product_photo) VALUES (44, myimage);
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 44;
currentformat := myimage.SI_Format;
DBMS_OUTPUT.PUT_LINE('New format is ' || currentformat);
COMMIT;
END;
/
Convert the format of an SI_StillImage object to GIFF using the SI_ConvertFormat( ) procedure:
DECLARE
origformat VARCHAR2 (10);
newformat VARCHAR2 (10);
myimage SI_StillImage;
currentformat VARCHAR2 (10);
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 1 FOR UPDATE;
origformat := myimage.SI_Format;
DBMS_OUTPUT.PUT_LINE('Original format is ' || origformat);
newformat := 'GIFF';
SI_ConvertFormat(myimage, newformat);
INSERT INTO PM.SI_MEDIA (product_id, product_photo) VALUES (5, myimage);
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 3 FOR UPDATE;
currentformat := myimage.SI_Format;
DBMS_OUTPUT.PUT_LINE('New format is ' || currentformat);
COMMIT;
END;
/
SI_Content ( )
RETURN BLOB DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetContent(image IN SI_StillImage)
RETURN BLOB DETERMINISTIC;
Returns the BLOB stored in the content_SI attribute of the SI_StillImage object to which this method is applied.
None.
None.
PRAGMA RESTRICT_REFERENCES(SI_Content, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetContent, WNDS, WNPS, RNDS, RNPS)
None.
Get the BLOB data stored in the content_SI attribute of an SI_StillImage object using the SI_Content( ) method:
DECLARE
myimage SI_StillImage;
photo BLOB;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 1;
photo := myimage.SI_Content;
END;
/
Get the BLOB data stored in the content_SI attribute of an SI_StillImage object using the SI_GetContent( ) function:
DECLARE
myimage SI_StillImage;
photo BLOB;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 1;
photo := SI_GetContent(myimage);
END;
/
SI_ContentLength ( )
RETURN INTEGER DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetContentLngth(image IN SI_StillImage)
RETURN INTEGER DETERMINISTIC;
Returns the value (in bytes) of the contentLength_SI attribute of the specified SI_StillImage object.
The image for which the content length is returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_ContentLength, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetContentLngth, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the contentLength_SI attribute of an SI_StillImage object using the SI_ContentLength( ) method:
DECLARE
length number;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
length := myimage.SI_ContentLength;
DBMS_OUTPUT.PUT_LINE('Length is ' || length);
END;
/
Get the value of the contentLength_SI attribute of an SI_StillImage object using the SI_GetContentLngth( ) function:
DECLARE
length number;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
length := SI_GetContentLngth(myimage);
DBMS_OUTPUT.PUT_LINE('length is ' || length);
END;
/
SI_Format ( )
RETURN VARCHAR2 DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetFormat(image IN SI_StillImage)
RETURN VARCHAR2 DETERMINISTIC;
Returns the value of the format_SI attribute (such as TIFF or JFIF) of the SI_StillImage object to which this method is applied.
None.
None.
PRAGMA RESTRICT_REFERENCES(SI_Format, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetFormat, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the format_SI attribute of an SI_StillImage object using the SI_Format( ) method:
DECLARE
format VARCHAR2 (10);
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
format := myimage.SI_Format;
DBMS_OUTPUT.PUT_LINE('Format is ' || format);
END;
/
Get the value of the format_SI attribute of an SI_StillImage object using the SI_GetFormat( ) function:
DECLARE
format VARCHAR2 (10);
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
format := SI_GetFormat(myimage);
DBMS_OUTPUT.PUT_LINE('Format is ' || format);
END;
/
SI_Height ( )
RETURN INTEGER DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetHeight(image IN SI_StillImage)
RETURN INTEGER DETERMINISTIC;
Returns the value of the height_SI attribute (in pixels) of the SI_StillImage object to which this method is applied.
The image for which the height is returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_Height, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetHeight, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the height_SI attribute of an SI_StillImage object using the SI_Height( ) method:
DECLARE
ht NUMBER;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
ht := myimage.SI_Height;
DBMS_OUTPUT.PUT_LINE('height ' || ht);
END;
/
Get the value of the height_SI attribute of an SI_StillImage object using the SI_GetHeight( ) function:
DECLARE
ht NUMBER;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
ht := SI_GetHeight(myimage);
DBMS_OUTPUT.PUT_LINE('height ' || ht);
END;
/
SI_RetainFeatures( );
RETURN BOOLEAN DETERMINISTIC;
Returns a Boolean value (TRUE or FALSE) to indicate whether or not image features will be extracted and cached.
This method is not in the first edition of the SQL/MM Still Image standard, but has been accepted for inclusion in the next version.
None.
None.
PRAGMA RESTRICT_REFERENCES(WNDS, WNPS, RNDS, RNPS)
None.
Determine whether or not the image features will be extracted and cached for a given SI_StillImage object:
DECLARE
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA
WHERE product_id = 1;
IF (myimage.SI_RetainFeatures = TRUE) THEN
DBMS_OUTPUT.PUT_LINE('Images features will be extracted and cached');
ELSE
DBMS_OUTPUT.PUT_LINE('Images features will not be extracted and cached');
END IF;
END;
/
SI_SetContent(content IN BLOB);
Format of Equivalent SQL Procedure
SI_ChgContent(image IN OUT NOCOPY SI_StillImage,
content IN BLOB);
Updates the content of an SI_StillImage object. It sets the values of the following attributes:
content_SI is updated with the value specified with the specified image.
contentLength_SI is updated with the new content length extracted from the specified image.
height_SI is updated with the new height extracted from the specified image.
width_SI is updated with the new width extracted from the specified image.
The image data. The format of this image data must be the same as the format of the current image.
The image whose content you want to update.
None.
None.
ORDImageSIExceptions.NULL_CONTENT
This exception is raised if the content parameter is NULL.
See Appendix G for more information about this exception.
Update the content of an SI_StillImage object using the SI_SetContent( ) method:
DECLARE
newcontent BLOB;
fils BFILE := BFILENAME('FILE_DIR','keyboard.jpg');
myimage SI_StillImage;
BEGIN
-- Put the blob in a temporary LOB:
DBMS_LOB.CREATETEMPORARY(newcontent, TRUE);
DBMS_LOB.FILEOPEN(fils, DBMS_LOB.FILE_READONLY);
DBMS_LOB.LOADFROMFILE(newcontent, fils, DBMS_LOB.GETLENGTH(fils));
DBMS_LOB.FILECLOSE(fils);
-- Select a row to be updated:
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1
FOR UPDATE;
myimage.SI_SetContent(newcontent);
-- Update the content of product_photo:
UPDATE PM.SI_MEDIA
SET product_photo = myimage where product_id=1;
-- Free the temporary LOB:
DBMS_LOB.FREETEMPORARY(newcontent);
COMMIT;
END;
/
Update the content of an SI_StillImage object using the SI_ChgContent( ) procedure:
DECLARE
newcontent BLOB;
fils BFILE := BFILENAME('FILE_DIR','keyboard.jpg');
myimage SI_StillImage;
BEGIN
-- Put the blob in a temporary LOB:
DBMS_LOB.CREATETEMPORARY(newcontent, TRUE);
DBMS_LOB.FILEOPEN(fils, DBMS_LOB.FILE_READONLY);
DBMS_LOB.LOADFROMFILE(newcontent, fils, DBMS_LOB.GETLENGTH(fils));
DBMS_LOB.FILECLOSE(fils);
-- Select a row to be updated:
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1
FOR UPDATE;
SI_ChgContent(myimage, newcontent);
-- Update the content of product_photo:
UPDATE PM.SI_MEDIA
SET product_photo = myimage where product_id=1;
-- Free the temporary LOB:
DBMS_LOB.FREETEMPORARY(newcontent);
COMMIT;
END;
/
SI_Thumbnail ( )
RETURN SI_StillImage;
Format of Equivalent SQL Function
SI_GetThmbnl (image IN SI_StillImage)
RETURN SI_StillImage;
Derives a thumbnail image from the specified SI_StillImage object. The default thumbnail size is 80 by 80 pixels. Because this method preserves the image aspect ratio, the resulting thumbnail size will be as close to 80 by 80 pixels as possible.
The image for which you want to generate a thumbnail image.
None.
None.
None.
Create a new thumbnail image from an SI_StillImage object using the SI_Thumbnail( ) method:
DECLARE
myimage SI_StillImage;
myThumbnail SI_StillImage;
height number;
width number;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
width := myimage.SI_width;
height := myimage.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
myThumbnail := myimage.SI_Thumbnail;
width := myThumbnail.SI_width;
height := myThumbnail.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
END;
/
Create a new thumbnail image from an SI_StillImage object using the SI_GetThmbnl( ) function:
DECLARE
myimage SI_StillImage;
myThumbnail SI_StillImage;
height number;
width number;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
width := myimage.SI_width;
height := myimage.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
myThumbnail := SI_GetThmbnl(myimage);
width := myThumbnail.SI_width;
height := myThumbnail.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
END;
/
SI_Thumbnail(height IN INTEGER, width IN INTEGER)
RETURN SI_StillImage DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetSizedThmbnl(image IN SI_StillImage,
height IN INTEGER,
width IN INTEGER)
RETURN SI_StillImage DETERMINISTIC;
Derives a new thumbnail image from the specified SI_StillImage object using the height and width that you specify. This method does not preserve the aspect ratio.
The height that you want interMedia to use for the thumbnail image.
The image for which you want to generate a thumbnail image.
The width that you want interMedia to use for the thumbnail image.
To preserve the aspect ratio, supply the appropriate height and width values. To obtain the appropriate height and width values, multiply the image height and width values by the required scaling factor. For example, if an image size is 100 by 100 pixels and the resulting thumbnail image needs to be one fourth of the original image, then the height argument should be 100 divided by 2 and the width argument should be 100 divided by 2. The resulting thumbnail image would be 50 by 50 pixels, and the aspect ratio would be preserved.
None.
None.
Create a new thumbnail image from an SI_StillImage object with the specified height and width using the SI_Thumbnail(height, width) method:
DECLARE
myimage SI_StillImage;
myThumbnail SI_StillImage;
height number;
width number;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
width := myimage.SI_width;
height := myimage.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
myThumbnail := myimage.SI_Thumbnail(129,121);
width := myThumbnail.SI_width;
height := myThumbnail.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
END;
/
Create a thumbnail image from an SI_StillImage object with the specified height and width using the SI_GetSizedThmbnl function:
DECLARE
myimage SI_StillImage;
myThumbnail SI_StillImage;
height number;
width number;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
width := myimage.SI_width;
height := myimage.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
myThumbnail := SI_GetSizedThmbnl(myimage,129,121);
width := myThumbnail.SI_width;
height := myThumbnail.SI_height;
DBMS_OUTPUT.PUT_LINE('Height is ' || height || ' pixels.');
DBMS_OUTPUT.PUT_LINE('Width is ' || width || ' pixels.');
END;
/
SI_Width ( )
RETURN INTEGER DETERMINISTIC;
Format of Equivalent SQL Function
SI_GetWidth(image IN SI_StillImage)
RETURN INTEGER DETERMINISTIC;
Returns the value of the width_SI attribute (in pixels) of the SI_StillImage object to which this method is applied.
The image for which the width is returned.
None.
PRAGMA RESTRICT_REFERENCES(SI_Width, WNDS, WNPS, RNDS, RNPS)
PRAGMA RESTRICT_REFERENCES(SI_GetWidth, WNDS, WNPS, RNDS, RNPS)
None.
Get the value of the width_SI attribute of an SI_StillImage object using the SI_Width( ) method:
DECLARE
width NUMBER;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
width := myimage.SI_Width;
DBMS_OUTPUT.PUT_LINE('Width is ' || width);
END;
/
Get the value of the width_SI attribute of an SI_StillImage object using the SI_GetWidth( ) function:
DECLARE
width NUMBER;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM PM.SI_MEDIA WHERE product_id = 1;
width := SI_GetWidth(myimage);
DBMS_OUTPUT.PUT_LINE('Width is ' || width);
END;
/
Describes the image texture characteristics by the size of repeating items (coarseness), brightness variations (contrast), and predominant direction (directionality). This object type is created in the ORDSYS schema with invoker rights. It is declared as an INSTANTIABLE and NOT FINAL type. (See "Internal Helper Types" for the textureEncoding attribute syntax.)
Note:
Use the SI_Texture constructor and method rather than accessing attributes directly to protect yourself from changes to the internal representation of the SI_Texture object.The SI_Texture object is described as follows:
CREATE OR REPLACE TYPE SI_Texture
AUTHID CURRENT_USER
AS OBJECT
(
--attributes
SI_TextureEncoding textureEncoding,
--Methods
CONSTRUCTOR FUNCTION SI_Texture
(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC,
--
MEMBER FUNCTION SI_Score
(SELF IN SI_Texture,
image IN SI_StillImage)
RETURN DOUBLE PRECISION DETERMINISTIC
) INSTANTIABLE
NOT FINAL;
/
where:
SI_TextureEncoding: a varray that represents the image texture characteristics such as coarseness, contrast, and directionality.
This section describes the SI_Texture object constructor, which is as follows:
SI_Texture(sourceImage IN SI_StillImage)
RETURN SELF AS RESULT DETERMINISTIC;
Format of Equivalent SQL Function
SI_FindTexture(sourceImage IN SI_StillImage)
RETURN SI_Texture DETERMINISTIC;
Constructs an SI_Texture object from the specified image.
The image whose texture feature is being extracted.
None.
None.
An error is returned if any of the following conditions is true:
The value of specified image is NULL.
The value of sourceImage.SI_Content is NULL.
The texture feature is not supported for the format of the specified image. This is determined by looking up the SI_IMAGE_FORMAT_FEATURES view or SI_IMAGE_FRMT_FTRS view.
Create an SI_Texture object using the SI_Texture( ) constructor:
DECLARE myTexture SI_Texture; myimage SI_StillImage; BEGIN SELECT product_photo INTO myimage FROM pm.si_media WHERE product_id=1 FOR UPDATE; myTexture := NEW SI_Texture(myimage); UPDATE pm.si_media SET texture = myTexture WHERE product_id=1; COMMIT; END; /
Create an SI_Texture object using the SI_FindTexture( ) function:
DECLARE
myTexture SI_Texture;
myimage SI_StillImage;
BEGIN
SELECT product_photo INTO myimage FROM pm.si_media
WHERE product_id=2 FOR UPDATE;
myTexture := SI_FindTexture(myimage);
UPDATE pm.si_media SET texture = myTexture WHERE product_id=2;
COMMIT;
END;
/
This section presents reference information on the SI_Texture method used for image matching, which is as follows:
SI_Score(image IN SI_StillImage)RETURN DOUBLE PRECISION DETERMINISTIC;
Format of Equivalent SQL Function
SI_ScoreByTexture(feature IN SI_Texture,
image IN SI_StillImage),
RETURN DOUBLE PRECISION DETERMINISTIC;
Determines and returns the score of the specified image as compared to the SI_Texture object to which you are applying the method. The lower the returned value, the better the texture of the image is characterized by the SI_Texture value used for scoring the image. This method returns a DOUBLE PRECISION value between 0 and 100, unless any one of the following is true, in which case a NULL value is returned:
The value of the SI_Texture object to which you apply this method is NULL.
The value of the specified image is NULL.
The value of image.SI_Contents is NULL.
The texture feature is not supported for the specified image.
The feature value to be compared with the texture of the specified image.
The image whose texture feature is extracted and used for score comparison.
None.
None.
None.
Compare an image to an SI_Texture object using the SI_Score( ) method and return the score:
DECLARE
score DOUBLE PRECISION;
myimage SI_StillImage;
myTexture SI_Texture;
BEGIN
SELECT texture INTO myTexture FROM pm.si_media
WHERE product_id=1;
SELECT product_photo INTO myimage FROM pm.si_media
WHERE product_id=2;
score := myTexture.SI_Score(myimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
Compare the texture of an image to an SI_Texture object using the SI_ScoreByTexture( ) function and return the score:
DECLARE
score DOUBLE PRECISION;
myimage SI_StillImage;
myTexture SI_Texture;
BEGIN
SELECT texture INTO myTexture FROM pm.si_media
WHERE product_id=1;
SELECT product_photo INTO myimage FROM pm.si_media
WHERE product_id=2;
score := SI_ScoreByTexture(myTexture, myimage);
DBMS_OUTPUT.PUT_LINE('Score is ' || score);
END;
/
The schema, SI_INFORMTN_SCHEMA, contains several views that identify the supported image formats and implementation-defined values. The privilege set on these views is PUBLIC WITH GRANT OPTION. The views are:
SI_IMAGE_FORMATS
SI_IMAGE_FORMAT_CONVERSIONS
SI_IMAGE_FORMAT_FEATURES
SI_THUMBNAIL_FORMATS
SI_VALUES
The column names, data types, and a description is provided for each of these views in the tables that follow.
Table 6-1 describes the SI_IMAGE_FORMATS view. This view identifies the supported image formats.
Table 6-1 SI_IMAGE_FORMATS View
| Column Name | Data Type | Description |
|---|---|---|
| SI_FORMAT | VARCHAR2(SI_MaxFormatLength) | A list of the supported image formats. |
Table 6-2 describes the SI_IMAGE_FORMAT_CONVERSIONS view. This view identifies the source and target image formats for which an image format conversion is supported. The short name for this view is SI_IMAGE_FORMAT_CONVRSNS.
Table 6-2 SI_IMAGE_FORMAT_CONVERSIONS View
| Column Name | Data Type | Description |
|---|---|---|
| SI_SOURCE_FORMAT | VARCHAR2(SI_MaxFormatLength) | The format of the source image. |
| SI_TARGET_FORMAT | VARCHAR2(SI_MaxFormatLength) | The format of the target image. |
Table 6-3 describes the SI_IMAGE_FORMAT_FEATURES view. This view identifies the image formats for which a basic feature is supported. The short name for this view is SI_IMAGE_FRMT_FTRS.
Table 6-3 SI_IMAGE_FORMAT_FEATURES View
| Column Name | Data Type | Description |
|---|---|---|
| SI_FORMAT | VARCHAR2(SI_MaxFormatLength) | The format name. |
| SI_FEATURE_NAME | VARCHAR2(100) | The basic feature name that is supported by the named format. Value can be any of the following:
|
Table 6-4 describes the SI_THUMBNAIL_FORMATS view. This view identifies the image formats from which thumbnail images can be derived. The short name for this view is SI_THUMBNAIL_FRMTS.
Table 6-4 SI_THUMBNAIL_FORMATS View
| Column Name | Data Type | Description |
|---|---|---|
| SI_FORMAT | VARCHAR2(SI_MaxFormatLength) | The formats from which a thumbnail image can be derived. |
Table 6-5 describes the SI_VALUES view. This view identifies the implementation-defined values.
| Column Name | Data Type | Description |
|---|---|---|
| SI_VALUE | VARCHAR2( SI_MaxFormatLength) | The implementation-defined meta-variables. The SI_VALUES view has 8 rows where each row has one of the following SI_VALUE column values:
|
| SI_SUPPORTED_VALUE | NUMBER(38) | A column with the following values:
|
An attribute that consists of an array is specified as an internal helper type. Internal helper types are created in the ORDSYS schema and do not have public synonyms.
The internal helper types are the following:
The syntax for this internal helper type is:
CREATE OR REPLACE TYPE colorsList AS VARRAY(100) OF SI_Color;
This internal helper type is used to specify the SI_ColorsList attribute of the SI_ColorHistogram Object Type as described.
The syntax for this internal helper type is:
CREATE OR REPLACE TYPE colorFrequenciesList AS VARRAY(100) OF DOUBLE PRECISION;
This internal helper type is used to specify the SI_FrequenciesList attribute of the SI_ColorHistogram Object Type as described.
The syntax for this internal helper type is:
CREATE OR REPLACE TYPE colorPositions AS VARRAY(9) OF SI_Color;
This internal helper type is used to specify the SI_ColorPositions attribute of the SI_PositionalColor Object Type as described.
The syntax for this internal helper type is:
CREATE OR REPLACE TYPE textureEncoding AS VARRAY(5) of DOUBLE PRECISION;
This internal helper type is used to specify the SI_TextureEncoding attribute of the SI_Texture Object Type as described.
|
 Copyright © 1999, 2005, Oracle. All rights reserved. Legal Notices |
|