RE: Death of the database

  • From: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
  • To: <davewendelken@xxxxxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 31 Oct 2005 11:09:25 -0800

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

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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...

 

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

Other related posts: