How to store images in an oracle based application?

maliawan
maliawan used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Commented:
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.
Top Expert 2008

Commented:
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.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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

Author

Commented:
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.
Top Expert 2008
Commented:
The reading of BLOBs from the file system and from the DB takes the same time.
In fact it is reading from Hard Disk Drive.
So the backup and restore strategy will be monolitic. If the files are outside the DB
you have to develop second strategy for backup of that files.
The problems you experience possibly are caused by other factors in your unstallation - lack of fresh statistics, small ram, lack of indexes and many other things.

Author

Commented:
partially complete

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial