Logical data partitioning for shared-disk database cluster

In a shared-disk database cluster, the overhead of data synchronization between nodes cannot be ignored, especially when the speed of the interconnect network is not fast enough. It is more likely to become the system bottleneck. However, most of those overhead can be avoided. This paper presents a logical data partitioning method. It can decoupling the nodes and reduce the overhead of interconnect network communication by using a data-oriented task dispatching strategy. Because the partitioning method is logical and it is easy to change for avoiding the data skew. The experiment results show that the proposed method can greatly reduce the communication data amount and improve the system performance.