Method for Time Minimization of Api Requests Service From Cyber-Physical System to Cloud Database Management System

2019;
: pp. 125 - 131
1
Lviv Polytechnic National University, Department of Software
2
Lviv Polytechnic National University

Authors have analyzed the current state of cloud calculations and discovered the necessity of Application Programming Interface (API) usage in some of the cyber- physical systems (CPhS). The expediency of creating tools to reduce service time of Application Programming Interface requests and effective synchronization of the local and cloud database has been established. The authors clarified one of the main features of data replication. The expediency of using counter generations in the replication process instead of using system timer has been justified. The authors proposed the asynchronous method of accelerated service time for API requests to cloud database management systems using a synchronization accumulative table and registering changes in database with two-step sets of generations. Library that provides implementation of asynchronous API requests for Salesforce cloud management systems has been developed. Any Ruby on Rails application can use this library. Authors have evaluated and carried out benefits for the proposed solutions in test cases. Results of the test cases confirm service time minimization of API requests to the cloud database management system based on the proposed asynchronous method.

[1] A.Melnyk, “Cyber-physical systems: problems of creation and directions in development”. Transactions on Computer systems and networks, Lviv Polytechnic National University Press, No. 806, 2014, pp. 154-161 (in Ukrainian).

[2] D.Chappell, “A Short Introduction to Cloud Platforms and Enterprise – Oriented View,” Chappell and Associates, San Francisco, 2008, pp. 1-13.

[3] G.Lee, “Cloud Computing: Principles, Systems and Applications” / Nick Antonopoulos, Lee Gillam. L.: Springer, 2010, pp. 23-24.

[4] H.Qusay, “Demystifying Cloud Computing”/ Hassan, Qusay. – The Journal of Defense Software Engineering. CrossTalk, 2011, pp. 16–21.

[5]G.Galen.  “What  cloud  computing  really  means”.  [Online]. Available:    https://en.wikipedia.org/wiki/InfoWorld

[6] M.Fowler,   Patterns   of   enterprise   application   architecture. Addison-Wesley. 2015, 47 p.

[7] N.Pavych, B.Kutkovyi. “Accelerated servicing method of API calls to cloud-database management systems”. Transactions on Computer systems and networks, Lviv Polytechnic National University Press, No. 883, 2017, pp. 154-161 (in Ukrainian).

[8] J.Gilmore. "Meet DataMapper ORM, the Unified   Ruby Interface fo Data Stores". [Online]. Available: https://www.developer.com/lang/rubyrails/meet-datamapper- orm-the-unified-ruby-interface-for-data-stores.html

[9] M.Rowe, “The POSTGRES data model”, Proceedings of the 13th International Conference on Very Large Data Bases, Brighton, England: Morgan Kaufmann Publishers, 2016, pp. 83–96.

[10] B.Kutkovyi, N.Pavych. (2017). API-calls optimization for cloud database management systems. Pres. at International Scientific Journal “Internauka”, No 14, 2017. [Online]. Available: https://www.inter-nauka.com/en/issues/2017/14/3003.

Nataliya Pavych. Ph.D., Assoc. Prof at Software Department of Lviv Polytechnic National University. Master degree of Applied Mathematics in 1996 at Ivan Franko National University of Lviv. Her Ph.D. thesis was defended in 2001. Research in the database, data warehouse, data analysis areas. Author of more than 50 scientific works.

Tetyana Pavych. Junior Business Analyst at Titan International. Bachelor’s degree in Management Information System in 2019 at Northwood University, Midland, MI, USA. Research in the CRM management, business intelligence, data analysis area.