EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems

Muhammad Usman Younus, Muhammad Shoaib, Kalsoom Safdar, Abdul Basit Dogar

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).

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →