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

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

Date: Thu, 29 Jan 2004 21:57:10 -0800

Stu Charlton wrote:
>>So while I will gladly acknowledge a communication gap I still can't get
>>past thinking what you guys are proposing is a logical impossibility. If
>>you disagree, and I suspect you do/will, then please provide an example
>>of how you could use packages and sequences in Oracle and meet your
>>stated objective.
>
>
> Ok.
>
> Requirement: A web-page that displays all of the employees in a given
> department.

> Cheers
> Stu

First let me say you have my admiration. You put in effort and made an
attempt at answering my query. But the problem is that your example very
carefully, perhpas even artfully, dodged the issue I put in front of you
like a charging rhinoceros. What I asked was "please provide an example
of how you could use PACKAGES and SEQUENCES in Oracle and meet your
stated objective" ... and you didn't.

By selecting as your example: "A web-page that displays" you eliminated
anything having to do with sequences. What I was trying to get you to
deal with was issues related to insert, update, and delete. Issues that
involve sequences but also the transaction and locking models that are
totally different between commercial database products.

So the response while impressive is unsatisfactory in that it didn't
address the issue. And the stuff about Project Marvel ... as marvelous
as it may be ... has nothing to do with the back-end database ...
HTML_DB is a front-end tool. Could I impose upon you to try again this
time addressing this issues around transaction processing.

I still content that you can't have your cake and eat it too.

Thanks. 

-- 
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)