Geodesic
Research and construction of stress testing DBMS models to increase speed and performance of distributed computing system
Matematičeskaâ fizika i kompʹûternoe modelirovanie, no. 1 (2017), pp. 75-89.

Voir la notice de l'article provenant de la source Math-Net.Ru

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.
Keywords: distributed database, performance, testing DBMS, planned experiment, regression model.
Mots-clés : response time 
@article{VVGUM_2017_1_a8,
     author = {N. E. Timofeeva and A. S. Geraskin and K. A. Polulyakh},
     title = {Research and construction of stress testing {DBMS} models to increase speed and performance of distributed computing system},
     journal = {Matemati\v{c}eska\^a fizika i kompʹ\^uternoe modelirovanie},
     pages = {75--89},
     publisher = {mathdoc},
     number = {1},
     year = {2017},
     language = {ru},
     url = {http://geodesic.mathdoc.fr/item/VVGUM_2017_1_a8/}
}
TY  - JOUR
AU  - N. E. Timofeeva
AU  - A. S. Geraskin
AU  - K. A. Polulyakh
TI  - Research and construction of stress testing DBMS models to increase speed and performance of distributed computing system
JO  - Matematičeskaâ fizika i kompʹûternoe modelirovanie
PY  - 2017
SP  - 75
EP  - 89
IS  - 1
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/VVGUM_2017_1_a8/
LA  - ru
ID  - VVGUM_2017_1_a8
ER  - 
%0 Journal Article
%A N. E. Timofeeva
%A A. S. Geraskin
%A K. A. Polulyakh
%T Research and construction of stress testing DBMS models to increase speed and performance of distributed computing system
%J Matematičeskaâ fizika i kompʹûternoe modelirovanie
%D 2017
%P 75-89
%N 1
%I mathdoc
%U http://geodesic.mathdoc.fr/item/VVGUM_2017_1_a8/
%G ru
%F VVGUM_2017_1_a8
N. E. Timofeeva; A. S. Geraskin; K. A. Polulyakh. Research and construction of stress testing DBMS models to increase speed and performance of distributed computing system. Matematičeskaâ fizika i kompʹûternoe modelirovanie, no. 1 (2017), pp. 75-89. http://geodesic.mathdoc.fr/item/VVGUM_2017_1_a8/

[1] N.\;V. Kulagin, “Mathematical Model of a Distributed Database for Corporate Information Systems”, Vestnik Volgogradskogo gosudarstvennogo tekhnicheskogo universiteta, 14:13 (2012), 127–129

[2] Dr.dimdim Workshop. Criteria of DBMS Choice in the Process of Information Systems Development, Title from screen http://www.infosystem.ru/designing/methodology/article/article_crit_select_rmdb.html

[3] D.\;V. Pavlov, “Distributed Relational System of Databases Management with Automatic Scalability”, Vestnik Ufimskogo gosudarstvennogo aviatsionnogo tekhnicheskogo universiteta, 16:3 (48) (2012), 143–152 | MR

[4] G.\;A. Petrov, S.\;V. Tikhov, V.\;P. Yakovlev, Databases, SPbGTU RP Publ., SPb., 2015, 74 pp.