Re: real-world experience with Oracle doc storage, intermedia etc.

Fred Pierce wrote:
> I have been advocating the "if it can be done in the database, do it
> in the database" philosophy for some time and am beginning to have
> some success with it. Most recently, I pointed out Oracle's capability
> of storing blobs and clobs etc. and to my surprise, the People in
> Power were enthusiastic about it.
>
> They did request, however, that I provide some "testimonials" from
> folks who have done this and I too, am concerned as to what I'm
> getting into here, e.g. performance issues, additional resources, and
> my prime concern, backup. I have emphasized or course that as we put
> more of our existence into the database, we must improve HW, personnel
> training, procedures etc. I have read Tom Kyte, Steven Feuerstein and
> others and have played with CLOBS and Intermedia a bit but don't have
> much feel for what it will involve from a DBA perspective.
>
> We are currently running 9.2.0.4 Enterprise on a HP/Compaq Alpha but
> are probably going to move to Linux/Intel. I am trying to plan with
> 10g in mind.
>
> So, any "war stories," good or bad? White papers are useful to me too,
> but the PIP would like to see some "we use it do do this and it works
> great/horrible" or whatever.
>
> As much as I want to do this, I am stretched pretty thin, partly
> because I have a tendency to let my enthusiasm get the better of me,
> so I want to be realistic. I can back off and let them do some kludge
> and not be responsible but don't want to take that route if I can do
> it right using Oracle. Of course, I have no idea what requirements
> will be but probably initially small, i.e. a few Gb.
>
> Thanks for any feedback you can provide.
>
> Fred Pierce Oracle OCP DBA (forgive me!), developer, Oracle
> apologist, etc.
>
> --------------------------------------------------------------------
> Fred Pierce (DNRC)- fpierce_at_avialantic.com
> Mid-Atlantic Aviation on the Web - http://www.avialantic.com
> ---------------------------------------------------------------------

No war stories here. I have an application I delivered to a medical board last June that stores photographs of the physicians as a BLOB. Works perfectly. Good enough that a second medical board just ordered the same software.

But if you really want to convince them ... all of the high volume internet porn sites use Oracle. Why? Because it works. Could there be a higher recommendation?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)