2018•Menoufia Journal of Electronic Engineering ResearchRequires access

Improvement of Concurrent Transactions Performance via Database Locking Level Reduction

Marwa Mohamed, Mohammed Badawy, Ayman El‐Sayed

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.

About this research paper

What this paper is about

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Rollback, Computer science, Concurrency control, Concurrency, Database, Database transaction, Optimistic concurrency control, Reduction (mathematics)