Geodesic
Features of efficient processing of SQL-queries to conservative type databases
Informacionnye tehnologii i vyčislitelnye sistemy, no. 4 (2018), pp. 108-118.

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

In article, we are considering the problems of processing SQL queries with a high specific weight of join operations to conservative type databases (with occasional updating of data in specially allocated time) with increased data volumes on the GPU-cluster platform. Modified architecture of the previously developed parallel DBMS Clusterix-N (N - from New). We are proposed the methods for organizing dynamic segmentation of intermediate / temp relationships on a dedicated node with GPU accelerators and full load of processor cores of nodes on JOIN and IO levels. The performance of this DBMS is compared with the original DBMS PerformSys on a limited TPC-H test (without write operations) with V$_{\mathrm{DB}}$=60 GB and V$_{\mathrm{DB}}$=120 GB.
Keywords: conservative type databases, increased volumes of data, modification of parallel DBMS architecture, dynamic segmentation of intermediate / temp relations, application of graphic accelerators, full load of processor cores, comparative performance estimates. 
@article{ITVS_2018_4_a10,
     author = {R. K. Klassen},
     title = {Features of efficient processing of {SQL-queries} to conservative type databases},
     journal = {Informacionnye tehnologii i vy\v{c}islitelnye sistemy},
     pages = {108--118},
     publisher = {mathdoc},
     number = {4},
     year = {2018},
     language = {ru},
     url = {http://geodesic.mathdoc.fr/item/ITVS_2018_4_a10/}
}
TY  - JOUR
AU  - R. K. Klassen
TI  - Features of efficient processing of SQL-queries to conservative type databases
JO  - Informacionnye tehnologii i vyčislitelnye sistemy
PY  - 2018
SP  - 108
EP  - 118
IS  - 4
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/ITVS_2018_4_a10/
LA  - ru
ID  - ITVS_2018_4_a10
ER  - 
%0 Journal Article
%A R. K. Klassen
%T Features of efficient processing of SQL-queries to conservative type databases
%J Informacionnye tehnologii i vyčislitelnye sistemy
%D 2018
%P 108-118
%N 4
%I mathdoc
%U http://geodesic.mathdoc.fr/item/ITVS_2018_4_a10/
%G ru
%F ITVS_2018_4_a10
R. K. Klassen. Features of efficient processing of SQL-queries to conservative type databases. Informacionnye tehnologii i vyčislitelnye sistemy, no. 4 (2018), pp. 108-118. http://geodesic.mathdoc.fr/item/ITVS_2018_4_a10/