Evaluation of triggers and stored procedures of relational databases

Session

Computer Science and Communication Engineering

Description

Relational database management systems are today’s most used model for organizing data storage and manipulation. However, choosing between open-source and commercial RDBMS remains one of the main challenges when choosing the application’s data model. The main trade-off falls between the performance and cost. MySQL has emerged as a primer approach for cost-effective solutions, while SQL as one of the top commercial ones. This paper presents a conceptual analysis and a comparative study on the performance of the most popular systems: SQL Server and MySQL, focusing on triggers and stored procedures. SQL enables us to create a trigger for CRUD operations while in MySQL triggers with INSERT or UPDATE queries are not possible. The performance testing aims at executing different SQL queries for stored procedures and triggers for both approaches. Comparative evaluation is done taking as a parameter: the average execution time, the use of CPUs, and the use of threads for each database after completion of the test. The result shows that SQL is faster whereas MySQL uses less CPUs and less threads than SQL.

Keywords:

databases, RDMS, SQL, MySQL

Session Chair

Felix Breitenecker

Session Co-Chair

Edmond Jajaga

Proceedings Editor

Edmond Hajrizi

ISBN

978-9951-437-69-1

Location

Pristina, Kosovo

Start Date

27-10-2018 3:15 PM

End Date

27-10-2018 4:45 PM

DOI

10.33107/ubt-ic.2018.92

This document is currently not available here.

Share

COinS
 
Oct 27th, 3:15 PM Oct 27th, 4:45 PM

Evaluation of triggers and stored procedures of relational databases

Pristina, Kosovo

Relational database management systems are today’s most used model for organizing data storage and manipulation. However, choosing between open-source and commercial RDBMS remains one of the main challenges when choosing the application’s data model. The main trade-off falls between the performance and cost. MySQL has emerged as a primer approach for cost-effective solutions, while SQL as one of the top commercial ones. This paper presents a conceptual analysis and a comparative study on the performance of the most popular systems: SQL Server and MySQL, focusing on triggers and stored procedures. SQL enables us to create a trigger for CRUD operations while in MySQL triggers with INSERT or UPDATE queries are not possible. The performance testing aims at executing different SQL queries for stored procedures and triggers for both approaches. Comparative evaluation is done taking as a parameter: the average execution time, the use of CPUs, and the use of threads for each database after completion of the test. The result shows that SQL is faster whereas MySQL uses less CPUs and less threads than SQL.