Storing and Retrieving Images in Oracle

Pages 3 (753 words)
Download 0
Storing images in database is not recommended. The drawbacks to this approach could be that the server to process huge amounts of data. The images stored in database can not be viewed by any standard viewers; they can be only viewed through application. ("datanamic") This approach is certainly safe since it utilizes the security features of the DBMS.


("oracle_why_image_indatabase", 2005) Oracle database provides a feature known as oracle Intermedia which enables easy and efficient management of images, audio and video data. ("Oracle", 2005) This helps programmers in multimedia application development. Oracle 10g also addresses issues such as security, backup/recovery, extensibility and flexibility. ("oracle_why_image_indatabase", 2005) It reduces the response time and hence reduces the operation cost as well.
Storing images in file system allows does not allow selective access to images in the directory. Individual users can access all or none of the images in the file system, which is not desired and this proves a threat to the database. ("oracle_why_image_indatabase",2005) In traditional file systems the images have to be backed up on regular basis, which is not so in database storage. One single backup program is required for day to day backup and also only one program is required for recovery. Conversion of images form one format to another is also made possible in this storage procedure.
Oracle, as we all know is a database management system that is Object Relational in nature. This allows oracle to store images in addition to normal data in the database. ...
Download paper
Not exactly what you need?