Storing Word docs, XL spreadsheets etc in Oracle - Why? Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Storing Word docs, XL spreadsheets etc in Oracle - Why?

  1. #1
    Join Date
    Jan 2000
    Chester, England.

    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?

  2. #2
    Join Date
    Jan 2002
    The indexing structure on the OS('s) is getting smarter/faster and I wonder myself what's the point of storing it all in the a database. unless you want everyone to do a select * from bigdoc.bigdocos;

    but I'm sure there are stronger arguments than these to store them in db and vice versa.
    Last edited by Tarry; 03-18-2004 at 11:22 AM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    --- Everything was meant to be---

  3. #3
    Join Date
    Mar 2002
    Manchester, England
    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

  4. #4
    Join Date
    Aug 2002
    Bangalore, India
    What abt in the view of backup and recovery?

    If it is external file, we will have to manually check whether all the files R there or not in the case of restoration.

    Security is another reason. Instead of buying 3rd party OS level security tools, we can explore Oracle server's security features.

    These points R with respect to DBA's views. Management ppl can have different idea.

  5. #5
    Join Date
    Dec 2001

    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!

    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website:
    My blog:

  6. #6
    Join Date
    Jun 2000
    Madrid, Spain
    well if you store these in the database you can query and search right?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width