IEEE Transactions on Knowledge and Data Engineering · 1990 · 88 citations · 25 references
ComputingComputer ScienceComputer SystemsDatabasesDistributed SystemsParallel ComputingConcurrency ControlConsistency ModelsData ReplicationDistributed Database ArchitectureDistributed DatabasesDistributed TransactionsConsistency In Distributed DatabasesContention AnalysisOptimistic ReplicationPessimistic Concurrency ControlPessimistic ReplicationResource ContentionResource Contention AnalysisResponse Time
The authors develop an approximate analytical model to study the tradeoffs of replicating data in a distributed database environment. Several concurrency control protocols are considered, including pessimistic, optimistic, and semi-optimistic protocols. The approximate analysis captures the effect of the protocol on hardware resource contention and data contention. The accuracy of the approximation is validated through detailed simulations. It is found that the benefit of replicating data and the optimal number of replicates are sensitive to the concurrency control protocol. Under the optimistic and semi-optimistic protocols, replications can significantly improve response time with an additional MIPS (million instructions per second) requirement to maintain consistency among the replicates. The optimal degree of replication is further affected by the transaction mix (e.g. the fraction of read-only transactions), the communications delay and overhead, the number of distributed sites, and the available MIPS. Sensitivity analyses have been carried out to examine how the optimal degree of replication changes with respect to these factors.< <ETX xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">></ETX>
25
Locking performance in centralized databases
Y. C. Tay, Nathan Goodman, R. Suri · ACM Transactions on Database Systems · 1985 · 146 citations · Full text
A mean value performance model for locking in databases
Y. C. Tay, Rajan Suri, Nathan Goodman · Journal of the ACM · 1985 · 115 citations · Full text