Improving Concurrency Control in Distributed Databases with Predeclared Tables

  • Authors:
  • Azzedine Boukerche;Terry Tuck

  • Affiliations:
  • -;-

  • Venue:
  • Euro-Par '01 Proceedings of the 7th International Euro-Par Conference Manchester on Parallel Processing
  • Year:
  • 2001

Quantified Score

Hi-index 0.00

Visualization

Abstract

In this paper we present a concurrency control algorithm and recovery protocol for distributed databases that produces a schedule that is equivalent to that of a temporally ordered serial schedule. The algorithm is intended to be somewhat practical from the standpoints of both burden on the application developer and realism of the network environment. Accordingly, it allows transactions to be received out of order within a window of tolerance. Moreover, it doesn't require declaration of readsets, and writesets are declared simply at the table level and without predicates. This paper discusses the algorithm, present its analytical studies, and report on the simulation experiments we carried out to evaluate the performance of ours scheme. Our results clearly indicate that with predeclared tables, performance is greatly improved as compared with that from the conservative MVTO algorithm.