A Novel HVgP and OLBP approach in Distributed Transaction Partitioning

Abstract

Data partitioning acts an important role in Online Transaction Processing (OLTP) to enhance their performance and scalability. Partitioning is important in OLTP based systems due to the increase of user populations and online transactions. Nowadays, providing scalable and reliable data organization is the main aim of database researchers. This work presented an innovative data partitioning approach and optimized load balancing for scalable transactions. Initially, the Hybrid Vertical-graph partitioning (HVgP) approach is utilized for appropriate data partitioning. After the process of data partitioning, the partitions efficiency and the average workload parameters are computed and their corresponding weight factor is computed. Subsequently, Optimized Improved Load Balancing (OLBP) algorithm is utilized for scalable OLTP data transactions on distributed database. Here, the estimated weight factor is updated for effective load balancing with data partitions. The presented approach is appropriate for various online data transaction applications. The quality of the presented approach is examined using TPC-E OLTP benchmark dataset. The performance of the improved approach is examined with the different existing approaches and proved the significant enhancement in different performance metrics like Throughput, Response time, distributed transactions, and CPU utilization.