Re: choices regarding where to place code - in the database or middle tier

From: Daniel Morgan (damorgan_at_x.washington.edu)
Date: 01/19/04

  • Next message: Robert: "Re: Java Certification Tutor" 
    Date: Mon, 19 Jan 2004 13:28:53 -0800

    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@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@x.washington.edu
(replace 'x' with a 'u' to reply)
  • Next message: Robert: "Re: Java Certification Tutor"

    Relevant Pages