Data Preservation and Concurrency Management in Distributed Database

Abstract– A decentralized database has the ability to be hosted anywhere, including the Internet, the intranets or extranets of a company, or even on workstations that are dispersed around the company itself. There is also the potential that information is stored on servers that are a part of a network that is well organized. This is another option available to you. Because the information that distributed databases keep is dispersed across several computers, they have the potential to increase productivity at remote work sites. This is because distributed databases store data in a manner that is decentralized. This is because the data is stored in distributed databases in a decentralized form, which is the reason for this result. As opposed to being the only reason, the justification for this is that data storage makes it possible for transactions to be carried out on multiple workstations rather than just one. User data privacy has become a major worry over the past few years as a direct result of the proliferation of distributed databases, which are the technology that is currently considered to be the most cutting edge. This is a direct consequence of the widespread implementation of distributed database systems. On a regular basis, comprehensive inspections as well as routine maintenance must be performed on the system’s access control and general integrity. This is an imperative necessity. In the following paragraphs, we will discuss a number of solutions to the problem of data loss, all of which are based on the characteristics of distributed database systems. Each of these solutions has its own advantages and disadvantages. Multilayer access control, concurrent access, reliability, integrity, and recovery are some of the qualities that fall under this category. The fundamental timestamp method, the distributed two phase locking protocol (2PL), the distributed pessimistic protocol, and the Deadlock algorithm will be the primary foci of this research into concurrency control-based algorithms.