Non-lock concurrency control: Difference between revisions

Revision as of 22:57, 24 February 2008

Latest revision as of 17:44, 13 June 2025

(17 intermediate revisions by 14 users not shown)

Line 1:

{{More citations needed|date=June 2025}}

In [[Computer Science]], in the field of [[database]]s, '''non-lock concurrency control''' is [[concurrency control]] method used in [[relational database]]s without using [[lock (computer science)|locking]].

(+++Applicable to all database types, not just relational +++)

In [[Computer Science]], in the field of [[database]]s, '''non-lock concurrency control''' is a [[concurrency control]] method used in [[relational database]]s without using [[lock (computer science)|locking]].

There are several non-lock concurrency control methods:

TheyThere are several non-lock concurrency control methods, which involve the use of timestamps on transaction to determine transaction priority. :

* [[Optimistic concurrency control]]

** [[Timestamp-based concurrency control]]<ref>{{Cite book |last= |first= |url=https://www.google.co.uk/books/edition/Introduction_to_Database_Systems/y7P9sa2MeGIC?hl=en&gbpv=1&dq=%22Non-lock+concurrency+control%22+-wikipedia&pg=PA330&printsec=frontcover |title=Introduction to Database Systems |date=September 2010 |publisher=Pearson Education India |isbn=978-81-317-3192-5 |page=341 |language=en}}</ref>

* [[Timestamp-based concurrency control]]

** [[MultiversionValidation-based concurrency control]]

** [[Timestamp-basedMultiversion concurrency control]]

*** [[Snapshot isolation]]

==See also==

They involve the use of timestamps on transaction to determine transaction priority.

(+++Not all these methods necessariliy use timestamps+++ Article looks redundant. +++)

(+++Validity of a separate article for this subject is questionable, since each method is unique, and not much in common. Why not an article on "non timestamp CC?" +++)

See also

* [[Concurrency pattern]]

* [[Optimistic concurrency control]] ''(should [[Optimistic concurrency control]] and Non-lock concurrency control be merged ? No. Non-lock does not imply optimistic, and vice-versa. See definition of optimistic)''

* [[InterBase]]

* [[Lock-free and wait-free algorithms]]

== References ==

[[Category:concurrency control]]

{{DEFAULTSORT:Non-Lock Concurrency Control}}

[[Category:concurrencyConcurrency control]]

[[Category:Transaction processing]]

{{Reflist}}{{Database-stub}}

{{database-stub}}