Title: Information graph-based creation of parallel queries for databases

Authors: Yulia Shichkina; Dmitry Gushchanskiy; Alexander Degtyarev

Addresses: Department of Computer Science and Engineering, Saint Petersburg Electrotechnical University 'LETI', St. Petersburg, Russia ' Saint Petersburg State University, St. Petersburg, Russia ' Saint Petersburg State University, St. Petersburg, Russia

Abstract: The article describes the query parallelisation method that takes into account the dependencies between operations in the data query. The method is based on the representation of the query as a directed graph with vertices as operations and edges as data connections. The graph is processed as an adjacency list, saving more memory than during processing a sparse adjacency matrix. The graph is modified only by operations, which do not change the elements of the adjacency list. Therefore it is possible to achieve intra-query parallelism by consideration of a request structure and implementation of mathematical methods of parallel calculations for its equivalent transformation. This article also presents an example of complex query parallelisation and describes applicability of the graph theory and methods of parallel computing both for query parallelisation and optimisation.

Keywords: parallel computing; optimisation methods; relational database; query; information graph; query parallelisation.

DOI: 10.1504/IJBIDM.2018.094982

International Journal of Business Intelligence and Data Mining, 2018 Vol.13 No.4, pp.475 - 491

Received: 27 Jan 2017
Accepted: 03 Feb 2017
Published online: 28 Sep 2018 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article