Main Article Content
Abstract
Database systems play a critical role in modern society, being used by various organizations such as banks, hospitals, airlines, and internet search engines, all of which involve multiple users or computers accessing a database. Advances in technology have led to the development of large databases that store various types of data. To manage this data, new and innovative systems, such as distributed databases, have been introduced. With the use of these systems, concurrency control of transactions becomes a major concern. This research first discusses distributed database systems and then describes the algorithms used to resolve concurrency issues. After comparing these algorithms, the study concludes that ACID properties are essential for controlling transactions in databases and must be maintained.
Keywords
Article Details
Copyright (c) 2024 Reserved for Kabul University.
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
References
- S. B. N. Ramez Elmasri, Fundamentals of Database Systems, 7th ed., NJ United States of America: PEARSON, 2016.
- M. V. S. Andrew S.Tanenbaum, Distributed Systems Principles and Paradigms, 2nd ed., NJ United States of America: PEARSON, 2007.
- H. F. K. S. S. Abraham Silberschatz, Database System Concepts, 7th ed., New York: McGraw-Hill, 2019.
- C. E. B. Thomas M. Connolly, Database Systems A Practical Approach to Design, Implementation, and Management, 6th ed., Harlow, England: PEARSON, 2015.
- H. S. I. A. Qasim Abbas, "Concurrency Control in Distributed Database System," in International Conference on Computer Communication and Informatics, Coimbatore, INDIA, 2016.
- C. W. N. K. Paul Kahoro, "Concurrency Control In Distributed Databases," in United States International University Africa, Nairobi, Kenya, 2014.
- G. V. Gerhard Weikum, Transactional Information Systems Theory, Algorithms, and the Practice of Concurrency Control and Recovery, San Francisco, CANADA: Morgan Kaufmann Publishers, 2002.
- F. S. H. Saeed K. Rahimi, Distributed Database Management Systems A Practical Approach, 1st ed., NJ, United States of America: Wiley, IEEE Computer Society Press, 2011.
- H. K. Mandeep Kaur, "Concurrency Control in Distributed Database System," International Journal of Advanced Research in Computer Science and Software Engineering, vol. 3, no. 7, pp. 1444 - 1447, 2013.
References
S. B. N. Ramez Elmasri, Fundamentals of Database Systems, 7th ed., NJ United States of America: PEARSON, 2016.
M. V. S. Andrew S.Tanenbaum, Distributed Systems Principles and Paradigms, 2nd ed., NJ United States of America: PEARSON, 2007.
H. F. K. S. S. Abraham Silberschatz, Database System Concepts, 7th ed., New York: McGraw-Hill, 2019.
C. E. B. Thomas M. Connolly, Database Systems A Practical Approach to Design, Implementation, and Management, 6th ed., Harlow, England: PEARSON, 2015.
H. S. I. A. Qasim Abbas, "Concurrency Control in Distributed Database System," in International Conference on Computer Communication and Informatics, Coimbatore, INDIA, 2016.
C. W. N. K. Paul Kahoro, "Concurrency Control In Distributed Databases," in United States International University Africa, Nairobi, Kenya, 2014.
G. V. Gerhard Weikum, Transactional Information Systems Theory, Algorithms, and the Practice of Concurrency Control and Recovery, San Francisco, CANADA: Morgan Kaufmann Publishers, 2002.
F. S. H. Saeed K. Rahimi, Distributed Database Management Systems A Practical Approach, 1st ed., NJ, United States of America: Wiley, IEEE Computer Society Press, 2011.
H. K. Mandeep Kaur, "Concurrency Control in Distributed Database System," International Journal of Advanced Research in Computer Science and Software Engineering, vol. 3, no. 7, pp. 1444 - 1447, 2013.