{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,30]],"date-time":"2025-12-30T11:13:48Z","timestamp":1767093228045,"version":"build-2065373602"},"reference-count":17,"publisher":"MDPI AG","issue":"3","license":[{"start":{"date-parts":[[2019,3,12]],"date-time":"2019-03-12T00:00:00Z","timestamp":1552348800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information"],"abstract":"<jats:p>Data fragmentation and allocation has for long proven to be an efficient technique for improving the performance of distributed database systems\u2019 (DDBSs). A crucial feature of any successful DDBS design revolves around placing an intrinsic emphasis on minimizing transmission costs (TC). This work; therefore, focuses on improving distribution performance based on transmission cost minimization. To do so, data fragmentation and allocation techniques are utilized in this work along with investigating several data replication scenarios. Moreover, site clustering is leveraged with the aim of producing a minimum possible number of highly balanced clusters. By doing so, TC is proved to be immensely reduced, as depicted in performance evaluation. DDBS performance is measured using TC objective function. An inclusive evaluation has been made in a simulated environment, and the compared results have demonstrated the superiority and efficacy of the proposed approach on reducing TC.<\/jats:p>","DOI":"10.3390\/info10030112","type":"journal-article","created":{"date-parts":[[2019,3,13]],"date-time":"2019-03-13T04:07:37Z","timestamp":1552450057000},"page":"112","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":13,"title":["Towards an Efficient Data Fragmentation, Allocation, and Clustering Approach in a Distributed Environment"],"prefix":"10.3390","volume":"10","author":[{"given":"Hassan","family":"Abdalla","sequence":"first","affiliation":[{"name":"College of Technological Innovation, Zayed University, P.O. Box 144534, Abu Dhabi 11543, UAE"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Abdel Monim","family":"Artoli","sequence":"additional","affiliation":[{"name":"College of Computer and Information Sciences, King Saud University, P.O. Box 51178, Riyadh 11543, Saudi Arabia"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"1968","published-online":{"date-parts":[[2019,3,12]]},"reference":[{"key":"ref_1","unstructured":"Ponniah, P. (2005). Database Design and Development: An Essential Guide for IT Professionals, Wiley-IEEE Press."},{"key":"ref_2","doi-asserted-by":"crossref","first-page":"e00487","DOI":"10.1016\/j.heliyon.2017.e00487","article-title":"An optimized approach for simultaneous horizontal data fragmentation and allocation in Distributed Database Systems (DDBSs)","volume":"3","author":"Amer","year":"2017","journal-title":"Heliyon"},{"key":"ref_3","doi-asserted-by":"crossref","first-page":"427","DOI":"10.1016\/j.chb.2013.04.025","article-title":"A synchronized design technique for efficient data distribution","volume":"30","author":"Abdalla","year":"2014","journal-title":"Comput. Hum. Behav."},{"key":"ref_4","doi-asserted-by":"crossref","first-page":"e4416","DOI":"10.1002\/cpe.4416","article-title":"Dynamic data reallocation and replication over a cloud environment","volume":"30","author":"Badr","year":"2018","journal-title":"Concurr. Comput. Pract. Exp."},{"key":"ref_5","doi-asserted-by":"crossref","unstructured":"Cong, V.P., Ha, H.C.N., and Vassev, E. (2018). Fragmentation in Distributed Database Design Based on KR Rough Clustering Technique. Context-Aware Systems and Applications, and Nature of Computation and Communication, Springer.","DOI":"10.1007\/978-3-319-77818-1"},{"key":"ref_6","first-page":"308","article-title":"A Replication Scheme for Multiple Fragmentations with Overlapping Fragments","volume":"60","author":"Wiese","year":"2017","journal-title":"Comput. J."},{"key":"ref_7","doi-asserted-by":"crossref","first-page":"27","DOI":"10.4018\/IJSWIS.2017040103","article-title":"A Novel Query-Driven Clustering-Based Technique for Vertical Fragmentation and Allocation in Distributed Database Systems","volume":"13","author":"Sewisy","year":"2017","journal-title":"Int. J. Semant. Web Inf. Syst."},{"key":"ref_8","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1145\/3150223","article-title":"A Comprehensive Taxonomy of Fragmentation and Allocation Techniques in Distributed Database Design","volume":"51","author":"Nashat","year":"2018","journal-title":"ACM Comput. Surv."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"419","DOI":"10.1016\/j.chb.2013.04.026","article-title":"Performance optimality enhancement algorithm in DDBS (POEA)","volume":"30","author":"Abdallaha","year":"2014","journal-title":"Comput. Hum. Behav."},{"key":"ref_10","doi-asserted-by":"crossref","first-page":"571","DOI":"10.1016\/j.asoc.2017.11.019","article-title":"A new approach based on particle swarm optimization algorithm for solving data allocation problem","volume":"62","author":"Mahi","year":"2018","journal-title":"Appl. Soft Comput."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"1562","DOI":"10.1007\/s11227-017-2182-8","article-title":"A hybrid MapReduce-based k-means clustering using genetic algorithm for distributed datasets","volume":"74","author":"Sinha","year":"2018","journal-title":"J. Supercomput."},{"key":"ref_12","doi-asserted-by":"crossref","unstructured":"Amer, A.A., Mohamed, M.H., and Al_Asri, K. (2018, January 14\u201316). On an Effective Hierarchical Clustering Based Model for Data Fragmentation and Allocation in Relational DDBS: Review and Proposal. Proceedings of the ACM ICCES conference, Kuala Lumpur, Malaysia.","DOI":"10.1145\/3213187.3293604"},{"key":"ref_13","doi-asserted-by":"crossref","unstructured":"Amer, A.A., Mohamed, M.H., Sewisy, A., and Al_Asri, K. (2018, January 20\u201322). An Aggregated Similarity Based Hierarchical Clustering Technique for Relational DDBS Design. Proceedings of the Fifth International Conference on Parallel, Distributed and Grid Computing (PDGC), Solan, India.","DOI":"10.1109\/PDGC.2018.8745981"},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"183","DOI":"10.1007\/BF01267326","article-title":"An objective function for vertically partitioning relations in distributed databases and its analysis","volume":"2","author":"Chakravarthy","year":"1993","journal-title":"Distrib. Parallel Databases"},{"key":"ref_15","doi-asserted-by":"crossref","first-page":"147","DOI":"10.1002\/j.1538-7305.1950.tb00463.x","article-title":"Error Detecting and Error Correcting Codes","volume":"29","author":"Hamming","year":"1950","journal-title":"Bell Syst. Tech. J."},{"key":"ref_16","unstructured":"Meesad, P., Sodsee, S., and Unger, H. (2017). Sequentially Grouping Items into Clusters of Unspecified Number. Recent Advances in Information and Communication Technology, Springer."},{"key":"ref_17","doi-asserted-by":"crossref","unstructured":"Lytras, M., Aljohani, N., Damiani, E., and Chui, K. (2018). Data Replication Impact on DDBS System Performance. Semantic Web Science and Real-World Applications, IGI Global.","DOI":"10.4018\/978-1-5225-7186-5"}],"container-title":["Information"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2078-2489\/10\/3\/112\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T12:38:18Z","timestamp":1760186298000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2078-2489\/10\/3\/112"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,3,12]]},"references-count":17,"journal-issue":{"issue":"3","published-online":{"date-parts":[[2019,3]]}},"alternative-id":["info10030112"],"URL":"https:\/\/doi.org\/10.3390\/info10030112","relation":{},"ISSN":["2078-2489"],"issn-type":[{"type":"electronic","value":"2078-2489"}],"subject":[],"published":{"date-parts":[[2019,3,12]]}}}