ON DEFERRED CONSTRAINTS IN DISTRIBUTED DATABASE SYSTEMS

 



ON DEFERRED CONSTRAINTS IN DISTRIBUTED DATABASE SYSTEMS

Yousef J. Al-Houmaily Department of Computer and Information Programs, Institute of Public Administration, Riyadh, Saudi Arabia

ABSTRACT

An atomic commit protocol (ACP) is a distributed algorithm used to ensure the atomicity property of transactions in distributed database systems. Although ACPs are designed to guarantee atomicity, they add a significant extra cost to each transaction execution time. This added cost is due to the overhead of the required coordination messages and log writes at each involved database site to achieve atomicity. For this reason, the continuing research efforts led to a number of optimizations that reduce the aforementioned cost. The most commonly adopted optimizations in the database standards and commercial database management systems are those designed around the early release of read locks of transactions. In this type of optimizations, certain participating sites may start releasing the read locks held by transactions before they are fully terminated across all participants. Hence, greatly enhancing concurrency among executing transactions and, consequently, the overall system performance. However, this type of optimizations introduces possible “execution infections” in the presence of deferred consistency constraints; a devastating complication that may lead to non-serializable executions of transactions. Thus, this type of optimizations could be considered useless, given the importance of preserving the consistency of the database in presence of deferred constraints, unless this complication is resolved in a practical and efficient manner. This is the essence of the “unsolicited deferred consistency constraints validation” mechanism presented in this paper.

KEYWORDS

Atomic Commit Protocols, Database Recovery, Database Infection, Database Systems, Distributed Transaction Processing, Two-Phase Commit, Voting Protocols

Full Text: http://airccse.org/journal/ijdms/papers/5613ijdms01.pdf

Volume Link: http://airccse.org/journal/ijdms/current2013.html

Comments

Post a Comment

Popular posts from this blog

3rd International Conference on Computer Science, Engineering and Artificial Intelligence (CSEAI 2025)

Image
 * Registration is currently open * Call for Research Papers!!! Free – Extended Paper will be published as free of cost. 3rd International Conference on Computer Science, Engineering and Artificial Intelligence (CSEAI 2025)   May 30 ~ 31, 2025, Virtual Conference Submission Deadline: January 25, 2025 Submission System Link:  https://cseai2025.org/submission/index.php Contact us: Here's where you can reach us : cseai@cseai2025.org or cseaiconf@gmail.com For More details visit here: https://cseai2025.org/index #computerscience #computersciencemajor #computersciencejoke #computersciencehumor #computerscienceforall #computersciencestudent #computerscienceengineering #computerscienceacademy #computersciencemajorproblems #computersciences #datamining #dataminingfordummies #internetofthings #iot #iota #iotd #iotaphitheta #iotworld #iotiran #iotsecurity #iotnews #iotas #iotmcz #ioteeilmare #iotifolecce #iotproject #iothinks #iotweek #iotproducts #iotsolutions #iotafitness #iotiam...
Read more

A REVIEW OF THE USE OF R PPROGRAMMING FOR DATA SCIENCE RESEARCH IN BOTSWANA

Image
  International Journal of Database Management Systems (IJDMS) IJDMS is indexed World Journal Clout Index (WJCI) ISSN: 0975-5705 (Online); 0975-5985 (Print) http://airccse.org/journal/ijdms/index.html A REVIEW OF THE USE OF R PPROGRAMMING FOR DATA SCIENCE RESEARCH IN BOTSWANA Simisani Ndaba Department of Computer Science, University of Botswana, Gaborone, Botswana https://aircconline.com/ijdms/V15N1/15123ijdms01.pdf
Read more

HYBRID ENCRYPTION ALGORITHMS FOR MEDICAL DATA STORAGE SECURITY IN CLOUD DATABASE

Image
  HYBRID ENCRYPTION ALGORITHMS FOR MEDICAL DATA STORAGE SECURITY IN CLOUD DATABASE Fenghua Zhang1，Yaming Chen2，Weiming Meng3 and Qingtao Wu4 1Computer Technology, Henan University of Science and Technology, Luo Yang, China 2,3Computer Science and Technology, Henan University of Science and Technology, Luo Yang, China 4Professor, Henan University of Science and Technology, Luo Yang, China ABSTRACT Cloud database are derivatives of Cloud computing. At present, most medical institutions store data in cloud database. Although the cloud database improves the efficiency of use, it also poses a huge impact and challenge to the secure storage of data. The article proposes a hybrid algorithm to solve the data security problem in the hospital cloud database. First, the AES algorithm is improved. The improved algorithm is called P-AES algorithm. The P-AES algorithm is then combined with the RSA algorithm, called a hybrid algorithm. The experimental results show that the hybrid enc...
Read more