Locking performance in centralized databases
ACM Transactions on Database Systems (TODS)
A benchmark of NonStop SQL on the debit credit transaction
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
A performance analysis of the gamma database machine
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
Centralized concurrency control methods for high-end TP
ACM SIGMOD Record
Two-phase locking performance and its thrashing behavior
ACM Transactions on Database Systems (TODS)
ACM Transactions on Database Systems (TODS)
Parallelism and its price: a case study of nonstop SQL/MP
ACM SIGMOD Record
Principles of transaction processing: for the systems professional
Principles of transaction processing: for the systems professional
The notions of consistency and predicate locks in a database system
Communications of the ACM
Locking Performance in a Shared Nothing Parallel Database Machine
IEEE Transactions on Knowledge and Data Engineering
Prototyping Bubba, A Highly Parallel Database System
IEEE Transactions on Knowledge and Data Engineering
Distributed Concurrency Control Based on Limited Wait-Depth
IEEE Transactions on Parallel and Distributed Systems
Proceedings of the 2nd International Workshop on High Performance Transaction Systems
GAMMA - A High Performance Dataflow Database Machine
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
Hybrid-Range Partitioning Strategy: A New Declustering Strategy for Multiprocessor Database Machines
VLDB '90 Proceedings of the 16th International Conference on Very Large Data Bases
Performance Evaluation of Parallel Transaction Processing in Shared Nothing Database Systems
PARLE '92 Proceedings of the 4th International PARLE Conference on Parallel Architectures and Languages Europe
Modeling and Analysis of Transaction Processing Systems
Performance Evaluation of Computer and Communication Systems, Joint Tutorial Papers of Performance '93 and Sigmetrics '93
| Hi-index | 0.00 |
We study the system performance affected by Degree of Declustering (DD) and the additional overheads in shared-nothing parallel transaction processing systems with the widely used two-phased locking (2PL) concurrency control method by simulation. We show that for the environment of high resource contention, a large DD is beneficial. For a system in the environment of low resource contention, if we have infinite frontend resource, a large DD is beneficial; otherwise a large DD would degrade system performance. It is shown that as the level of the resource contention in disks decreases, the additional overhead of parallelism increases. Furthermore, it is shown that the functions attached to frontend nodes affect system performance to a significant degree for shared-nothing parallel TP systems. These results provide insights for improving performance of shared-nothing parallel transaction processing systems.