Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: MVCC implementation

Re: MVCC implementation

From: Paul Mansour <paul_at_carlislegroup.com>
Date: 26 Jul 2006 13:44:42 -0700
Message-ID: <1153946682.831609.168970@h48g2000cwc.googlegroups.com>


Marshall wrote:
> Hi all,
>
> Am I correct in regarding MVCC as pretty much the state of the art
> for relational implementation? (I know we hear things about TRM
> but until there's more published it doesn't seem evaluable.)
>
> Are there any difficulties associated with MVCC implementations
> supporting nested transactions?
>
> Any good references for reading about MVCC implementation?
> It's not clear to me how it works. Googling for it is doesn't get
> me any good references; mostly manuals for SQL products
> that support it. I'm interested in learning about how to code
> one up.

Marshall,

Here is a paper that discusses MVCC with respect to Firebird which may be of use:

http://www.firebirdsql.org/doc/whitepapers/fb_vs_ibm_vs_oracle.htm

Also, a while back it dawned on me that MVCC and transaction time support could be viewed as exactly the same problem, but on different scales (I'm working on a project that exploits this) Obviously I'm not the first to realize this, as can be verified by Immortal DB, a Microsoft project, which makes interesting reading for those interested in MVCC:

http://research.microsoft.com/db/immortaldb/ Received on Wed Jul 26 2006 - 15:44:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US