Advertisement

Graph-Based Speculative Query Execution for RDBMS

  • Anna Sasak-Okoń
  • Marek Tudruj
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 10777)

Abstract

The paper concerns parallelized speculative support for query execution in RDBMS. The support is based on dynamic analysis of input query stream in databases serviced in SQLite. A multi-threaded middleware called the Speculative Layer is introduced which, based on a specific graph representation of a query stream, determines the most promising speculative queries for execution. The paper briefly presents the query graph modelling and analysis methods. Then, an extended version of speculative query execution algorithm is presented which allows combining results of multiple speculative queries for execution of one user input query. Experimental results are presented based on the proposed algorithm assessment in a multi-threaded testbed cooperating with a database serviced in SQLite.

Keywords

Speculative query execution Relational databases 

References

  1. 1.
    Kaeli, D., Yew, P.: Speculative Execution in High Performance Computer Architectures. Chapman Hall/CRC, Boca Raton (2005)zbMATHGoogle Scholar
  2. 2.
    Grama, A., Gupta, A., Karypis, G., Kumar, V.: Introduction to Parallel Computing, 2nd edn. Addison Wesley, Boston (2003)zbMATHGoogle Scholar
  3. 3.
    Liles Jr., E.A., Wilner, B.: Branch prediction mechanism. IBM Tech. Discl. Bull. 22(7), 3013–3016 (1979)Google Scholar
  4. 4.
    Smith, J.E.: A study of branch prediction strategies. In: ISCA Conference Proceedings, New York, pp. 135–148 (1981)Google Scholar
  5. 5.
    Padua, D.: Encyclopedia of Parallel Computing A-D. Springer, Heidelberg (2011)CrossRefzbMATHGoogle Scholar
  6. 6.
    Polyzotis, N., Ioannidis, Y.: Speculative query processing. In: CIDR Conference Proceedings, Asilomar, pp. 1–12 (2003)Google Scholar
  7. 7.
    Karp, R.M., Miller, R.E., Winograd, S.: The organization of computations for uniform recurrence equations. J. ACM 14(3), 563–590 (1967)MathSciNetCrossRefzbMATHGoogle Scholar
  8. 8.
    Barish, G., Knoblock, C.A.: Speculative plan execution for information gathering. Artif. Intell. 172(4–5), 413–453 (2008)CrossRefGoogle Scholar
  9. 9.
    Barish, G., Knoblock, C.A.: Speculative execution for information gathering plans. In: AIPS Conference Proceedings, Toulouse, pp. 184–193 (2002)Google Scholar
  10. 10.
    Hristidis, V., Papakonstantinou, Y.: Algorithms and applications for answering ranked queries using ranked views. VLDB J. 13(1), 49–70 (2004)CrossRefGoogle Scholar
  11. 11.
    Reddy, P.K., Kitsuregawa, M.: Speculative locking protocols to improve performance for distributed database systems. IEEE Trans. Knowl. Data Eng. 16(2), 154–169 (2004)CrossRefGoogle Scholar
  12. 12.
    Ragunathan, T., Krishna, R.P.: Performance enhancement of read-only transactions using speculative locking protocol, IRISS, Hyderabad (2007)Google Scholar
  13. 13.
    Ragunathan, T., Krishna, R.P.: Improving the performance of read-only transactions through asynchronous speculation. In: SpringSim Conference Proceedings, Ottawa, pp. 467–474 (2008)Google Scholar
  14. 14.
    Sasak-Okoń, A.: Speculative query execution in relational databases with graph modelling. In: Proceedings of the FEDCSIS, ACSIS, vol. 8, pp. 1383–1387 (2016)Google Scholar
  15. 15.
    Sasak-Okoń, A., Tudruj, M.: Graph-based speculative query execution in relational data-bases. In: ISPDC 2017, July 2017, Innsbruck, Austria, CPS. IEEE Explore (2017)Google Scholar
  16. 16.
    TPC benchmarks (2015). http://www.tpc.org/tpch/default.asp
  17. 17.
    Koutrika, G., Simitsis, A., Ioannidis, Y.: Conversational databases: explaining structured queries to users. Technical report Stanford InfoLab (2009)Google Scholar
  18. 18.
    Koutrika, G., Simitsis, A., Ioannidis, Y.: Explaining structured queries in natural language. In: ICDE Conference Proceedings, Long Beach, pp. 333–344 (2010)Google Scholar

Copyright information

© Springer International Publishing AG, part of Springer Nature 2018

Authors and Affiliations

  1. 1.University of Maria Curie-SkłodowskaLublinPoland
  2. 2.Institute of Computer Science, Polish Academy of SciencesWarsawPoland
  3. 3.Polish-Japanese Academy of Information TechnologyWarsawPoland

Personalised recommendations