|

Estimation of time of joining two tables in the parallel column-oriented database system

Authors: Grigoriev Yu.A., Yermakov Ye.Yu. Published: 10.06.2013
Published in issue: #4(89)/2012  
DOI:

 
Category: Informatics & Computing Technology  
Keywords: parallel column-oriented database systems, Laplace–Stieltjes transform, expectation of time of performing a join of relations

The existing methods for performing a join of relations in the parallel column-oriented database system are analyzed. The Laplace–Stieltjes transform is deduced for the time of joining two tables using the nested-loop method, and the variants of this transform are considered for the SE, SD, and SN architectures and different operating modes of the parallel database systems.