SERIALIZABILITY OF CONCURRENT DATA BASE UPDATES

  • Authors:
  • C. H. Papadimitriou

  • Affiliations:
  • -

  • Venue:
  • SERIALIZABILITY OF CONCURRENT DATA BASE UPDATES
  • Year:
  • 1979

Quantified Score

Hi-index 0.00

Visualization

Abstract

A sequence of interleaved user transactions in a data base system may not be serializable, i.e., equivalent to some sequential execution of the individual transactions. Using a simple transaction model we show that recognizing the transaction histories which are serializable is an NP-complete problem. We therefore introduce several efficiently recognizable subclasses of the class of serializable histories; most of these subclasses correspond to serializability principles existing in the literature and used in practice. We also propose two new principles which subsume all previously known ones. We give necessary and sufficient conditions for a class of histories to be the output of an efficient history scheduler, these conditions imply that there can be no efficient scheduler that outputs all of serializable histories studies above have an efficient scheduler. Finally, we show how our results can be extended to far more general transaction models, to transactions with partly interpreted functions, and to distributed data base systems.