RUS  ENG
Full version
JOURNALS // Vestnik Yuzhno-Ural'skogo Gosudarstvennogo Universiteta. Seriya "Vychislitelnaya Matematika i Informatika" // Archive

Vestn. YuUrGU. Ser. Vych. Matem. Inform., 2014 Volume 3, Issue 4, Pages 36–50 (Mi vyurv54)

Computer Science, Engineering and Control

Representative sampling algorithm for database systems based on the partitioned parallelism

D. D. Yantsen, M. L. Zymbler

South Ural State University (Chelyabinsk, Russian Federation)

Abstract: Sampling is a popular approach to very large databases processing in a wide range of applications, e.g. data mining, histograms construction, query execution cost estimation, etc. Use of either the sample instead of the original database can reduce the accuracy of the results, but offset by a reduction of time executing processing. Representative sampling allows you to save the sample of certain characteristics of the database. However, existing algorithms for representative sampling can not be used for pas-parallel database systems because it does not take into account the characteristics of the data distribution fissionable by the compute nodes of the cluster system. In this paper we propose al-representative sampling algorithm for parallel relational database systems based on the slice of parallelism. The results of computational experiments on the proposed algorithm, showing adequate maintenance of representativity database properties distributed across the nodes of a cluster system.

Keywords: relational databases, parallel database systems, representative sampling.

UDC: 004.65, 004.622

Received: 11.08.2014

DOI: 10.14529/cmse140402



© Steklov Math. Inst. of RAS, 2024