AN IMPROVED VOGEL’s APPROXIMATION METHOD (IVAM) FOR FRAGMENT ALLOCATIONN AND REPLICATION IN DISTRIBUTED DATABASE SYSTEMS

• Main Authors: Aggarwal, M. (Author), Bajaj, S.B (Author), Jaglan, V. (Author)
• Format: Article
• Language: English
• Published: Engg Journals Publications 2022
• Subjects: Access Frequency Counter (AFC); Fragment Size (FS); Storage Capacity (SC); Successful Access Frequency (SAF); Successful Retrieval Ratio (SRR); Total Access Frequency (TAF)
• Online Access: View Fulltext in Publisher

 In distributed database, allocation of fragments depends on the access time, response time, transmission cost and storage capacity. An Improved VAM mathematical model is introduced to allocate and replicate fragments in an optimal way either by maximizing the access frequency or minimizing the transmission cost. The method reduces the migration of fragments over the network by allocating fragments to the sites where the access frequency is higher. Storage capacity of sites is another essential constraint considered here. Successful retrieval ratio of fragments is taken as a performance measure to show the efficacy and the optimal behavior of the proposed algorithm. It worked on 3 fragments and 4 sites and obtained SRR is.26 for allocation and.24 for replication which is higher than compared works. For 3 fragments and 6 sites, SRR for allocation is.191 and for replication is.17 which has optimally increased the successful retrieval ratio. © 2022, Engg Journals Publications. All rights reserved.