Managing Transaction Conflicts in Middleware-based Database Replication Architectures

Author

Munoz-Escoi, F.D. ; Pla-Civera, J. ; Ruiz-Fuertes, M.I. ; Irun-Briz, L. ; Decker, H. ; Armendáriz-IHigo, J.E. ; De Mendívil, J. R González

Author_Institution

Inst. Tecnologico de Informatica, Univ. Politecnica de Valencia

fYear

2006

fDate

2-4 Oct. 2006

Firstpage

401

Lastpage

420

Abstract

Database replication protocols need to detect, block or abort part of conflicting transactions. A possible solution is to check their writesets (and also their readsets in case a serialisable isolation level is requested), which however burdens the consumption of CPU time. This gets even worse when the replication support is provided by a middleware, since there is no direct DBMS support in that layer. We propose and discuss the use of the concurrency control support of the local DBMS for detecting conflicts between local transactions and writesets of remote transactions. This allows to simplify many database replication protocols and to enhance their performance

Keywords

concurrency control; middleware; replicated databases; transaction processing; concurrency control; database replication protocols; local transactions; middleware-based database replication architectures; remote transactions; transaction conflict management; Abortion; Concurrency control; Data structures; Delay systems; Maintenance; Middleware; Multicast protocols; Testing; Transaction databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Reliable Distributed Systems, 2006. SRDS '06. 25th IEEE Symposium on

Conference_Location

Leeds

ISSN

1060-9857

Print_ISBN

0-7695-2677-2

Type

conf

DOI

10.1109/SRDS.2006.29

Filename

4032502