Middleware based data replication providing snapshot isolation Export

@inproceedings{citeulike:617157, abstract = {Many cluster based replication solutions have been proposed providing scalability and fault-tolerance. Many of these solutions perform replica control in a middleware on top of the database replicas. In such a setting concurrency control is a challenge and is often performed on a table basis. Additionally, some systems put severe requirements on transaction programs (e.g., to declare all objects to be accessed in advance). This paper addresses these issues and presents a middleware-based replication scheme which provides the popular snapshot isolation level at the same tuple-level granularity as database systems like PostgreSQL and Oracle, without any need to declare transaction properties in advance. Both read-only and update transactions can be executed at any replica while providing data consistency at all times. Our approach provides what we call "1-copy-snapshot-isolation" as long as the underlying database replicas provide snapshot isolation. We have implemented our approach as a replicated middleware on top of PostgreSQL replicas. By providing a standard JDBC interface, the middleware is completely transparent to the client program. Fault-tolerance is provided by automatically reconnecting clients in case of crashes. Our middleware shows good performance in terms of response times and scalability.}, address = {New York, NY, USA}, author = {Lin, Yi and Kemme, Bettina and Marta Pati, {n}o-Mart'{i}nez and Peris, Ricardo J.}, booktitle = {SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data}, citeulike-article-id = {617157}, citeulike-linkout-0 = {http://portal.acm.org/citation.cfm?id=1066205}, citeulike-linkout-1 = {http://dx.doi.org/10.1145/1066157.1066205}, doi = {10.1145/1066157.1066205}, isbn = {1-59593-060-4}, keywords = {1sr, 2005, middlewaresnapshot, postgres, replication, sigmod, snapshot, snapshot-isolation}, location = {Baltimore, Maryland}, pages = {419--430}, posted-at = {2009-09-23 10:39:43}, priority = {2}, publisher = {ACM}, title = {Middleware based data replication providing snapshot isolation}, url = {http://dx.doi.org/10.1145/1066157.1066205}, year = {2005} }

TY - CONF ID - citeulike:617157 L3 - citeulike-article-id:617157 N2 - Many cluster based replication solutions have been proposed providing scalability and fault-tolerance. Many of these solutions perform replica control in a middleware on top of the database replicas. In such a setting concurrency control is a challenge and is often performed on a table basis. Additionally, some systems put severe requirements on transaction programs (e.g., to declare all objects to be accessed in advance). This paper addresses these issues and presents a middleware-based replication scheme which provides the popular snapshot isolation level at the same tuple-level granularity as database systems like PostgreSQL and Oracle, without any need to declare transaction properties in advance. Both read-only and update transactions can be executed at any replica while providing data consistency at all times. Our approach provides what we call "1-copy-snapshot-isolation" as long as the underlying database replicas provide snapshot isolation. We have implemented our approach as a replicated middleware on top of PostgreSQL replicas. By providing a standard JDBC interface, the middleware is completely transparent to the client program. Fault-tolerance is provided by automatically reconnecting clients in case of crashes. Our middleware shows good performance in terms of response times and scalability. CY - Baltimore, Maryland SN - 1-59593-060-4 AD - New York, NY, USA EP - 430 TI - Middleware based data replication providing snapshot isolation PB - ACM T2 - SIGMOD '05: Proceedings of the 2005 ACM SIGMOD international conference on Management of data SP - 419 KW - 1sr KW - 2005 KW - middlewaresnapshot KW - postgres KW - replication KW - sigmod KW - snapshot KW - snapshot-isolation AU - Lin, Yi AU - Kemme, Bettina AU - Marta Pati, {n}o-Mart'{i}nez AU - Peris, Ricardo PY - 2005/// UR - http://dx.doi.org/10.1145/1066157.1066205 ER -