Abstract
In this paper, we present an optimistic concurrency control solution. The proposed solution represents an excellent blossom in the concurrency control field. It deals with the concurrency control anomalies, and, simultaneously, assures the reliability of the data before read-write transactions and after successfully committed. It can be used within the distributed database to track data logs and roll back processes to overcome distributed database anomalies. The method is based on commit timestamps for validation and an integer flag that is incremented each time a successful update on the record is committed. We show that this method overcomes inefficient taken methods (i.e. unnecessary restarts) in order to improve the performance and to increase productivity. Moreover, the method includes information about the time-stamping of transactions and flagging successfully updated data in the main-memory as it is proposed. Finally, the implemented work finds a need for an adaptive and an integrated concurrency control method in distributed database systems. Thus, a new optimistic concurrency control method is presented in this paper where it is expected to produce correct and reliable results.
