Improvement of Concurrent Transactions Performance via Database Locking Level Reduction

Abstract

A concurrency in database designed to implement multipletransactions on the same database simultaneously that mayproduce on a problem called transactions conflict. Theperformance improvement of web-based database transactionsis through applying concurrency. Previous proposals to applyconcurrency lead to huge problems such transactions conflict.Transactions Conflict leads to rollback some transactions frommultiple concurrent transactions to complete the others. Thispaper proposes an algorithm to solve this obstacle byimplementing locking on the cell level. This algorithm improvesthe throughput and committing transactions by about 42% and36% respectively.