Concurrency control in database structures with relaxed balance

  • Authors:
  • O. Nurmi;E. Soisalon-Soininen;D. Wood

  • Affiliations:
  • Institut fur Angewandte Informatik, und Formale Beschreibungsverfahren, Universitat Karlsruhe, Postfach 6380, D-7500 Karlsruhe 1, West Germany;Institut fur Angewandte Informatik, und Formale Beschreibungsverfahren, Universitat Karlsruhe, Postfach 6380, D-7500 Karlsruhe 1, West Germany;Data Structuring Group, Department of Computer Science, University of Waterloo, Waterloo, Ontario N2L 3G1, Canada

  • Venue:
  • PODS '87 Proceedings of the sixth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
  • Year:
  • 1987

Quantified Score

Hi-index 0.00

Visualization

Abstract

We consider the separation of rebalancing from updates in several database structures, such as B-trees for external and AVL-trees for internal structures. We show how this separation can be implemented such that rebalancing is performed by local background processes. Our solution implies that even simple locking schemes (without additional links and copies of certain nodes) for concurrency control are efficient in the sense that at any time only a small constant number of nodes must be locked.