Impact of workload partitionability on the performance of coupling architectures for transaction processing

Abstract

This paper presents an analytical study on the robustness (in terms of performance) of three coupling architectures for transaction processing, namely Shared Nothing (SN), Shared Disk (SD) and Shared Intermediate Memory (SIM), where a shared intermediate level of memory, which is at the next level to the matn memory in the storage hierarchy, is introduced. Affinity clustering of workload, 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. However, partitioning the workload based on affinity and at the same time balancing the load in each cluster is a difficult task, and some times cannot be achieved. This paper investigates the impact of affinity clustering on the performance of these three different architectures under various types of workloads.