Academic Journal
A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems
| Τίτλος: | A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems |
|---|---|
| Συγγραφείς: | Younus, Muhammad Usman, Muhammad Shoaib, Kalsoom Safdar, Abdul Basit Dogar |
| Πηγή: | International Journal of Innovations in Science & Technology; Vol. 8 No. 1 (2026): Vol 8 Issue 1; 162-178 ; 2709-6130 ; 2618-1630 |
| Στοιχεία εκδότη: | 50SEA |
| Έτος έκδοσης: | 2026 |
| Θεματικοί όροι: | Horizontal Fragmentation, Distributed Database, Query Optimisation, Attribute Locality, MCRUD |
| Περιγραφή: | 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. |
| Τύπος εγγράφου: | article in journal/newspaper |
| Περιγραφή αρχείου: | application/pdf |
| Γλώσσα: | English |
| Relation: | https://journal.50sea.com/index.php/IJIST/article/view/1754/2792; https://journal.50sea.com/index.php/IJIST/article/view/1754 |
| DOI: | 10.33411/IJIST/1754 |
| Διαθεσιμότητα: | https://journal.50sea.com/index.php/IJIST/article/view/1754 https://doi.org/10.33411/IJIST/1754 |
| Rights: | Copyright (c) 2026 50sea ; https://creativecommons.org/licenses/by/4.0 |
| Αριθμός Καταχώρησης: | edsbas.65B10F25 |
| Βάση Δεδομένων: | BASE |
καταχωρήστε σχόλιο πρώτοι!