Re: Database Server Vs. Application Servers - Processing Location

My personal feeling is that you should take advantage of the RDBMS strengths to make your application the best that it can be. Tom Kyte addresses this in his Expert One-on-one Oracle book.

If anything, I'd put RDBMS-specific logic in stored procedures in the database. Then your application can be as vendor-neutral as possible, just calling stored procs. The stored procs can be as vendor-specific as you want. All you'd need is vendor-specific stored procs with your application.

I've worked with lots of 3rd party apps. IMO, the best vendors are the ones who take time to engineer their apps for specific RDBMS versions. These apps cause the least amount of headaches when compared with apps that try to be vendor-neutral.

Just my 3.14159265 cents worth,
Brian

Burton Peltier wrote:
>
> Just wondering what others opinions are on this subject...
>
> Within our company, there are some who think in-house developed applications
> should be architectured such that there is no dependence on the underlying
> database server software - the database server should only do CRUD
> (create,read,update,delete) processing.
>
> This might at first seem sensible to some, I think there are way too many
> "gray areas" to say the above should be a "standard" that must be adhered to
> or have permission to do differently. I am guessing this is some people's
> intent.
>
> Some people spend way too much effort trying to not "tie" themselves to 1
> database vendor and don't take advantage of features and functionality (in
> Oracle for our company), at a significant loss either by lost functionality
> or performance or "writing their own way". Or, they do things like put hints
> in the SQL to tune and are "tied" anyway.
>
> Note: I can see where a software vendor should/has to try and work this way.
> But, this does not seem to make sense for a commercial company like ours.
>
> --

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"