Re: Idea for concurrent transactions

From: --CELKO-- <joe.celko_at_northface.edu>
Date: 10 Mar 2004 10:25:11 -0800
Message-ID: <a264e7ea.0403101025.5f00e79d_at_posting.google.com>


>> Anyone have any references to papers that describe MVCC? <<

There should be something from Jim Grey, sicne he was one of the big players in optmistic concurrency control and there is ATOMIC TRANSACTION by Lynch, et al (ISBN 1-55860-104-X).

A third approach from Unisys was logical concurrency control; basically, the system sets up a queue of jobs, parses their predicates, find a subset of the jobs that do not interfere with each other (or perhaps can benefit by sharing data, like marerialized views), and lets them into the database at the same time. I have not seen any research papers in years on it, tho. Received on Wed Mar 10 2004 - 19:25:11 CET

Original text of this message