EVALUATION OF DIFFERENT METHODS TO MASS UPDATE DATA IN DISTRIBUTED SYSTEMS: A SURVEY

Published 31 MARCH 2021 •  vol 14  •  no 1  • 


Authors:

 

Mostafa Chhardoli, Computer Engineering Department, Hamedan Branch, Islamic Azad University, Hamedan, Iran
Mansour Esmaeilpour, Computer Engineering Department, Hamedan Branch, Islamic Azad University, Hamedan, Iran
Khosrow Esmaeilpour, Computer Engineering Department, Hamedan Branch, Islamic Azad University, Hamedan, Iran
Hamid Yasinian, Computer Engineering Department, Hamedan Branch, Islamic Azad University, Hamedan, Iran
Meysam Bagheri, Computer Engineering Department, Hamedan Branch, Islamic Azad University, Hamedan, Iran

Abstract:

 

Using the databases in a distributed business environment leads to use a database without the duplicate data, less connection costs and availability of data and users accessibility. Today's distributed systems are widely used in business systems and companies to maintain the stability of their systems with distributed transactions. On the other hand, the business data on lump-sum basis and update information regularly to provide services are constantly. So, it is necessary that the lump-sum concurrent updates, online services be provided to users. Recent systems are confronted with distributed databases concurrency control, optimization of queries and update data. One of the methods used for avoid these limitations, uses the mini-batch updates with the breakdown of the lump-sum transaction small update and run it after committing transactions. But there are several challenge in the distributed systems this are, performance updated data on large transactions. To solve this problem, a useful technique for distributed systems is employment the time information from different records. Updating and online transactions are used to avoid interference lump-sum.

Keywords:

 

Distributed Database, Lump-Sum, Mini-Batch Update Data, Temporal Update

References:

 

[1] DeCandia, G., Dynamo: amazon’s highly available key-value store, Procs. twenty-first ACM SIGOPS symposium on Operating systems principles (SOSP ’07); 2007, p. 205–220.
[2] Gray, J., Reuter, A., Transaction Processing: Concept and Techniques, San Francisco: Morgan Kaufmann; 1992.
[3] Kudo, T., A batch Update Method of Database for Mass Data during Online Entry, Procs. 16th Int. Conf. on Knowledge-Based and Intelligent Information & Engineering Systems – KES 2012; 2012, p. 1807–1816.
[4] Kudo, T., Evaluation of Lump-sum Update Methods for Nonstop Service System, Procs. Int. Workshop on Informatics (IWIN2012); 2012, p. 3–10.
[5] Maalouf, H.W., Gurcan, M.K., Minimisation of the update response time in a distributed database system, Performance Evaluation, Vol. 50, Issue 4; 2002, p. 245–266.
[6] Schwartz, B., et al., High Performance MySQL, Oreilly & Associates Inc.; 2008.
[7] Shanker, U.,Misra, M., Sarje, A.K., Distributed real time database systems: background and literature review, Distributed and Parallel Databases, Vol. 23, Issue 2; 2008, p. 127–149.
[8] Snodgrass, R., Ahn, I., Temporal Databases, IEEE COMPUTER, Vol. 19, No. 9; 1986, p. 35–42.
[9] Stantic, B., Thornton, J., Sattar, A., A Novel Approach to Model NOWin Temporal Databases, Procs. 10th Int. Symposium on Temporal Representation and Reasoning and Fourth Int. Conf. on Temporal Logic; 2003, p. 174–180.
[10] Tanenbaum, A. S., Van Steen, M., Distributed Systems: Principles and Paradigms. Prentice Hall; 2006.
[11] Thomson, A., Diamond, T., Weng, S., Ren, K., Shao, P., Abadi, D.J., Calvin: fast distributed transactions for partitioned database systems, Procs. the 2012 ACM SIGMOD Int. Conf. on Management of Data (SIGMOD ’12); 2012, p. 1–12.
[12] Vonk, J., Grefen, P., Cross-Organizational Transaction Support for E-Services in Virtual Enterprises, Distributed and Parallel Databases, Vol. 14, Issue 2; 2003, p. 137–172.
[13] Wang, T., Vonk, J., Kratz, B., Grefen, P., A survey on the history of transaction management: from flat to grid transactions, Distributed and Parallel Databases, Vol. 23, Issue 3; 2008, p. 235–270.
[14] Yadav, D.S., Agrawal, R., Chauhan, D.S., Saraswat, R.C., Majumdar, A.K., Modelling long duration transactions with time constraints in active database, Procs. the Int. Conf. on Information Technology: Coding and Computing (ITOC’ 04), Vol. 1; 2004, p. 497 – 501.
[15] Yang, J., Lee, I., Jeong, O., Song, S., Lee, C., Lee, S., An architecture for supporting batch query and online service in Very Large Database systems, IEEE Int. Conf. on e-Business Engineering (ICEBE ’06); 2006, p. 549 – 553.
[16] Kumar, H., Kumari Chauhan, N., Kumar Yadav, P., A task allocation model for minimising system cost and maximising reliability of distributed computing system, Int. J. of Communication Networks and Distributed Systems, Vol. 20, Issue 2; 2018, p. 226 – 243.
[17] Kudo, T., Takeda ,Y. , Ishino,M. , Saotome ,K. , Kataoka,N., A Mass Data Update Method in Distributed Systems; 2013, p. 502 – 511.
[18] Chandra Patni,J., Singh Aswal, M., Distributed approach of load balancing in dynamic grid computing environment, Int. J. of Communication Networks and Distributed Systems, 2017 Vol.19, issue 1, pp.1 – 18.
[19] Misra, S., Khatua, M., Semi-Distributed Backoff: Collision-Aware Migration from Random to Deterministic Backoff, in IEEE Transactions on Mobile Computing, 2015 vol. 14, issue. 5, pp. 1071-1084.
[20] Danner, G., Jelasity, M., Fully Distributed Privacy Preserving Mini-batch Gradient Descent Learning, Distributed Applications and Interoperable Systems, 2015, pp. 30-44.
[21] Bansal, S., Sharma, S., Trivedi, I., A Detailed Review of Fault-Tolerance Techniques in Distributed System. IJIDCS) International Journal on Internet and Distributed Computing Systems. 2016, pp. 33.39.

Citations:

 

APA:
Chhardoli, M., Esmaeilpour, M., Esmaeilpour, K., Yasinian, H., & Bagheri, M. (2021). Evaluation of Different Methods to Mass Update Data in Distributed Systems: A Survey. International Journal of Grid and Distributed Computing (IJGDC), ISSN: 2005-4262 (Print); 2207-6379 (Online), NADIA, 14(1), 55-64. doi: 10.33832/ijgdc.2021.14.1.06.

MLA:
Chhardoli, Mostafa, et al. “Evaluation of Different Methods to Mass Update Data in Distributed Systems: A Survey.” International Journal of Grid and Distributed Computing (IJGDC), ISSN: 2005-4262 (Print); 2207-6379 (Online), NADIA, vol. 14, no. 1, 2021, pp. 55-64. IJGDC, http://article.nadiapub.com/IJGDC/vol14_no1/6.html.

IEEE:
[1] M. Chhardoli, M. Esmaeilpour, K. Esmaeilpour, H. Yasinian, and M. Bagheri, "Evaluation of Different Methods to Mass Update Data in Distributed Systems: A Survey." International Journal of Grid and Distributed Computing (IJGDC), ISSN: 2005-4262 (Print); 2207-6379 (Online), NADIA, vol. 14, no. 1, pp. 55-64, March 2021.