Multi-Version Concurrency Control

Multi-Version Concurrency Control

(database)
(MVCC) An advanced technique for improving multi-user database performance.

The main difference between multiversion and lock models is that in MVCC locks acquired for querying (reading) data don't conflict with locks acquired for writing data and so reading never blocks writing and writing never blocks reading.

This technique is used in the free software database PostgreSQL.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)
Mentioned in ?
References in periodicals archive ?
Oracle Berkeley DB Release 4.5 now supports multi-version concurrency control, non-stop upgrades for replicated environments and a pre-built replication framework to simplify development of highly available applications.
* Multi-Version Concurrency Control -- improves performance of highly concurrent, mixed read/write systems by giving each user their own "snapshot" of the database and managing concurrent changes by many users.
Some of the topics covered are: Cache Friendly Web, The Apache Toolbox, MySQL Best Practices, Internationalization and Localization with PHP, Choosing a Templating System, PostgreSQL's Multi-Version Concurrency Control, Embedded and Linux.
"The Linux Web server CD bookshelf, version 2.0"

Encyclopedia browser ?
Full browser ?