Please use this identifier to cite or link to this item: https://hdl.handle.net/10419/59331 
Authors: 
Year of Publication: 
1994
Series/Report no.: 
Arbeitsberichte des Instituts für Wirtschaftsinformatik No. 30
Publisher: 
Westfälische Wilhelms-Universität Münster, Institut für Wirtschaftsinformatik, Münster
Abstract: 
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.
Document Type: 
Working Paper

Files in This Item:
File
Size





Items in EconStor are protected by copyright, with all rights reserved, unless otherwise indicated.