From oracle-l-bounce@freelists.org Thu Oct 20 00:43:51 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9K5hjMs013802 for ; Thu, 20 Oct 2005 00:43:46 -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 j9K5havX013770 for ; Thu, 20 Oct 2005 00:43:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CBC23209792; Thu, 20 Oct 2005 00:43: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 13944-09; Thu, 20 Oct 2005 00:43:29 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 570E920977F; Thu, 20 Oct 2005 00:43:29 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=dyLyFj8x0TkbaUCdLbs97z90YaudizYqLj/At6WsPQOFprmDYze3B4Dte7Gi9c3cxWYjvyTPT7o802Gg0YLeEYD7+iy7M/Gemo1KJ9Dj9LO1K4dLB7wdkhNK08ERdI/9xAsbAYyl5eA5AOqzKdndEgb3JK3sf6+DaaY/Lxnncx0= Message-ID: Date: Thu, 20 Oct 2005 06:41:28 +0100 From: Jared Still To: niall.litchfield@gmail.com Subject: Re: PDFs (or binary objects) in the database... When? Cc: bob_murching@budco.com, Oracle Mailing List In-Reply-To: <7765c8970510192234la8f6dcnb50f47cad9373825@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_97_11466683.1129786888791" References: <7765c8970510192234la8f6dcnb50f47cad9373825@mail.gmail.com> X-archive-position: 27236 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.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=-3.7 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_97_11466683.1129786888791 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 10/20/05, Niall Litchfield wrote: > > The biggest thing for me is recoverability. Storing the files on the > filesystem doesn't give you the same recoverability (you'd have to keep t= he > two different backups in sync or have a bulletproof way of resolving > differences in a failure situation, both of these add to pressure on the = dba > sysadmin at the wrong time. ) A biggie for the users is usability. MS has tried and failed to do usable document indexes on the filesystem. Note that SharePoint stores *all* documents in a SQL database, which is where a large chunk of our documents are headed, and will be indexed and searchable. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist ------=_Part_97_11466683.1129786888791 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On 10/20/05, Niall Litchfield <niall.litchfield@gmail.com> wrote:
The biggest thing for me is recoverability. Storing the files on the filesystem doesn't give you the same recoverability (you'd have to keep the two different backups in sync or have a bulletproof way of resolving differences in a failure situation, both of these add to pressure on the dba sysadmin at the wrong time. )


A biggie for the users is usability.

MS has tried and failed to do usable document indexes on the filesystem.
Note that SharePoint stores *all* documents in a SQL database, which
is where a large chunk of our documents are headed, and will be indexed
and searchable.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl= Evangelist
------=_Part_97_11466683.1129786888791-- -- http://www.freelists.org/webpage/oracle-l