RE: Storing blobs in database vs filesystem

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 29 Sep 2006 15:37:31 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302001DB04DA@BLRKECMSG11.ad.infosys.com>

Kevin, Folks

We are also facing a similar issue with our "Banking" Application product where approx 1/3rd of the Database size is taken up by 1 Table which stores the Customer Signatures in one of its LONG/LOB fields.

Database Sizes are in the range of a few Tera Bytes.

The Banking Product is a primarily Pro C Application, with java functions too.

Qs IN OUR BANKING PRODUCT CASE, THE RESPECTIVE SIGNATURE IS VERIFIED AS PART OF AN OLTP TRANSACTION BY A BANK STAFF USER & THEREAFTER A CREDIT/DEBIT OLTP TRANSACTION IS PASSED TO THE RESPECTIVE CUSTOMER'S BANK ACCOUNT. DOES THIS QUALIFY FOR STORAGE AS EXTERNAL DATA? SOME ADDITIONAL QUESTIONS ARE EMBEDDED BELOW IN CAPITALS. Thanks indeed

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Closson Sent: Friday, September 29, 2006 5:02 AM To: fnmpa_at_uaf.edu; ORACLE-L
Subject: RE: Storing blobs in database vs filesystem

I'll take a stab. Historically, there have not ben options for getting

multiple servers access to unstructured data (read CFS). So

at least with OPS and RAC, stuffing these, actually quite-unstructured,

pieces of data into the database at least got them accessible to

multiple nodes. Also, historically, there were no PL/SQL callouts

to get unstructured data.

These 2 factors are now historical. You can deal with external data nicely with 9i and moreover 10g and

CFS and NAS technology is not spooky anymore (well, I think it might be to the open source folks).

• ANY SAMPLE LINKS, DOCS ON EXTERNAL DATA ACCESS?
• IS EXTERNAL DATA ACCESS SLOWER VERSUS WHEN STORED WITHIN?

The other force was the desire in the mid 90s for Sybase,Informix and

Oracle to be *the* repository for all data...there were musings

of OODB and RODB and all those things that never really got anywhere.

That is, Informix and Oracle wanted to be media servers in addition to

databases and that was at a point in history that predated the

web, really.

There are a lot of Oracle sites that blend the best of what Oracle

does and the best of what Oracle does to support external unstructured

data.

• ANY SAMPLE LINKS, DOCS ON EXTERNAL DATA ACCESS?

Gannett Media comes to mind.

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** -- http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 29 2006 - 05:07:31 CDT