Optimistic concurrency control revisited

Arbeitspapier

Several years ago optimistic concurrency control gained much attention in the database community. However, two-phase locking was already well established, especially in the relational database market. Concerning traditional database systems most developers felt that pessimistic concurrency control might not be the best solution for concurrency control, but, a well-known and accepted one. With the work on new generation database systems, however, there has been a revival of optimistic concurrency control (at least a partial one). This paper will reconsider optimistic concurrency control. It will lay bare the shortcomings of the original approach and present some major improvements. Moreover, several techniques will be presented which especially support read transactions with the consequence that the number of backups can be decreased substantially. Finally, a general solution for the starvation problem is presented. The solution is perfectly consistent with the underlying optimistic approach.

Angaben zum Objekt

• Sprache: Englisch

Verweise und Beziehungen

• Erschienen in: Series: Arbeitsberichte des Instituts für Wirtschaftsinformatik ; No. 30

Klassifikation und Themen

• Klassifikation: Management

Beteiligte, Orts- und Zeitangaben

• Ereignis: Geistige Schöpfung
• (wer): Unland, Rainer
• Ereignis: Veröffentlichung
• (wer): Westfälische Wilhelms-Universität Münster, Institut für Wirtschaftsinformatik
• (wo): Münster
• (wann): 1994

Weitere Informationen

• Handle: http://hdl.handle.net/10419/59331
• Letzte Aktualisierung: 10.03.2025, 11:43 MEZ