A Secure and Optimization Based Clustering for Vertical and Horizontal Fragmentation in Distributed Database Management System

Abstract

Distributed database systems are increasingly important due to the massive data output, and their effectiveness is largely based on their design. Two key processes, fragmentation and allocation, are used to improve the efficiency and efficacy of these systems. Effective data fragmentation requires both horizontal and vertical categorization of tuples. Advanced optimization techniques are used for both fragmentations, such as the Enhanced Arithmetic Optimization (EAO) algorithm with Opposition-based Learning (OBL) and Levy Flight Distributer (LFD) for vertical fragmentation and the hybrid Aquila Optimizer (AO) with Artificial Rabbit Optimization (ARO) algorithm for horizontal fragmentation. The fragmented data is securely transmitted using the Fully Homomorphic Encryption (FHE) algorithm. The implementation is executed using the Python language, and the performance of the proposed algorithms is evaluated using different performance parameters. The execution time analysis shows that the proposed EAOA algorithm consumes 5.5 seconds for vertical fragmentation, while the hybrid AARO algorithm takes 5.9 seconds for horizontal fragmentation. The vertical fragmentation is found to be better than the horizontal one in DDBMS.