Re: Changing isolation level? ++ scenarios

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 05 Dec 2003 14:01:54 -0800
Message-ID: <1070661749.195771@yasure>

Joel Garry wrote:

> vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0312042357.5c158776_at_posting.google.com>...
>

>>The bottom line IMO is information. Provide the business with
>>information in order for them to make their decisions. Isolation
>>levels are not an issue - not if you use Oracle correctly and not if
>>you design your app & database correctly.

>
>
> That's correct as far as it goes, but one of the OP's points was that
> it was designed correctly, and has been proven in the business for
> years. So he's asking how to use Oracle correctly to do what has been
> designed correctly, and unfortunately the answer is as hjr pointed
> out. Another way of saying it is, Oracle's design tradeoffs make this
> particular issue difficult to work with using Oracle's normal design
> constraints.
>
> jg
> --
> @home.com is bogus.
> The fan hits the crap:
> http://www.cnn.com/2003/US/West/12/04/blimp.crash/index.html The
> "ground" they refer to was actually a pile of manure.

I completely disagree with your analysis. Turn the situation around and you'll see why.

Suppose the original application had been built in Oracle where is was designed to be compatible with reads not blocking writes, writes not blocking reads, no lock escallation, etc. It too would work perfectly.

Then you would try to rehost on another RDBMS and you'd have the exact same complaint.

The point is not that one is right and one wrong. Not that one is better and one worse. Rather that each is different and intelligent people read the Concepts books, read the Architecture books, and make modifications to optimize their work for the tool they are using. Same as there is nothing that makes screws better than nails but you won't get very far trying to get nails into a 2x4 with a screwdriver.

-- 
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 Fri Dec 05 2003 - 16:01:54 CST