Re: "We don't do triggers"

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 17 Dec 2003 00:21:54 -0800
Message-ID: <1071649219.988790@yasure>

Paul wrote:

> n-litchfield_at_audit-commission.gov.uk says...
>
>
>

>>>I'm on the periphery of a rather large (to me, at least: $10 mil..)
>>>project in which the tech folks flatly say "NO STORED PROCEDURES: 
>>>NONE, NOT EVER!".

>
>

>>>There's got to be a reason, but I don't know enough to even guess at it.

>
>
>
> AFAICS, it's easy. They want to use Oracle + MS SQL Server (+ Sybase +
> <insert RDBMS of your choice>).
>
> They can do this with bog-standard SQL + no triggers or stored
> procedures and run any code that they can't run under SQL on the client
> side (or possibly using a 2nd tier in a three-tier model).
>
> I worked for a large company that did this - their product ran perfectly
> on Oracle and MS SQL Server (and I am talking millions for an install
> and maintainance contract), but the db had not an SP or trigger in
> sight.
>
>
>

>>I'd ask. If the answer is all the logic etc belongs in the application
>>explain that there will be 2 corollaries

>
>
>

>>1. NO DATA LOADS EVER. Key it through the app ALWAYS. even 10 million rows.
>>2. NO INTERFACES TO OTHER SYSTEMS, EVER. make other systems talk to the app.

>
>
>

>>They both follow logically from this 'design' rule.

>
>
>
> Makes sense.
>
>
> Paul...

Provided you don't do anything with a database you couldn't do with 3x5 cards.

Anyone that "needs" Oracle would break such nonsense.

-- 
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 Dec 17 2003 - 02:21:54 CST