15 research outputs found
Supporting multiple isolation levels in replicated environments
Replication is used by databases to implement reliability and provide scalability. However,
achieving transparent replication is not an easy task. A replicated database is transparent if it can
seamlessly replace a standard stand-alone database without requiring any changes to the
components of the system. Database replication transparency can be achieved if: (a) replication
protocols remain hidden for all other components of the system; and (b) the functionality of a
stand-alone database is provided.
The ability to simultaneously execute transactions under different isolation levels is a functionality
offered by all stand-alone databases but not by their replicated counterparts. Allowing different
isolation levels may improve overall system performance. For example, the TPC-C benchmark
specification tolerates execution of some transactions at weaker isolation levels in order to
increase throughput of committed transactions. In this paper, we show how replication protocols
can be extended to enable transactions to be executed under different isolation levels.
© 2012 Elsevier B.V. All rights reserved.This work has been supported by the Spanish Ministerio de Ciencia e Innovation (MICINN) and the European Regional Development Fund (ERDF/FEDER) under research grants TIN2009-14460-C03-01 and TIN2010-17193. The translation of this paper was funded by the Universitat Politecnica de Valencia, Spain.Bernabe Gisbert, JM.; Muñoz Escoí, FD. (2012). Supporting multiple isolation levels in replicated environments. Data and Knowledge Engineering. 79-80:1-16. doi:10.1016/j.datak.2012.05.001S11679-8