A Novel HVgP and OLBP approach in Distributed Transaction Partitioning-Reference-Cited by-同舟云学术

A Novel HVgP and OLBP approach in Distributed Transaction Partitioning

Published:2022-08-23 Issue: Volume: Page:
ISSN:
Container-title:
language:
Short-container-title:

Author:

R.D.Bharati R.D.Bharati¹,V.Z.Attar V.Z.Attar¹

Affiliation:

1. College of Engineering,Pune

Abstract

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.

Publisher

Research Square Platform LLC

Reference29 articles.

1. Waseem, Q., Maarof, M.A., Idris, M.Y., Nazir: A Taxonomy and Survey of Data Partitioning Algorithms for Big Data Distributed Systems. In Micro-Electronics and Telecommunication Engineering pp. 447–457 (2020)

2. Bharati, R.D., Attar, V.Z.: Performance Analysis of Scalable Transactions in Distributed Data Store”. In: Smart Innovation, Systems and Technologies, vol. 303, pp. 542–548. Springer (2022)

3. Curino, C., Jones, E., Zhang, Y., Madden, S.: “Schism: A workload-driven approach to database replication and partitioning,” Proc. VLDB Endow., vol. 3, no. 1, pp. 48–57 (2010)

4. Zhang, M., Zhuo, Y., Wang, C., Gao, M., Wu, Y., Chen, K., Kozyrakis, C., Qian, X.: February. GraphP: Reducing communication for PIM-based graph processing with efficient data partition. In IEEE International Symposium on High Performance Computer Architecture (HPCA) pp. 544–557 (2018)

5. Haneen, A., Noraziah, A., Gupta, R., Fakherldin, M.: Adv. Sci. Lett. 23, 11101–11104 (2017). Review on Data Partitioning Strategies in Big Data Environment