Serializability of nested transactions in multidatabases


Halici U., Arpinar B., Dogac A.

DATABASE THEORY - ICDT'97, vol.1186, pp.321-335, 1997 (SCI-Expanded) identifier

  • Publication Type: Article / Article
  • Volume: 1186
  • Publication Date: 1997
  • Journal Name: DATABASE THEORY - ICDT'97
  • Journal Indexes: Science Citation Index Expanded (SCI-EXPANDED), Scopus, Compendex, EMBASE, MathSciNet, Philosopher's Index, zbMATH
  • Page Numbers: pp.321-335
  • Middle East Technical University Affiliated: Yes

Abstract

The correctness of nested transactions for multidatabases differs from that of flat transactions in that, for nested transactions the execution order of siblings at each related site should also be consistent. In this paper we first propose a simple but powerful theory for the serializability of nested transactions in multidatabases and then a technique called Nested Tickets Method for Nested transactions (NTNT). The NTNT technique provides correctness of nested transactions in multidatabases without violating the local autonomy of the participating DBMSs. The algorithm is fully distributed, in other words there is no central scheduler. The correctness of the NTNT technique is proved by using the developed theory.