Academic Journal
A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems
| Title: | A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems |
|---|---|
| Authors: | Younus, Muhammad Usman, Muhammad Shoaib, Kalsoom Safdar, Abdul Basit Dogar |
| Source: | International Journal of Innovations in Science & Technology; Vol. 8 No. 1 (2026): Vol 8 Issue 1; 162-178 ; 2709-6130 ; 2618-1630 |
| Publisher Information: | 50SEA |
| Publication Year: | 2026 |
| Subject Terms: | Horizontal Fragmentation, Distributed Database, Query Optimisation, Attribute Locality, MCRUD |
| Description: | 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. |
| Document Type: | article in journal/newspaper |
| File Description: | application/pdf |
| Language: | 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 |
| Availability: | 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 |
| Accession Number: | edsbas.65B10F25 |
| Database: | BASE |
| FullText | Text: Availability: 0 CustomLinks: – Url: https://journal.50sea.com/index.php/IJIST/article/view/1754# Name: EDS - BASE (ns324271) Category: fullText Text: View record from BASE |
|---|---|
| Header | DbId: edsbas DbLabel: BASE An: edsbas.65B10F25 RelevancyScore: 1011 AccessLevel: 3 PubType: Academic Journal PubTypeId: academicJournal PreciseRelevancyScore: 1010.63568115234 |
| IllustrationInfo | |
| Items | – Name: Title Label: Title Group: Ti Data: A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems – Name: Author Label: Authors Group: Au Data: <searchLink fieldCode="AR" term="%22Younus%2C+Muhammad+Usman%22">Younus, Muhammad Usman</searchLink><br /><searchLink fieldCode="AR" term="%22Muhammad+Shoaib%22">Muhammad Shoaib</searchLink><br /><searchLink fieldCode="AR" term="%22Kalsoom+Safdar%22">Kalsoom Safdar</searchLink><br /><searchLink fieldCode="AR" term="%22Abdul+Basit+Dogar%22">Abdul Basit Dogar</searchLink> – Name: TitleSource Label: Source Group: Src Data: International Journal of Innovations in Science & Technology; Vol. 8 No. 1 (2026): Vol 8 Issue 1; 162-178 ; 2709-6130 ; 2618-1630 – Name: Publisher Label: Publisher Information Group: PubInfo Data: 50SEA – Name: DatePubCY Label: Publication Year Group: Date Data: 2026 – Name: Subject Label: Subject Terms Group: Su Data: <searchLink fieldCode="DE" term="%22Horizontal+Fragmentation%22">Horizontal Fragmentation</searchLink><br /><searchLink fieldCode="DE" term="%22Distributed+Database%22">Distributed Database</searchLink><br /><searchLink fieldCode="DE" term="%22Query+Optimisation%22">Query Optimisation</searchLink><br /><searchLink fieldCode="DE" term="%22Attribute+Locality%22">Attribute Locality</searchLink><br /><searchLink fieldCode="DE" term="%22MCRUD%22">MCRUD</searchLink> – Name: Abstract Label: Description Group: Ab Data: 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. – Name: TypeDocument Label: Document Type Group: TypDoc Data: article in journal/newspaper – Name: Format Label: File Description Group: SrcInfo Data: application/pdf – Name: Language Label: Language Group: Lang Data: English – Name: NoteTitleSource Label: Relation Group: SrcInfo Data: https://journal.50sea.com/index.php/IJIST/article/view/1754/2792; https://journal.50sea.com/index.php/IJIST/article/view/1754 – Name: DOI Label: DOI Group: ID Data: 10.33411/IJIST/1754 – Name: URL Label: Availability Group: URL Data: https://journal.50sea.com/index.php/IJIST/article/view/1754<br />https://doi.org/10.33411/IJIST/1754 – Name: Copyright Label: Rights Group: Cpyrght Data: Copyright (c) 2026 50sea ; https://creativecommons.org/licenses/by/4.0 – Name: AN Label: Accession Number Group: ID Data: edsbas.65B10F25 |
| PLink | https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsbas&AN=edsbas.65B10F25 |
| RecordInfo | BibRecord: BibEntity: Identifiers: – Type: doi Value: 10.33411/IJIST/1754 Languages: – Text: English Subjects: – SubjectFull: Horizontal Fragmentation Type: general – SubjectFull: Distributed Database Type: general – SubjectFull: Query Optimisation Type: general – SubjectFull: Attribute Locality Type: general – SubjectFull: MCRUD Type: general Titles: – TitleFull: A Hybrid Approach for Efficient Database Fragmentation in Distributed Systems Type: main BibRelationships: HasContributorRelationships: – PersonEntity: Name: NameFull: Younus, Muhammad Usman – PersonEntity: Name: NameFull: Muhammad Shoaib – PersonEntity: Name: NameFull: Kalsoom Safdar – PersonEntity: Name: NameFull: Abdul Basit Dogar IsPartOfRelationships: – BibEntity: Dates: – D: 01 M: 01 Type: published Y: 2026 Identifiers: – Type: issn-locals Value: edsbas – Type: issn-locals Value: edsbas.oa Titles: – TitleFull: International Journal of Innovations in Science & Technology; Vol. 8 No. 1 (2026): Vol 8 Issue 1; 162-178 Type: main |
| ResultId | 1 |