An improved algorithm for database concurrency control

Mohamed, M. R.; Badawy, Mohammed; El‐Sayed, Ayman

doi:10.1007/s41870-018-0240-y

Cited by 4 publications

(6 citation statements)

References 15 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In papers [1] and [2] different concurrency control techniques are proposed, which used to deal with the problems with concurrent transactions in DBMSs. 2PC, 3PC and the DFCL are the techniques that I will discuss.…”

Section: A Literature Review On Some Currency Techniquesmentioning

confidence: 99%

“…In DDBMS there are many types of fragmentation for duplicating data, these types are horizontal, vertical and hyper fragmentation; in contrast to the centralized data base system (CDBS), just one copy of the data is stored in centralized location or node [3,6]. In the database management systems Concurrency control is one of the most critical issues; execution of multiple transactions at the same time is called concurrency [2,5]. Managing the concurrent transaction badly leads to some problems; the rule of concurrency control is to ensure that the consistency and integrity constraints will not be violated.…”

Section: Introductionmentioning

confidence: 99%

“…The system will roll back the conflicted transaction to give the others to be completed. The infinite waiting of transactions for data lock to be executed is a problem called deadlock in which each transaction is waiting the other one to release its locked data item to use it [2]. The good management for execution of the concurrent transactions could lead to some advantages and enhancing the performance of the database management system these advantages like increasing the amount of throughput and reduction of waiting-time for the transactions [4,9,10].…”

Section: Introductionmentioning

confidence: 99%

“…Deadlock is a significant problem that must be resolved when several transactions are being processed at the same time. When two or more transactions need resources owned by other transactions to complete their execution on a regular basis, deadlock occurs [2].…”

Section: Introductionmentioning

confidence: 99%

See 3 more Smart Citations

A Review on Concurrency Control Techniques in Database Management Systems

Yasin

Abohany

2022

Kafrelsheikh Journal of Information Sciences

View full text Add to dashboard Cite

Conflicts, deadlock and rolled-back transactions are being considered as the most recent challenges related to executing the transaction concurrently on different environments of Database Management Systems (DBMS). More precisely, in distributed database systems, to handle and avoid these challenges, there are different techniques and protocols are utilized. In this paper, we highlight some of these techniques which includes Two-Phase Commit (2PC) protocol and Three-Phase Commit (3PC) protocol) as well as and Deadlock-Free Cell lock (DFCL) algorithm. Moreover, the paper surveys all these protocols and demonstrate the pros and cons of each techniques. Afterwards, we proposed the solution of some important problems related to concurrency control techniques in DBMS

show abstract

Section: A Literature Review On Some Currency Techniquesmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

A Review on Concurrency Control Techniques in Database Management Systems

Yasin

Abohany

2022

Kafrelsheikh Journal of Information Sciences

View full text Add to dashboard Cite

show abstract

“…Another approach is the Timestamp ordering (T/O) concurrency control scheme where an increase in timestamp is produced for serialization of transactions. These timestamps are used during conflicting operations such as reading and writing operations on a similar component, or two different write operations on a similar element [16].…”

Section: Concurrency Controlmentioning

confidence: 99%

Growth of relational model: Interdependence and complementary to big data

Shetty

Rao

Prabhu

2021

IJECE

View full text Add to dashboard Cite

A database management system is a constant application of science that provides a platform for the creation, movement, and use of voluminous data. The area has witnessed a series of developments and technological advancements from its conventional structured database to the recent buzzword, bigdata. This paper aims to provide a complete model of a relational database that is still being widely used because of its well known ACID properties namely, atomicity, consistency, integrity and durability. Specifically, the objective of this paper is to highlight the adoption of relational model approaches by bigdata techniques. Towards addressing the reason for this in corporation, this paper qualitatively studied the advancements done over a while on the relational data model. First, the variations in the data storage layout are illustrated based on the needs of the application. Second, quick data retrieval techniques like indexing, query processing and concurrency control methods are revealed. The paper provides vital insights to appraise the efficiency of the structured database in the unstructured environment, particularly when both consistency and scalability become an issue in the working of the hybrid transactional and analytical database management system.

show abstract