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: Indexes and Logical design

Re: Indexes and Logical design

From: vc <boston103_at_hotmail.com>
Date: 12 Sep 2005 05:44:43 -0700
Message-ID: <1126529083.324877.213860@g49g2000cwa.googlegroups.com>

Christopher Browne wrote:
[...]
[VC]
> > Besides, sequential retrieval for a read/write transaction requires locks on
> > the entire table, which results in coarser locks and degraded concurrency.
>
> Not necessarily; alternative mechanisms exist, and are actively used.
>
> Pretty well any of the database systems still undergoing active
> development offer some variation of MultiVersion Concurrency Control
> (MVCC) where updates lead to creating new versions of tuples, which
> allows the reads, at least, to not require any locks...

Sorry, regardings locks, I should have made it clear that I was answering in the context of Rdb/VMS that does not have MVCC. The little known Rdb/ELN, of which Interbase is a cousin, does implement MVCC and your argument holds there.

> --
> (reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
> http://cbbrowne.com/info/
> If we were meant to fly, we wouldn't keep losing our luggage.
Received on Mon Sep 12 2005 - 07:44:43 CDT

Original text of this message

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