| Concurrency control is one of the most important issues in database management that attracted many researches. Concurrency control not only governs the execution of transaction, but also has the significant impact on transaction processing performance. The purpose of this topic is to propose a new approach called Restricted Precedence Concurrency Control Protocol that might improve the performance of transaction processing in terms of concurrency control. The proposed protocol adopts the OCC protocol idea of having three phases, in which the checking for conflict happens at the late stage could result in abort or restart of the conflicting transaction. This protocol, however, will allow more serializable transaction to proceed and only abort transaction when it indeed violates the restricted rules of concurrency control protocol. The topic also designs and implements the protocol and conducts some experiments to verify the effectiveness of the proposed protocol. |
