asked on

How to store images in an oracle based application?

Our Insurance application is developed in Oracle and is accessed using browser through application Server. In this software we store insurance policy related data which is very huge.
We want to store scanned images of the documents. Now i need an experts opinion about storing the image. please advise do we need to store images within the database or we should store on File System and store its path into the database. please note our database already has poor performance.

Thank
Ali

R-Byter

SInce You have poor performance, It is good in my opinion to use filesystem to store images and database to store their paths. Be sure to protect folders where docuemnts reside from unauthorized access.

Shaju Kumbalath

Try this link
http://www.dba-oracle.com/t_storing_insert_photo_pictures_tables.htm

schwertner

Using BLOBs you will have the possibiity to backup and to recover the data using standart Oracle tools like RMAN. This will add stability in your project. Normally Oracle uses BLOB type (Binary Large Objects) to store images. Oracle 11g has a special medical DICOM data format.

maliawan

ASKER

I am unable to view this URL http://www.dba-oracle.com/t_storing_insert_photo_pictures_tables.htm

Please send me the contents aliawan@alidc.com.pk

thanks

maliawan

ASKER

Dear schwertner,

don't you think that storing in in db as blob objects will hit the performance further more as said our db already has severe performance issues.

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

maliawan

ASKER

partially complete