Adaptive concurrency control for distributed database systems
A distributed database system needs a concurrency control mechanism to maintain consistency of the database in presence of concurrent execution of transactions. While there has been a proliferation of proposed concurrency control mechanisms, there are few studies that compare performance of various mechanisms. Even fewer are the studies that evaluate performance of concurrency control mechanisms under different and changing environments. This research deals with the latter aspect. A distributed database environment is characterized by four sets of parameters: network parameters, failure parameters, transaction parameters, and database parameters. The two main goals of this research are: (1) evaluate the effect on the performance due to the changes in various parameters, and (2) propose adaptive mechanisms that attempt to minimize the performance degradation in changing environment. The performance is studied in context of relaxing three important assumptions made in most of the earlier research. These assumptions are: (1) constant transmission time, (2) no failures, and (3) identical transactions. There is no comprehensive work devoted to the second goal. Three adaptive schemes are proposed to deal with the changes in four sets of parameters.
- Research Organization:
- Ohio State Univ., Columbus (USA)
- OSTI ID:
- 5568828
- Country of Publication:
- United States
- Language:
- English
Similar Records
Concurrency control and recovery in database systems
Performance of update algorithms for replicated data in a distributed database