An introduction to database systems: vol. I (4th ed.)
An introduction to database systems: vol. I (4th ed.)
On multisystem coupling through function request shipping
IEEE Transactions on Software Engineering
A Performance Comparison of Multimicro and Mainframe Database Architectures
IEEE Transactions on Software Engineering
Integrated Concurrency-Coherency Controls for Multisystem Data Sharing
IEEE Transactions on Software Engineering
Multisystem Coupling by a Combination of Data Sharing and Data Partitioning
IEEE Transactions on Software Engineering
IBM Systems Journal
An approximate analysis of the LRU and FIFO buffer replacement schemes
SIGMETRICS '90 Proceedings of the 1990 ACM SIGMETRICS conference on Measurement and modeling of computer systems
Analytical modelling of a hierarchical buffer for a data sharing environment
SIGMETRICS '91 Proceedings of the 1991 ACM SIGMETRICS conference on Measurement and modeling of computer systems
Parallel database systems: the future of database processing or a passing fad?
ACM SIGMOD Record - Directions for future database research & development
Analysis of Hybrid Concurrency Control Schemes for a High Data Contention Environment
IEEE Transactions on Software Engineering
Performance analysis of coherency control policies through lock retention
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Crash recovery in client-server EXODUS
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
On Workload Characterization of Relational Database Environments
IEEE Transactions on Software Engineering
Performance analysis of data sharing environments
Performance analysis of data sharing environments
On the analytical modeling of database concurrency control
Journal of the ACM (JACM)
VAXcluster: a closely-coupled distributed system
ACM Transactions on Computer Systems (TOCS)
A fast general-purpose hardware synchronization mechanism
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
Performance evaluation of functional disk system with nonuniform data distribution
DPDS '90 Proceedings of the second international symposium on Databases in parallel and distributed systems
Performance of an OLTP application on symmetry multiprocessor system
ISCA '90 Proceedings of the 17th annual international symposium on Computer Architecture
Prototyping Bubba, A Highly Parallel Database System
IEEE Transactions on Knowledge and Data Engineering
The Gamma Database Machine Project
IEEE Transactions on Knowledge and Data Engineering
Analysis of Replication in Distributed Database Systems
IEEE Transactions on Knowledge and Data Engineering
Buffer Analysis for a Data Sharing Environment with Skewed Data Access
IEEE Transactions on Knowledge and Data Engineering
Performance Analysis of Buffer Coherency Policies in a Multisystem Data Sharing Environment
IEEE Transactions on Parallel and Distributed Systems
Replication Algorithms in a Remote Caching Architecture
IEEE Transactions on Parallel and Distributed Systems
Performance Evaluation of Transaction Processing Coupling Architectures for Handling System Dynamics
IEEE Transactions on Parallel and Distributed Systems
Efficient Locking and Caching of Data in the Multisystem Shard Disks Transaction Environment
EDBT '92 Proceedings of the 3rd International Conference on Extending Database Technology: Advances in Database Technology
A Performance Comparison of Two Architectures for Fast Transaction Processing
Proceedings of the Fourth International Conference on Data Engineering
A Buffer Management Model For Use In Predicting Overall Database System Performance
Proceedings of the Fifth International Conference on Data Engineering
An Analysis of Three Transaction Processing Architectures
VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Proceedings of the 7th Colloquium on Automata, Languages and Programming
Asymptotic performance of a buffer model in a data sharing environment
SIGMETRICS '94 Proceedings of the 1994 ACM SIGMETRICS conference on Measurement and modeling of computer systems
IEEE Transactions on Computers
Recovery Analysis of Data Sharing Systems under Deferred Dirty Page Propagation Policies
IEEE Transactions on Parallel and Distributed Systems
S/390 cluster technology: Parallel Sysplex
IBM Systems Journal
Cluster architectures and S/390 Parallel Sysplex scalability
IBM Systems Journal
Adaptive algorithms for managing a distributed data processing workload
IBM Systems Journal
Cluster Computing
Multimedia Caching Strategies for Heterogeneous Application and ServerEnvironments
Multimedia Tools and Applications
Performance Evaluation of Transaction Processing Coupling Architectures for Handling System Dynamics
IEEE Transactions on Parallel and Distributed Systems
IPPS '96 Proceedings of the 10th International Parallel Processing Symposium
A methodology for auto-recognizing DBMS workloads
CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Configuring buffer pools in DB2 UDB
CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
Dynamic Affinity Cluster Allocation in a Shared Disks Cluster
The Journal of Supercomputing
Is it DSS or OLTP: automatically identifying DBMS workloads
Journal of Intelligent Information Systems
Mining and modeling database user access patterns
ISMIS'06 Proceedings of the 16th international conference on Foundations of Intelligent Systems
Transaction routing in real-time shared disks clusters
ICCS'05 Proceedings of the 5th international conference on Computational Science - Volume Part III
Priority conscious transaction routing in a real-time shared disks cluster
APPT'05 Proceedings of the 6th international conference on Advanced Parallel Processing Technologies
Feasibility and performance study of a shared disks cluster for real-time processing
AIS'04 Proceedings of the 13th international conference on AI, Simulation, and Planning in High Autonomy Systems
A distance-based algorithm for clustering database user sessions
ISMIS'05 Proceedings of the 15th international conference on Foundations of Intelligent Systems
Hi-index | 0.00 |
Coupling multiple computing nodes for transaction processing has become increasingly attractive for reasons of capacity, cost, and availability. This paper presents a comparison of robustness (in terms of performance) of three different architectures for transaction processing. In the shared nothing (SN) architecture, neither disks nor memories are shared. In the shared disk (SD) architecture, all disks are accessible from all nodes, whereas in the shared intermediate memory (SIM) architecture, a shared intermediate level of memory is introduced. Coupling multiple nodes inevitably introduces certain interferences and overheads, which take on different forms and magnitudes under the different architectures. Affinity clustering, which attempts to partition the transactions into affinity clusters according to their database reference patterns, can be employed to reduce the coupling degradation under the different architectures, though in different ways. However, the workload may not be partitionable into N affinity clusters of equal size, where N is the number of nodes in the coupled system, so that the load can be evenly spread over all nodes. In addition to balancing the load, we need to maintain a large fraction of data references within the database affiliated with the affinity cluster. These become increasingly harder to achieve for large values of N. In this paper, we examine the impact of affinity on the performance of these three different coupling architectures.