Empirical study of parallel SQL query execution

Autor: Kirill K. Smirnov, George A. Chernishev
Jazyk: English<br />Russian
Rok vydání: 2018
Předmět:
Zdroj: Труды Института системного программирования РАН, Vol 21, Iss 0 (2018)
Druh dokumentu: article
ISSN: 2079-8156
2220-6426
Popis: In this paper we experiment with two major types of query parallelization techniques - intra and inter operator parallelism and their combinations. We evaluate these techniques applied to a query tree with a number of join operators in the multithreaded environment. In our experiments we vary thread count, buffer size, workload characteristics, measure the relative performance of several distinct join algorithms and observe several modes which appear in the series of experiments.
Databáze: Directory of Open Access Journals