The concurrency control problem in multidatabases: characteristics and solutions

  • Authors:
  • Sharad Mehrotra;Rajeev Rastogi;Yuri Breitbart;Henry F. Korth;Avi Silberschatz

  • Affiliations:
  • Department of Computer Sciences, University of Texas, Austin, TX;Department of Computer Sciences, University of Texas, Austin, TX;Department of Computer Sciences, University of Kentucky, Lexington, KY;Matsushita Information Technology Laboratory, 182 Nassau Street, third floor, Princeton, NJ;Department of Computer Sciences, University of Texas, Austin, TX

  • Venue:
  • SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
  • Year:
  • 1992

Quantified Score

Hi-index 0.00

Visualization

Abstract

A Multidatabase System (MDBS) is a collection of local database management systems, each of which may follow a different concurrency control protocol. This heterogeneity makes the task of ensuring global serializability in an MDBS environment difficult. In this paper, we reduce the problem of ensuring global serializability to the problem of ensuring serializability in a centralized database system. We identify characteristics of the concurrency control problem in an MDBS environment, and additional requirements on concurrency control schemes for ensuring global serializability. We then develop a range of concurrency control schemes that ensure global serializability in an MDBS environment, and at the same time meet the requirements. Finally, we study the tradeoffs between the complexities of the various schemes and the degree of concurrency provided by each of them.