A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems
International Journal of Innovations in Science and Technology · 20.01.2026 · 162
DOI: 10.33411/ijist/1754 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal of Innovations in Science and Technology, online erschienen am 20.01.2026. Verfasst von Muhammad Usman Younus und 3 weiteren Autor:innen. Die Arbeit nennt 23 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Distributed Database Management Systems (DDBMSs) require effective data allocation techniques to ensure scalability, availability, and performance in distributed systems of geographically decentralized nodes. The traditional fragmentation procedures fail to consider the dynamic access frequency and attribute locality, leading to increased query costs and storage overhead. In this paper, we develop a new Derived Horizontal Fragmentation method, called MCRUD, that aims to optimise fragment placement by incorporating attribute locality and access frequency into the fragmentation process. The proposed model was tested and applied in a simulated distributed database environment, and its performance was compared with that of conventional horizontal fragmentation techniques. The metrics used to measure performance included query response time, storage overhead, data transfer rate, and computation time. Experimental findings show that the MCRUD method significantly improves system performance by reducing data retrieval time and data storage redundancy, without affecting data consistency or availability. The results show that the proposed fragmentation strategy improves the scalability and load balancing in the distributed database systems. MCRUD model offers a powerful data distribution mechanism that can be applied to a large-scale distributed environment and optimised to adapt to workload and modify database optimisation in future studies.
Zitieren
APA
Younus, M. U., Shoaib, M., Safdar, K., & Dogar, A. B. (2026). A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems. International Journal of Innovations in Science and Technology, 162. https://doi.org/10.33411/ijist/1754
Vancouver
Younus MU, Shoaib M, Safdar K, Dogar AB. A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems. International Journal of Innovations in Science and Technology. 2026:162. doi:10.33411/ijist/1754
BibTeX
@article{Younus2026,
author = {Younus, Muhammad Usman and Shoaib, Muhammad and Safdar, Kalsoom and Dogar, Abdul Basit},
title = {A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems},
journal = {International Journal of Innovations in Science and Technology},
year = {2026},
pages = {162},
doi = {10.33411/ijist/1754}
}
EUVIMED