Managing Fragmented Database Replication for Mygrants Using Binary Vote Assignment on Cloud Quorum

Abstract:

Replication in distributed database is the process of copying and maintaining database objects in multiple databases that make up a distributed database system. In this paper, we will manage fragmented database replication and transaction management for Malaysian Greater Research Network (MyGRANTS) using a new proposed algorithm called Binary Vote Assignment on Cloud Quorum (BVACQ). This technique will combine replication and fragmentation. Fragmentation in distributed database is very useful in terms of usage, efficiency, parallelism and also for security. This strategy will partition the database into disjoint fragments. The result shows that managing replication and transaction through proposed BVACQ able to preserve data consistency. It also increases the degrees of parallelism. This is because by using fragmentation, replication and transaction can be divided into several subqueries that operate on the fragments.

References

[1] Rouse, M., Database Replication, 2012. http: /searchsqlserver. techtarget. com/definition/database-replication.

[2] M. Mat Deris, D. J. Evans, M. Y. Saman, A. Noraziah, Binary Vote Assignment on Grid For Efficient Access of Replicated Data, International Journal of Computer Mathematics, Taylor and Francis, Vol. 80, No. 12, pp.1489-1498, (2003).

DOI: 10.1080/00207160310001620777

[3] A. Noraziah, Ainul Azila Che Fauzi, Mustafa Mat Deris, Md Yazid Mohd Saman, Noriyani Mohd Zain, Nawsher Khan, Managing Educational Resource - Student Information Systems Using BVAGQ Fragmented Database Replication Model, Procedia Social and Behavioral Sciences Journal, Elsevier, Vol 28, p.127–132, (2011).

DOI: 10.1016/j.sbspro.2011.11.026

[4] Zhao, W., Xu, X., Wang, Z., Zhang, Y. and He, H. 2010. A Dynamic Optimal Replication Strategy in Data Grid Environment. International Conference on Internet Technology and Applications, pp.1-4.

DOI: 10.1109/itapp.2010.5566469

[5] Charrada, B. F., Ounelli, H. and Chettaoui, H. 2010. Dynamic Period vs Static Period in Data Grid Replication. Proceeding of IEEE International Conference on P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC), pp.565-568.

DOI: 10.1109/3pgcic.2010.97

[6] Daudjee, K., and Salem, K. 2004. Lazy Database Replication with Ordering Guarantees. Data Engineering, Proceedings, p.424 – 435.

DOI: 10.1109/icde.2004.1320016

[7] Ainul Azila, C. F., Noraziah, A., Noriyani, M. Z., Beg, A.H., Nawsher, K., and Elrasheed, I. S. 2011. Handling Fragmented Database Replication through Binary Vote Assignment Grid Quorum. Journal of Computer Science, Science Publications 7 (9): 1338-1342.

DOI: 10.3844/jcssp.2011.1338.1342

[8] Ainul Azila C. F., Noraziah, A., Noriyani M.Z., and Beg, A.H. 2011. A New Binary Vote Assignment on Grid Algorithm to Manage Replication in Distributed Database Environment. Proceeding of IACSIT International Conference on Computer Communication and Management, vol. 5, pp.421-425.

[9] A.M. Tamhankar, S. Ram, Database fragmentation and allocation: an integrated methodology and case study Systems, Man and Cybernetics, Part A: Systems and Humans, IEEE Transactions Volume: 28, Issue: 3, Page(s): 288 – 305, (1998).

DOI: 10.1109/3468.668961

[10] Connolly, T. and Begg, C. 2010Database System A Practical Approach to Design, Implementation and Management, International Edition, Fifth Edition, Pearson Education.