Timofееva N.E., Gеraskin A.S., Polulyakh K.A. Research and Construction of Stress Testing DBMS Models to Increase Speed and Performance of Distributed Computing System

https://doi.org/10.15688/jvolsu1.2017.1.8

Nadеzhda Evgеnyevna Timofееva
Head of Laboratory of Theoretical Problems of Computer Science and its Applications,
Department of Discrete Mathematics and Informational Technologies,
Saratov National Research State University named after N.G. Chernyshevsky
This email address is being protected from spambots. You need JavaScript enabled to view it.
Astrakhanskaya St., 83, 410012 Saratov, Russian Federation

Alеksеy Sеrgееvich Gеraskin
Candidate of Pedagogical Sciences, Associate Professor,
Department of Computer Security and Cryptography Theory,
Saratov National Research State University named after N.G. Chernyshevsky
This email address is being protected from spambots. You need JavaScript enabled to view it.
Astrakhanskaya St., 83, 410012 Saratov, Russian Federation

Kristina Andrееvna Polulyakh
Laboratory Assistant, Laboratory of Theoretical Problems of Computer Science and its Applications,
Department of Discrete Mathematics and Informational Technologies,
Saratov National Research State University named after N.G. Chernyshevsky
This email address is being protected from spambots. You need JavaScript enabled to view it.
Astrakhanskaya St., 83, 410012 Saratov, Russian Federation

Abstract. Modern information systems work with huge data flows, so there is a need to build a logically single database (DB), parts of which are located within the network nodes. Selecting a DBMS node of distributed system is a complex multiparameter task and is one of the important stages in the development of DDB. The choice of the DBMS is determined by many different factors such as the number of possible users of the system, performance and reliability. The aim is to identify the criteria for building the DBMS testing algorithms followed by its testing and use as a node in a distributed database increases the speed and performance of the entire system.
In the framework of examining the use of DDBs in the site freely available databases such as MySQL and PostgreSQL. The most important criteria for comparison, from the point of view of the user, are performance and reliability.
By performance we mean the value that the database spends on particular data processing operations. The main factor influencing the performance is response time. In turn, the response time can be divided into: the response time for inserting a single element; response time to remove one element; response time to read the entire table; response time to read the mask and *response time to update a single element; response time to insert elements from the 50 % N, where N – initial number of records in the database; response time to clean up the table. The concept of reliability of the system has a lot of meanings. The work under the reliability we mean the safety of information transmission. To carry out a comparative analysis a set of tests analyzing the DBMS performance of MySQL and PostgreSQL was developed. The developed complex of tests includes: database test algorithm response time for data entry; DBMS test algorithm response time when reading information; DBMS testing algorithm performance; DBMS testing algorithm for reliability. To conduct a comparative analysis of the above selected criteria the planned experiment and the regression model was carried out. The study dependencies, built on regression models, allows to say that PostrgreSQL is slower when inserting data into a table, but the database is much faster at reading data tables. Just PostrgreSQL DBMS runs faster with highly filled base and a large number of users. Thus, within the framework of the nodes DDB it is better to use PostgreSQL.

Key words: distributed database, response time, performance, testing DBMS, planned experiment, regression model.

Creative Commons License

CResearch and Construction of Stress Testing DBMS Models to Increase Speed and Performance of Distributed Computing System by Timofееva N.E., Gеraskin A.S., Polulyakh K.A. is licensed under a Creative Commons Attribution 4.0 International License.

Citation in EnglishScience Journal of Volgograd State University. Mathematics. Physics. №1 (38) 2017 pp. 75-89

Attachments:
Download this file (Timofeeva_etc.pdf) Timofeeva_etc.pdf
URL: https://mp.jvolsu.com/index.php/en/component/attachments/download/670
499 Downloads