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 <paul_at_see.my.sig.com>
Date: Sat, 22 Jul 2006 00:13:19 +0100
Message-ID: <2bn2c255shl841apnv3hu52sd2teprduna@4ax.com>

"Marshall" <marshall.spight_at_gmail.com> wrote:

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

Take a look at the Firebird project - it uses MVCC, otherwise known as record versioning and/or record shadowing.

Paul...  

> Marshall

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.
Received on Fri Jul 21 2006 - 18:13:19 CDT

Original text of this message

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