Abstract
The software as a service model ensures not only cloud applications, but also cloud databases. In this paper we analyze the impact on stored procedures of the switch of the existing application to cloud applications and cloud databases. We demonstrate that the stored procedures and cloud applications have common advantages and we emphasize also other advantages of the stored procedures. As a contribution we propose a list of improvements to stored procedures that can be considered in the new versions of the SQL standard and implemented by the database management systems providers. For the moment the SQL standard does not include any feature related to the cloud databases, so we expect that once again the software industry will be one step forward to the SQL standard.
Highlights
Classical data processing in client-server architecture involves transfer of the data from the database management system to the client application, and after their processing the transfer of the results back to the database server
This role of the stored procedures may still exist in the cloud databases only with the direct contribution of the cloud applications, because these would be the clients of the cloud databases
We present a list with proposals for improving the SQL standard and the SQL implementation of the stored procedures
Summary
Classical data processing in client-server architecture involves transfer of the data from the database management system to the client application, and after their processing the transfer of the results back to the database server. From this point of view, the stored procedures have common advantages with the cloud applications. The processing of data where is stored diminishes considerably the use of the network resources and benefits from the important resources of the servers. By using stored procedures and/or cloud applications, data processing operations are performed on systems much faster than workstations, which may decrease the waiting time of the system
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have