The Application of Graph Theory and Adjacency Lists to Create Parallel Queries to Relational Databases

被引:2
|
作者
Shichkina, Yulia [1 ]
Kupriyanov, Mikhail [1 ]
Shevsky, Vladislav [1 ]
机构
[1] St Petersburg Electrotech Univ LETI, Ul Prof Popova 5, St Petersburg 197376, Russia
关键词
Database; Query; Parallel computing; Information graph; Adjacency lists; OPTIMIZATION; MANAGEMENT;
D O I
10.1007/978-3-030-01168-0_13
中图分类号
TP301 [理论、方法];
学科分类号
081202 ;
摘要
The increase in the volume of processed data and the requirements for accuracy and speed of their processing has been observed in the world. Therefore, the problem of finding effective methods for accelerating the execution of queries with the involvement of all possible software, mathematical and hardware tools is becoming increasingly important. This article presents the results of the authors' research in the field of creating parallel queries. These results can be used in practice to implement relational queries and in theory to improve the methods of parallelizing queries. In the article are considered various ways of performance of a complex queries both in sequential, and in a parallel type. It is proposed to use the theory of parallel computations for the transformation of queries. The results of numerical experiments confirming the authors' assumptions are presented at the end of the article.
引用
收藏
页码:138 / 149
页数:12
相关论文
共 15 条
  • [1] Application of Optimization of Parallel Algorithms to Queries in Relational Databases
    Shichkina, Yulia
    Degtyarev, Alexander
    Gushchanskiy, Dmitry
    Iakushkin, Oleg
    [J]. COMPUTATIONAL SCIENCE AND ITS APPLICATIONS - ICCSA 2016, PT II, 2016, 9787 : 366 - 378
  • [2] Performance of Graph and Relational Databases in Complex Queries
    Kotiranta, Petri
    Junkkari, Marko
    Nummenmaa, Jyrki
    [J]. APPLIED SCIENCES-BASEL, 2022, 12 (13):
  • [3] A graph-theoretic approach to optimize keyword queries in relational databases
    Jaehui Park
    Sang-goo Lee
    [J]. Knowledge and Information Systems, 2014, 41 : 843 - 870
  • [4] A graph-theoretic approach to optimize keyword queries in relational databases
    Park, Jaehui
    Lee, Sang-goo
    [J]. KNOWLEDGE AND INFORMATION SYSTEMS, 2014, 41 (03) : 843 - 870
  • [5] Time Complexity and Parallel Speedup of Relational Queries to Solve Graph Problems
    Ordonez, Carlos
    Tosic, Predrag T.
    [J]. DATABASE AND EXPERT SYSTEMS APPLICATIONS (DEXA 2018), PT II, 2018, 11030 : 339 - 349
  • [6] THE APPLICATION OF FUNCTIONAL DEPENDENCY THEORY TO RELATIONAL DATABASES
    CARLSON, CR
    ARORA, AK
    CARLSON, MM
    [J]. COMPUTER JOURNAL, 1982, 25 (01): : 68 - 73
  • [7] A general theorem for adjacency matrices of graph products and application in graph partitioning for parallel computing
    Kaveh, A.
    Alinejad, B.
    [J]. FINITE ELEMENTS IN ANALYSIS AND DESIGN, 2009, 45 (03) : 149 - 155
  • [8] Comparison of Relational, Document and Graph Databases in the Context of the Web Application Development
    Plechawska-Wojcik, Malgorzata
    Rykowski, Damian
    [J]. INFORMATION SYSTEMS ARCHITECTURE AND TECHNOLOGY, ISAT 2015, PT II, 2016, 430 : 3 - 13
  • [9] Adjacency Method for Finding Connected Subsets of a Graph: An Application of Graph Theory to Spatial Statistics
    Luo, Jun
    Huang, Lan
    Hachey, Mark
    Tiwari, Ram
    [J]. COMMUNICATIONS IN STATISTICS-SIMULATION AND COMPUTATION, 2009, 38 (05) : 1136 - 1151
  • [10] SOME RESULTS IN GRAPH THEORY AND THEIR APPLICATION TO ABSTRACT RELATIONAL BIOLOGY
    ROSEN, R
    [J]. BULLETIN OF MATHEMATICAL BIOPHYSICS, 1963, 25 (02): : 231 - &