Performance evaluation of global reading of entire databases

  • Authors:
  • C. Pu;C. H. Hong;J. M. Wha

  • Affiliations:
  • AT&T Bell Labs, Middletown, NJ and Department of Computer Science, Columbia University;AT&T Bell Labs, Middletown, NJ and Department of Computer Science, Columbia University;AT&T Bell Labs, Middletown, NJ and Department of Computer Science, Columbia University

  • Venue:
  • DPDS '88 Proceedings of the first international symposium on Databases in parallel and distributed systems
  • Year:
  • 2000

Quantified Score

Hi-index 0.00

Visualization

Abstract

Using simulation and probabilistic analysis, we study the performance of an algorithm to read entire databases with locking concurrency control allowing multiple readers or an exclusive writer. The algorithm runs concurrently with the normal transaction processing (on-the-fly) and locks the entities in the database one by one (incremental). The analysis compares different strategies to resolve the conflicts between the global read algorithm and update. Since the algorithm is parallel in nature, its interference with normal transactions is minimized in parallel and distributed databases. A simulation study shows that one variant of the algorithm can read the entire database with very little overhead and interference with the updates.