DBPapers
DOI: 10.5593/SGEM2016/B21/S07.051

STATISTICAL ANALYSIS OF QUERY PROCESSING IN A DISTRIBUTED INFORMATION SYSTEM

P.Gulyaev, I.Kalinin, L.Muravyeva-Vitkovskaya
Friday 9 September 2016 by Libadmin2016

References: 16th International Multidisciplinary Scientific GeoConference SGEM 2016, www.sgem.org, SGEM2016 Conference Proceedings, ISBN 978-619-7105-58-2 / ISSN 1314-2704, June 28 - July 6, 2016, Book2 Vol. 1, 397-404 pp

ABSTRACT

The scheduling model for a distributed information system is proposed to get the effective way of a query processing. The scheduling model uses internal queries to support a parallel computing, dynamic load balancing and data integrity. The data integrity insured by the two different locking strategies: the page locking or the row locking. We create the simulation model based by the University ITMO distributed system to solve two problems:
1.Estimate the expediency of using the page locking or the row locking.
2.Estimate the influence of the page size at the distributed information systemproductivity when the system using the page or the row locking.
The evaluation of the productivity is the quantity of queries that the distributed information system lost. The simulation model was launched with the different query intensity, the different mean sizes of requested data (“big” and “small” queries) and the different pages (data blocks) sizes.
The obtained results can be used by database administrators for choose locking strategy with optimal page size for their own distributed information system.

Keywords: distributed information system, priority model, simulation modeling, page locking, row locking

Home | Contact | Site Map | Site statistics | Visitors : 73 / 353063

Follow site activity en  Follow site activity INFORMATICS  Follow site activity Papers SGEM2016   ?

CrossRef Member    Indexed in ISI Web Of Knowledge   Indexed in ISI Web Of Knowledge
   

© Copyright 2001 International Multidisciplinary Scientific GeoConference & EXPO SGEM. All Rights Reserved.

Creative Commons License