Hi all, God morning and thank you all very much for a valuable discussion on this topic. With this we will be able to add some thing meaningful in our RFP which will help us in a long way. I am fortunate to be a part of this list. Thanks Deen -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael Thomas Sent: Sunday, June 06, 2004 9:11 AM To: Multiple recipients of list ORACLE-L Subject: Re: Database programming standards 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@xxxxxxxxxxxxxxx] Sent: Wednesday, June 02, 2004 5:26 PM To: oracle-l@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"? 1) 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. 2) Another example, pay the consulting expenses and lost productivity penalty to *fix* RI in the OTS application. 3) 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------