Middleware based Data Replication providing Snapshot Isolation

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 tuplelevel 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-copysnapshot-isolation" as long as the underlying database replicas provide snapshot isolation. We have implemented our appr...

• Type: Conference
• Year: 2005
• Where: SIGMOD
• Authors: Yi Lin, Bettina Kemme, Marta Patiño-Martínez, Ricardo Jiménez-Peris
• Keywords: Database, Database Replicas, Popular Snapshot Isolation, PostgreSQL Replicas, SIGMOD 2005