Storing Word docs, XL spreadsheets etc in Oracle - Why?
Simple enough question. I know all about being able to store documents in an Oracle database. My question is why would you do this? What great business benefit to a company in storing documents in this fashion? I can think of two: security and recoverability, but if the network is secure and backed-up, is Oracle any better?
Have I missed something here folks? Anyone know any good on-line docs or resources where I can read up the concepts in a business scenario?
all I can think of is some kinda backend to a website or custom app that serves up documents from a massive library. A site that had lots of pictures would be a good example of this......apparently people like looking at pictures on the interweb
Remember also, using RMAN gives you block level recovery. If you have a problem with a large image or document you would have to restore the whole file from an OS backup. With Oracle restore/recovery issue is much reduced.
The next release of Windows will incorporate a database layer on top of the filesystem (WinFS) which will essentially act as a clever indexing tool. If you're going half-way why not go the whole hog!