RE: Death of the database

<start of smiley>

Clearly, it is the database's fault.
</end of smiley>

Jim

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of david wendelken Sent: Monday, October 31, 2005 9:58 AM
To: Oracle-L Freelists
Subject: RE: Death of the database

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

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