This discussion is archived
1 Reply Latest reply: Sep 29, 2008 2:23 PM by 251301 RSS

New to Oracle intermedia/ multimedia

577359 Newbie
Currently Being Moderated
Hi guys, I'm new to Oracle intermedia. I have questions regarding on this topic.

1. Can i insert images directly to table rows?
2. What is the best approach if I'm using Oracle as back end, ASP as front end. I need to insert, update, delete and retrieve images in the Oracle database using my ASP application(This is MapGuide GIS application). Should I create directory to store all my images or save the images directly to tables?
3. Which is the best to use, BLOB, BFILE or ORDImage.?

Thanks and Regards
Jay
  • 1. Re: New to Oracle intermedia/ multimedia
    251301 Explorer
    Currently Being Moderated
    Hi,

    Before I answer your questions, I note that you are creating a GIS application. Are these images associated with coordinates or otherwise gridded data (layers etc)? If yes, you may want to take a look at the GeoRaster component of the Oracle Spatial option.
    See www.oracle.com/technology/products/spatial/index.html for more information
    ---------------------
    GeoRaster is a feature of Oracle Spatial that lets you store, index, query, analyze,
    and deliver raster image and gridded data and its associated metadata. GeoRaster
    provides Oracle spatial data types and an object-relational schema. You can use
    these data types and schema objects to store multidimensional grid layers and
    digital images that can be referenced to positions on the Earth's surface or in a
    local coordinate system. If the data is georeferenced, you can find the location on
    Earth for a cell in an image; or given a location on Earth, you can find the cell in
    an image associated with that location.
    ---------------------------

    The Oracle Multimedia OTN home page is http://www.oracle.com/technology/products/intermedia/index.html

    1. Yes you can store images in ORDImage columns or BLOB columns of your rows.
    Look at the Oracle Multimedia QuickStart guides from the sample code page to show you how this is done

    2. You can read and write image data directly to BLOBs that are stored in your table. You will need to execute a query that creates or returns an initialized BLOB locator to your .NET application. This can be done in a number of ways.

    For example:
    1. insert returning (execute as anonymous pl/sql block)
    begin
    insert into myimages(image) t
    values (ordimage.init())
    returning t.image.source.localData into :?;
    end;

    or if your image column is created elsewhere, you can select the blob using a query:
    select t.image.source.localdata into :? from myimages t where ....

    3. You want to store the image in the database using ORDImage or BLOB. The advantage of ORDImage is that it is strongly typed, it is an image column, not just a binary data column. Also the ORDImage object will store the important image metadata attributes (height, width, mimetype etc) for you.

    Try readiing the early chapters of the development guide for an introduction to Oracle Multimedia functionality.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points