Dublin Core
Title
Comparison of Performanse and Security Aspects of Database Access via Stored Procedures and APIs
Abstract
Modern applications typically get the information in one of two modalities, namely API as an intermediary layer or stored procedures in the same database. The aim of this study is to contrast these methods, mainly performance-wise, and then securitywise, as well as suitability for maintenance as well as scalability. The project will implement identical stored procedures in the PostgreSQL database, and a API backend in Python. Execution time for a query, resource consumption as well as susceptibility to security flaws will be evaluated. The plan is to perform 10 runs for each comparison so as to ensure the obtained results are as accurate as well as dependable as possible. And one of the aims is to devise practical recommendations as to when to apply a stored procedure, and when the API method, where a boundary (equilibrium) has to be drawn between the logic of intermixing in the same data as well as the logic in the app layer.
Today with applications being used in distributed environments on a widespread basis, awareness of them is most important in ensuring smooth and effective development of information systems, particularly in those fields where a lot of information has to be processed, such as e-business, banks etc.
Today with applications being used in distributed environments on a widespread basis, awareness of them is most important in ensuring smooth and effective development of information systems, particularly in those fields where a lot of information has to be processed, such as e-business, banks etc.
Keywords
Stored Procedures, Api, Comparison, Database Access, Postgresql