Advertisement

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

  • Yulia ShichkinaEmail author
  • Mikhail Kupriyanov
  • Vladislav Shevsky
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 11118)

Abstract

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.

Keywords

Database Query Parallel computing Information graph Adjacency lists 

Notes

Acknowledgments

The paper has been prepared within the scope of the state project “Initiative scientific project” of the main part of the state plan of the Ministry of Education and Science of Russian Federation (task № 2.6553.2017/8.9 BCH Basic Part).

References

  1. 1.
  2. 2.
    Biswas, R., et al.: A NASA perspective on quantum computing: opportunities and challenges. Parallel Comput. 64, 81–98 (2017).  https://doi.org/10.1016/j.parco.2016.11.002MathSciNetCrossRefGoogle Scholar
  3. 3.
    Lu, W., Wang, Y., Juang, J., Liu, J., Shen, Y., Wei, B.: Hybrid storage architecture and efficient MapReduce processing for unstructured data. Parallel Comput. 69, 63–77 (2017).  https://doi.org/10.1016/j.parco.2017.08.008MathSciNetCrossRefGoogle Scholar
  4. 4.
    Jin, P., Yang, P., Yue, L.: Optimizing B + -tree for hybrid storage systems. Distrib. Parallel Databases 33(3), 449–475 (2015).  https://doi.org/10.1007/s10619-014-7157-7CrossRefGoogle Scholar
  5. 5.
    Luo, Q., Teubner, J.: Special issue on data management on modern hardware. Distrib. Parallel Databases 33, 415–416 (2015).  https://doi.org/10.1007/s10619-014-7168-4CrossRefGoogle Scholar
  6. 6.
    Yasar, A., Gedik, B., Ferhatosmanoglu, H.: Distributed block formation and layout for disk-based management of large-scale graphs. Distrib. Parallel Databases 35(1), 23–53 (2017).  https://doi.org/10.1007/s10619-017-7191-3CrossRefGoogle Scholar
  7. 7.
    Amagata, D., Hara, T., Nishio, S.: Sliding window top-k dominating query processing over distributed data streams. Distrib. Parallel Databases 34(4), 535–566 (2016)CrossRefGoogle Scholar
  8. 8.
    Waluyo, A.B., Srinivasan, B., Taniar, D.: Research in mobile database query optimization and processing. Mob. Inf. Syst. 1(4), 225–252 (2005)Google Scholar
  9. 9.
    Spiliopoulou, M., Hatzopoulos, M.: Translation of SQL queries into a graph structure: query transformations and pre-optimization issues in a pipeline multiprocessor environment. Inf. Syst. 17(2), 161–170 (1992)CrossRefGoogle Scholar
  10. 10.
    Yao, S.B.: Optimization of query evaluation algorithms. ACM Trans. Database Syst. 4(2), 133–155 (1979)CrossRefGoogle Scholar
  11. 11.
    Mikkilineni, K.P., Su, S.Y.W.: An evaluation of relational join algorithms in a pipelined query processing environment. IEEE Trans. Softw. Eng. 14(6), 838–848 (1988)CrossRefGoogle Scholar
  12. 12.
    Jarke, M., Koch, J.: Query optimization in database systems. ACM Comput. Surv. 16(2), 111–152 (1984)MathSciNetCrossRefGoogle Scholar
  13. 13.
    Shichkina, Y.A., Kupriyanov, M.S.: Applying the list method to the transformation of parallel algorithms into account temporal characteristics of operations. In: Proceedings of the 19th International Conference on Soft Computing and Measurements, SCM 2016, pp. 292–295 (2016). 7519759Google Scholar

Copyright information

© Springer Nature Switzerland AG 2018

Authors and Affiliations

  • Yulia Shichkina
    • 1
    Email author
  • Mikhail Kupriyanov
    • 1
  • Vladislav Shevsky
    • 1
  1. 1.Saint Petersburg Electrotechnical University “LETI”St. PetersburgRussia

Personalised recommendations