From oracle-l-bounce@freelists.org Wed Oct 19 12:37:42 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9JHbg8O030861 for ; Wed, 19 Oct 2005 12:37:42 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9JHbevX030842 for ; Wed, 19 Oct 2005 12:37:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B44E3209242; Wed, 19 Oct 2005 12:37:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01519-08; Wed, 19 Oct 2005 12:37:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2DE932091F5; Wed, 19 Oct 2005 12:37:29 -0500 (EST) Message-ID: From: "Murching, Bob" To: "'Oracle Mailing List'" Subject: PDFs (or binary objects) in the database... When? Date: Wed, 19 Oct 2005 12:53:13 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D4CD.980CE6F6" X-archive-position: 27208 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: bob_murching@BUDCO.com Precedence: normal Reply-To: bob_murching@BUDCO.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------_=_NextPart_001_01C5D4CD.980CE6F6 Content-Type: text/plain We design a fair number of J2EE applications that (increasingly) require storage and query/presentation of binary documents.... generally PDFs. Occasionally our DBAs have been consulted with that age-old "should we store these in the database or on a filesystem?" question by developers and analysts when designing the application. So far we've tended to put them on the filesystem but honestly that's because we don't have any guidance on when it makes sense to store them in the DB. Obviously Oracle provides a level of security, access control and auditing, along with (arguably) backup and recovery capabilities that might surpass filesystem storage. Manageability is easier when volumes reach the tens of thousands of files. On the other hand, there is a concern that putting tens of thousands of objects in BLOB columns can impose some performance overhead... perhaps inefficiencies in JDBC, or within Oracle RDBMS itself, or ... ? It certainly is "simple" to dump the PDFs on the filesystem and storage file paths in a table. Anyone else run into this? In which direction have you leaned and how do you decide? And can anyone speak to what considerations should be kept in mind when storing documents in BLOBs and querying them via JDBC, for either browser presentation or manipulation in the midtier? Bob ------_=_NextPart_001_01C5D4CD.980CE6F6 Content-Type: text/html Content-Transfer-Encoding: quoted-printable PDFs (or binary objects) in the database... When?

We design a fair number of J2EE = applications that (increasingly) require storage and query/presentation = of binary documents.... generally PDFs.  Occasionally our DBAs = have been consulted with that age-old "should we store these in = the database or on a filesystem?" question by developers and = analysts when designing the application.  So far we've tended to = put them on the filesystem but honestly that's because we don't have = any guidance on when it makes sense to store them in the DB.

Obviously Oracle provides a level of = security, access control and auditing, along with (arguably) backup and = recovery capabilities that might surpass filesystem storage.  = Manageability is easier when volumes reach the tens of thousands of = files.  On the other hand, there is a concern that putting tens of = thousands of objects in BLOB columns can impose some performance = overhead... perhaps inefficiencies in JDBC, or within Oracle RDBMS = itself, or ... ?  It certainly is "simple" to dump the = PDFs on the filesystem and storage file paths in a table.

Anyone else run into this?  In = which direction have you leaned and how do you decide?  And can = anyone speak to what considerations should be kept in mind when storing = documents in BLOBs and querying them via JDBC, for either browser = presentation or manipulation in the midtier?

Bob

------_=_NextPart_001_01C5D4CD.980CE6F6-- -- http://www.freelists.org/webpage/oracle-l