Accelerated servicing method of API calls to cloud-database management systems

: pp. 87 - 97
Lviv Polytechnic National University, Department of Software
Lviv Polytechnic National University, Department of Software

Analyzed the current state of the Application Programming Interface (API) calls to cloud database management systems. The expediency of creating tools to reduce the time for servicing such requests and the effective synchronization of the local and cloud databases has been established. The main features and principles of data replication are clarified. The expediency of using the counter of generations in the replication process instead of the system timer is justified. An asynchronous method of accelerated servicing for API calls to cloud database management systems is proposed by using a synchronization accumulative table and registering changes in databases using a two-stage set of generations. A library that provides the implementation of asynchronous API queries for the Salesforce cloud management system has been developed. The library can be used in any Ruby on Rails application. The evaluation of the benefits for the proposed solutions in the test case was carried out. The results of the test studies confirm the minimization of the service time for API calls to the cloud database management systems based on the proposed asynchronous method.

  1. Chappell D. A Short Introduction to Cloud Platforms an Enterprise–Oriented View: Chappell and Associates, San Francisco, 2008, pp. 1–13.
  2. Jon-David Chappell & Associates, 2008. – P. 3-4es, M. Tim, Cloud Computing with Linux / Jones, Jones, M. Tim – IBM DeveloperWorks (2008-09-10).
  3. Gillam, Lee. Cloud Computing: Principles, Systems and Applications / Nick Antonopoulos, Lee Gillam. – L. : Springer, 2010. – 23–24 р.
  4. SoCC '10: Proceedings of the 1st ACM symposium on Cloud computing / Hellerstein, Joseph M. – N. : ACM, 2010. – 2 р.
  5. Hassan, Qusay Demystifying Cloud Computing / Hassan, Qusay // The Journal of Defense Software Engineering. CrossTalk, 2011. – 16–21 р.
  6. Peter Mell and Timothy Grance The NIST Definition of Cloud Computing / Peter Mell and Timothy Grance. – National Institute of Standards and Technology: U. S. Department of Commerce. doi:10.6028/NIST.SP.800-145. Special publication, 2011. – 32–35 р.
  7. Baburajan, Rajani. The Rising Cloud Storage Market Opportunity Strengthens Vendors / Baburajan, Rajani. [web resource] :
  8. Gruman, Galen. What cloud computing really means. – [Web resource]:
  9. Antonio Regalado "Who Coined 'Cloud Computing?– Technology Review. MIT., 2013. – 30 p.
  10. David Hansson. Ruby on Rails will ship with OS X 10.5 (Leopard) / [Web resource]. –
  11. Martin Fowler. Patterns of enterprise application architecture. Addison-Wesley. 2015. – 47 p.
  12. Steven Feuerstein, Bill Pribyl. Oracle PL/SQL Programming. 18.5 Modifying Persistent Objects. Retrieved 23 August 2011. – 296 р.
  13. Mernik M., Heering J., Sloane A. M. When and how to develop domain-specific languages. ACM Computing Surveys, 2005. 316–317 p.
  14. Rassokhin A.; Oleksyuk D. TDSS botnet: full disclosure. Retrieved 6 December 2012. 25 р.
  15. Stonebraker, M. Rowe, LA. The POSTGRES data model (PDF). Proceedings of the 13th International Conference on Very Large Data Bases. Brighton, England: Morgan Kaufmann Publishers. 2016. 83–96 p.
  16. Kutkovy B., Pavych N. API-calls optimization for cloud database management systems // International Scientific Journal "Internauka". – 2017, No. # 14. – [ web resource]: Lviv Polytechnic National University Institutional Repository
Pavych N. Accelerated servicing method of API calls to cloud-database management systems / N. Pavych, B. Kutkovyi // Visnyk Natsionalnoho universytetu "Lvivska politekhnika". Serie: Kompiuterni systemy ta merezhi. — Lviv : Vydavnytstvo Lvivskoi politekhniky, 2017. — No 881. — P. 87–97.