IMPROVE THE SPEED OF WEB APPLICATION PAGE GENERATION BY TRANSFORMING A DATABASE QUERY INTO A SET OF LOOPS

Keywords: database, query, loop, join operation.

Abstract

Currently, despite the emergence of new storage technologies, the use of relational databases is dominant. In almost all areas of human life there are information systems with such databases, and often they are implemented in the form of web-applications. It is important to quickly receive a response from the user to his request. However, in the case of a complex system, the query can access a large number of tables, which will take a long time. There are various ways to speed up the information system: indexing, denormal-ization, the use of materialized views, configuring the DBMS parameters. However, the use of such methods to improve system performance requires careful study and analysis of the system for a long period of time, otherwise you can get the opposite result. The paper proposes a formal way to transform the query text with the selection of partial queries in it to execute them inside or outside the cycle of viewing query records in the formation of the resulting table. The view of the query, which formalizes the rules of transformation of the text of the original query in order to eliminate resource-intensive connection operations, is considered. The algorithm of transformation of query for use of partial queries is presented. Various options for using key and non-key attributes from the tables that are accessed by the query are described, which determines the type of transformation of the query. It is shown how the time of obtaining the result after the performed transformations is reduced, by the example of a real system of a medical institution, which is based on a da-tabase with a large number of tables related to each other, and requires a large number of queries per unit of time, while the queries refer to many tables.

Author Biographies

Светлана Леонидовна Зиноватная, Odessa National Polytechnic University
  Candidate of Technical Sciences, Associate Professor
Анна Александровна Зиноватная, Odessa National Polytechnic University
master student
Наталья Васильевна Швец, Odessa National Academic Food Technologies
Senior Lecturer
Published
2019-04-18
How to Cite
Зиноватная, С., Зиноватная, А., & Швец, Н. (2019). IMPROVE THE SPEED OF WEB APPLICATION PAGE GENERATION BY TRANSFORMING A DATABASE QUERY INTO A SET OF LOOPS. Electrotechnic and Computer Systems, (30(106), 99-107. https://doi.org/10.15276/eltecs.30.106.2019.11
Section
Information systems and technologies

Most read articles by the same author(s)