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

: pp. 125 - 131
Lviv Polytechnic National University, Department of Software
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:

[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: 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: