EFFICIENCY ANALYSIS OF REQUESTS’ PROCESSING BY THE SERVER IN THE HETEROGENEOUS DISTRIBUTED DATABASES
Mukhin Vadym, National Technical University of Ukraine “Kiev Polytechnical Institute”, Kiev, Ukraine
Kornaha Yaroslav, National Technical University of Ukraine “Kiev Polytechnical Institute”, Kiev, Ukraine
The distributed databases are used in the various applications: education, industry, transport, business, management. In particular, such databases are widely used in universities to support the automation of the learning process and to accelerate the data processing. An important element for the data processing rate determining is the average estimation of the queries processing in databases. The time data processing is depended on the many factors that are associated with the data processing on the server and data transfer via a computer network. The queries’ processing in the database servers is needed more time than on the packet. It should be developed a formal model of the database and calculated the average time of queries processing. In this work is described the evaluation of the query processing time on servers in heterogeneous distributed databases. There is defined the main areas and time needed for data processing. There is shown the changing in the time for the application processing when the queries processing monitoring and the methods for speed up the queries processing are used.
distributed database, indices, query processing, data model
1. Kirilov, V. V., Gromov, G. Iu. (2009). Vvedenie v reliatcionnye bazy dannykh [Introduction to relational database]. Saint-Petersburg: BKhV-Peterburg, p. 578 (in Russian).
2. Kornaha, Ya. I. (2012). Metody pidvyshchennia shvydkosti zapysu ta poshuku danykh u bazakh danykh. Visnyk Chernihivskoho derzhavnoho tekhnolohichnoho universytetu. Seriia “Tekhnichni nauky” – Visnyk of Chernihiv State Technological University. Series “Technical sciences”, no. 4 (61), pp. 166–172 (in Ukrainian).
3. Kornaha, Ya. I. (2012). Porivnialni otsinky zastosuvannia metodiv pidvyshchennia shvydkosti poshuku ta zapysu danykh v bazakh danykh. Adaptyvni systemy avtomatychnoho upravlinnia – Adaptive systems of automatic control, no. 1, рр. 37–44 (in Ukrainian).
4. Kuzin, A. V., Livonisova, S. V. (2008). Bazy dannykh [Databases]. Moscow: Akademiia, p. 489 (in Russian).
5. Mukhin, V. Ye., Kornaha, Ya. I., Sniehiriev, L. (2012). Pidvyshchennia efektyvnosti mekhanizmiv poshuku v bazakh danykh na osnovi K-derev [Improving the efficiency of search engines in the databases on the basis of K-trees]. Visnyk Natsionalnoho universytetu «Lvivska politekhnika». Seriia «Kompiuterni nauky ta informatsiini tekhnolohii» - Visnyk natsionalnoho universytetu «Lvivska politekhnika» – Visnyk of Lviv Polytechnic National University. Series “Computer science and information technology”. Lviv, no. 744, pp. 53–57 (in Ukrainian).