Home  /  Tech-E  /  Vol: 4 Núm: 2 Par: 0 (2021)  /  Article
ARTICLE
TITLE

Comparison of Stored Procedures on Relational Database Management System

SUMMARY

Store procedure is a group of query stored in database catalogue which allows it to be recalled. Insert, update and delete data could performed using store procedure. Stored procedure is an alternative to optimize query performance and also to reduce security gap at interface level of a system. This research provides an overview implementation of stored procedure insert, update and deleting in two DBMS, MariaDB and PostgreSQL. Software developers prefer MariaDB and PostgreSQL because it is open-source, which means free. This research is an experimental research and descriptive analysis. This research data uses student data with amount of data 25000, 15000 and 5000 data. Research result show PostgreSQL require less processing time than MariaDB. Results of this research can used as a reference to design application programs which sometimes choose a DBMS is not a concern of developer.

 Articles related

Aini Arifta Arwaz,Theja Kusumawijaya,Rediansyah Putra,Kurnia Putra,Aries Saifudin    

The tender winner selection system is important to ensure the winner will complete the project well. If there is a selection error that caused the project to fail, the application must be tested and error free. Testing in this study uses Black Box Testin... see more


N. V. Shostak,V. M. Bezruk,A. A. Astrakhantsev    

ABSTRACTContext. Recently, the number of attacks on intellectual property has increased significantly, which, according to the polls,occupies a leading position in the structure of modern society. The comprehensive development of the country is impossibl... see more