Re: choices regarding where to place code - in the database or middletier
Date: Tue, 27 Jan 2004 22:37:35 -0800
Message-ID: <1075271792.254492_at_yasure>
[Quoted] Joe Weinstein wrote:
>> Unless I interpret the above as meaning you've changed your mind I am
>> lost as to your original intent when you wrote that you counsel
>> against complete DBMS dependence. Seems like you've changed from
>> "dependence" to "INdependence". Was the original a typo or did I
>> misunderstand you?
> > No, the original is correct, that I council *against complete DBMS > INDEPENDENCE*. The 'IN' is intended, and in the original post. I also[Quoted] > council against complete DBMS-specificity, or even using the DBMS for > everything it can do.
You are mixing together multiple incompatible concepts. Lets take them one at a time.
Complete DBMS independence means utilizing those vendor specific functions that optimize security, performance, and scalability. Good so far.
Having done the former ... the second is logically impossible. Once I use a vendor specific function, for example in Oracle packages, I have code that can not be moved anywhere else without a rewrite. You can't have it both ways.
BTW: I normally don't correct spelling but you have used the word so many times it begs pointing this out: The word you are looking for is 'counsel' not 'council'.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Jan 28 2004 - 07:37:35 CET