Re: Database programming standards

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Sun, 6 Jun 2004 06:10:38 -0700 (PDT)
Message-ID: <20040606131038.10763.qmail@web50610.mail.yahoo.com>

Hi deen,

This may help you with your RFP, from an Oracle DBA's perspective. Sorry if I'm a little slow to reply.

-----Original Message-----

From: deen dayal [mailto:deen.dayal_at_xxxxxxxxxxxxxxx] Sent: Wednesday, June 02, 2004 5:26 PM
To: oracle-l_at_xxxxxxxxxxxxx
Subject: Database programming standards

Hi all,

We are in the process of preparation of a RFP for a big project; it is going
to be developed in J2EE, do not know which app server we are going to use (
probably SUN Iplanet server ), Oracle 9i is the back end.

I am looking for some database programming standards to be written up in RFP
so that we maintenance team can reduce the amount of mess to deal with after
vendor leaves.
...
----------END QUOTE----------
Why not include in the RFP SLA that "Any off the shelf (OTS) application that does *not* allow Oracle to support RI, nor triggers, nor stored procedures, must *guarantee* RI and equivalent performance/scalability without additional maintenance or productivity costs"?

One form of *guarantee* might be to refund the cost of DBA work to analyze and delete duplicate records, or pay to perform database optimization/scalability testing and updates.
Another example, pay the consulting expenses and lost productivity penalty to *fix* RI in the OTS application.
Finally, pay for legal and business expenses to recover costs of failed RI in the OTS application, since the OTS vendor did not support running RI features in Oracle. How about paying expenses to recover duplicate payments generated erroneously?

Unfortunately, these are some actual experiences I wish were included in our project RFP up-front.

You can likely think of a few similar ideas. ;-)

HTH. Regards,

Mike Thomas

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Sun Jun 06 2004 - 08:07:25 CDT