AN IMPROVED VOGEL’S APPROXIMATION METHOD (IVAM) FOR FRAGMENT ALLOCATIONN AND REPLICATION IN DISTRIBUTED DATABASE SYSTEMS
Mukta Aggarwal, Shalini Bhaskar Bajaj, Vivek Jaglan · Indian Journal of Computer Science and Engineering · 2022
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 .26for allocation and .24for replication which is higher than compared works.For 3 fragments and 6 sites, SRR for allocation is .191and for replication is .17which has optimally increased the successful retrieval ratio.