dbTalk Databases Forums  

storage concept

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss storage concept in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Christian Bielzer
 
Posts: n/a

Default storage concept - 07-29-2003 , 06:18 AM






Hi to all,
I need your support. I am having a customer who needs to archive documents
of different types (eg. html, tiff). These documents need to be archived on
optical media (worm), so they can not be changed once they have been stored
to the archive.

I have heared, that it is possible, to store data using the Oracle Text
cartridge. That would fit for the html-documents. But how about the
image-files? Afaik, they can be stored along with their attributes either as
blobs or bfiles in the database.

There are different options to achieve the goal of an archive:
- the image file as a bfile will be stored directly on the optical media
(worm) while its attributes will be stored in a tablespace on a HDD
- the image file is stored on the optical media. Afterwards the "reference"
will be stored as a string in a table along with the attributes
- the image file is stored as a blob along with the attributes in a table. A
backup of the tablespace on the jukebox would be necessary afterwards.
- a tablespace will be created on the optical media jukebox (If that is a
technical option I doubt it would make sence)
- the

Has anyone experiences in any storage concept or can think of another one
that would make sence? I am really open minded as I am a newbie to the
archiving issue.

TIA

Christian



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.