Re: IBM Debunks Oracle's MultiVersion Read Consistency ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Apr 2003 08:39:08 -0700
Message-ID: <2687bb95.0304210739.2c65a4b@posting.google.com>

Robert Allen <rallen_at_NOSPAMOKhgi.com> wrote in message news:<b_yoa.380076$HU.52078_at_news.easynews.com>...
> http://www-
> 3.ibm.com/software/data/pubs/papers/readconsistency/readconsistency.pdf
>
> They raise some good points. Is it really as efficient as IBM suggests?
> What are the advantages that MVRC provide?

The example on page 7 is flawed. The reservation would require an update statement and any decent design is going to code the where clause to require that the seat be unreserved, that is, open before updating. Otherwise, it is just bad code because you a doing a blind update.

IMHO -- Mark D Powell -- Received on Mon Apr 21 2003 - 10:39:08 CDT