ПРОИЗВОДИТЕЛЬНОСТЬ RESTful И SOAP РНР WEB-СЕРВИСОВ ПРИ ПОИСКЕ В ДАННЫХ MySQL

Abstract

Urgency of the research. The service oriented architecture (SOA) is widely used in terms of constructing distributed computer systems. Web service technologies are applied for practical implementation of the system with SOA.One of the essential requirements to Web services is the performance of functioning, which depends on their software implementation.Target setting. Web services are used to access information stored in DBMS databases posted on websites.The issue of optimum software selection for Web service implementation of information with real-time data access is urgent in this connection.Actual scientific researches and issues analysis. While accessing data, Web services use inquiries to DBMS, which are usually implemented as SQL commands.In order to enhance the efficiency of operation of Web applications working with data, stored procedures and functions of DBMS are used instead of SQL commands.Uninvestigated parts of general matters. No investigations of performance of RESTful and SOAP РНР Web services that during the access to MySQL data with different volumes of stored information used SQL commands in one function mode and stored procedures in another one were conducted.The research objective. To define and analyze the performance of RESTful and SOAP РНР Web services using SQL commands and functionally similar stored procedures for the search of MySQL data for the selection of optimum software of Web services working with MySQL DBMS.The statement of basic materials. As it turned out, the use of stored procedures instead of SQL commands by RESTful and SOAP РНР Web services when inquiring to MySQL for the search of data reduced their performance.At the same time while searching in the investigated volumes of data £ 2 MByte, when applying both SQL commands and stored procedures in inquiring to MySQL, RESTful Web service was more performing than SOAP РНР service.Conclusions. The particularities of performance of RESTful and SOAP РНР services when searching in MySQL data with the use of both SQL commands and stored procedures have been established. While searching in MySQL data, RESTful Web service was more performing in all functioning modes than SOAP РНР service.