RE: Semi-OT: It's the Code, Stupid!

I'd also include "ignorance" and "simply too freakin old" as our ERP system was written in the 80s using RMS indexed files (much better than typical "flat" files) on VAX/VMS (Alphas didn't exist then) in a 4GL. When the system was migrated to StarBase/Interbase and then to Oracle, instead of rewriting the entire app to include the then-newish concept of normalization (very expensive for very little benefit to the vendor's bottom line), the 4GL's data dictionary was simply pointed to the new tables transferred verbatim to the DB.
Which leads to us having an item's description starting in one table and optionally finishing in another, among other fun things.

Rich

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of david wendelken Sent: Thursday, June 02, 2005 11:40 AM
To: shrekdba_at_gmail.com; mark.powell_at_eds.com Cc: oracle-l_at_freelists.org
Subject: Re: Semi-OT: It's the Code, Stupid!

>> From experience I am surprised when a vendor product does not fall
into
>> the "worst-case" scenario as far as the database design, process, and
>> code is concerned.

>it results, i believe, from trying to be "database independent".

No, simple professional incompetence is the reason.

The same problem existed long before "database independence" became popular.

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



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