Open AccessAnalysis of the possibilities of optimizing SQL queries
Author(s) -
Piotr Rymarski,
Grzegorz Kozieł
Publication year - 2021
Publication title -
journal of computer sciences institute
Language(s) - English
Resource type - Journals
ISSN - 2544-0764
DOI - 10.35784/jcsi.2641
Subject(s) - computer science , sql , stored procedure , database , relational database management system , data transformation services , relational database , data definition language , language integrated query , java , query by example , sql/psm , sql injection
Most of today's web applications run on relational database systems. Communication with them is possible through statements written in Structured Query Language (SQL). This paper presents the most popular relational database management systems and describes common ways to optimize SQL queries. Using the research environment based on fragment of the imdb.com database, implementing OracleDb, MySQL, Microsoft SQL Server and PostgreSQL engines, a number of test scenarios were performed. The aim was to check the performance changes of SQL queries resulting from syntax modication while maintaining the result, the impact of database organization, indexing and advanced mechanisms aimed at increasing the eciency of operations performed, delivered in the systems used. The tests were carried out using a proprietary application written in Java using the Hibernate framework.