A simulation model for the primary copy strategy in distributed INGRES

Abstract

In distributed INGRES, the primary copy strategy based on two-phase locking is used to solve the concurrency control (cc) problem. To observe the behaviors of the transactions in distributed INGRES, a simulation model is proposed and a simulation is conducted in this paper. Furthermore, to observe how the primary copy sites for fragments influence the performance of distributed INGRES, we derive a method to select the primary copy sites such that the system has shorter average processing time per transaction, higher throughput, and fewer deadlocks. The experimental results obtained from the simulation show that the primary copy sites selected by the method generate the best results under low conflict ratio or long inter-arrival time.