Reliable Nested Transaction Processing for Multidatabase Systems

Issue title: Multidatabase and Interoperable Systems

Guest editors: A.R. HursonGuest Editor and M.W. BrightGuest Editor

Article type: Research Article

Authors: Kang, I.E.^{; 1} | Keefe, T.F.^{; *}

Affiliations: Department of Computer Science and Engineering, The Pennsylvania State University, University Park, PA 16802

Correspondence: [*] To whom all correspondence should be addressed.

Note: [1] Currently with GTE Laboratories Inc., Waltham, MA 02254.

Abstract: A multidatabase system (MDBS) is a system implemented on top of a collection of autonomous preexisting local database systems (LDBSs). In this paper, we show a reliable approach to nested transaction management in MDBSs. Our approach is reliable in the sense that it ensures global serializability in the face of failures. We support global nested transactions under the constraint that LDBSs only support flat transactions. We assume autonomous LDBSs which provide either a single or multiversion data manager. We adopt a deferred-update approach to replace the need for atomic commitment protocols. As a result, our approach limits the problem of indefinite blocking of local resources. This is achieved at the expense of access restrictions on some global transactions. We show how to enforce these access restrictions at a local site without modifying local application programs.

DOI: 10.3233/ICA-1995-2105

Journal: Integrated Computer-Aided Engineering, vol. 2, no. 1, pp. 49-67, 1995