From oracle-l-bounce@freelists.org Mon Oct 31 12:00:38 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9VI0chW027256 for ; Mon, 31 Oct 2005 12:00:38 -0600 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 j9VI0OvX027182 for ; Mon, 31 Oct 2005 12:00:25 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B9A1D213825; Mon, 31 Oct 2005 12:59:41 -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 01306-10; Mon, 31 Oct 2005 12:59:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2FC9E2138FE; Mon, 31 Oct 2005 12:59:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 31 Oct 2005 12:57:45 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3C141213828 for ; Mon, 31 Oct 2005 12:57:45 -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 00872-01 for ; Mon, 31 Oct 2005 12:57:45 -0500 (EST) Received: from pop-cowbird.atl.sa.earthlink.net (pop-cowbird.atl.sa.earthlink.net [207.69.195.68]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C591721380A for ; Mon, 31 Oct 2005 12:57:44 -0500 (EST) Received: from elwamui-mouette.atl.sa.earthlink.net ([209.86.224.41]) by pop-cowbird.atl.sa.earthlink.net with esmtp (Exim 3.36 #10) id 1EWduh-0004F2-00 for oracle-l@freelists.org; Mon, 31 Oct 2005 12:57:43 -0500 Message-ID: <27664436.1130781463895.JavaMail.root@elwamui-mouette.atl.sa.earthlink.net> Date: Mon, 31 Oct 2005 12:57:43 -0500 (EST) From: david wendelken To: Oracle-L Freelists Subject: RE: Death of the database Mime-Version: 1.0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-archive-position: 27848 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: davewendelken@earthlink.net Precedence: normal Reply-To: davewendelken@earthlink.net 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.1 required=5.0 tests=BAYES_00, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,HTML_MIME_NO_HTML_TAG, MIME_HTML_ONLY,RCVD_IN_SORBS autolearn=no version=2.63

And I bet the app developers didn't learn from their mistake, either.

-----Original Message-----
From: "Delmolino, Dominic"
Sent: Oct 31, 2005 12:52 PM
To: Oracle-L Freelists
Subject: RE: Death of the database

The first one was where the app developers said they didn’t need DBA help because they were going to store everything as Java Serializable Objects (JSOs) – so every table was a tuple like (PRODUCT_ID number, PRODUCT_PROPERTIES blob). Worked ok for about 3 months (where I had less work). Then they came back to my team when queries were slow, and no one could browse the data, and no one could write reports on it… And of course we ended up structuring the data back into regular tables (which ended up with more work for me).

The second one was where we received a custom developed invoice application that made heavy use of XML CLOBs – so every table was a tuple like (INVOICE_ID number, INVOICE_CONTENTS clob). Worked ok for 2 months (where I had less work). Then my management threw out the product because the text-based indexes were slow, kept needing re-builds, no one could browse the data, and no one could write reports on it…

-- http://www.freelists.org/webpage/oracle-l