Daniel Roy wrote:
> Hi Joe,
> I am a Siebel configurator/programmer (Siebel is a "Customer
> Relationship Management" software, which can be considered analogous
> to SAP). My personal experience with the issue which interests you is
> that as much as possible should be stored in the database. Siebel, by
> some twisted reasoning about compatibility of code on various
> databases (it runs on Oracle, SQL Server and DB2), decided to keep
> almost all the code (including referential integrity!) in the middle
> tier. As a result, on ALL the projects I've been a part of, we have
> had data issues. The worst part is for the foreign keys which are not
> valid. Other issue are about some code (usually PL/SQL) which is not
> in sync with the database, for whatever reason (access rights,
> objects/columns which don't exist anymore, ...). Also, performance is
> always better from inside the database, from what I've seen so far.
> This is logical since there is less network traffic when everything is
> done from Oracle.
>
> Just my 2 cents
>
> Daniel
>
>
>>Hi -
>>
>>Over the last several versions of Oracle, developers have been provided with
>>a pretty revolutionary idea for a database product - namely the ability to
>>write code that used to belong in the middle tier and store it in the
>>database. I'm referring here to the ability to write stored procedures in
>>Java.
>>
>>Now of course, Microsoft with their SQL Server product is doing the same
>>thing. The next version of SQL Server will allow programmers to write
>>stored procedures in any of the .NET languages.
>>
>>I'm interested in looking at the increased choices developers now have
>>because of these new features in more depth ,developing some best practices
>>on the subject, and possibly publishing an article on the topic.
>>
>>I personally am more experienced with SQL Server than with Oracle. I am
>>therefore looking for someone who has been involved with making these
>>choices in the Oracle environment who would like to collaborate with me on
>>the subject.
>>
>>If you are interested, please contact me at joelax_at_dbdirections.com
>>
>>Thank you
>>
>>Joe Lax
Exactly mirrors my experience with Siebel, SAP, PeopleSoft, and Baan.
--
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 Mon Jan 19 2004 - 15:28:53 CST
