Skip to main content
SpringerLink
Log in

Graph-Based Speculative Query Execution for RDBMS

  • Conference paper
  • First Online:
Parallel Processing and Applied Mathematics (PPAM 2017)

Part of the book series: Lecture Notes in Computer Science ((LNTCS,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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Kaeli, D., Yew, P.: Speculative Execution in High Performance Computer Architectures. Chapman Hall/CRC, Boca Raton (2005)

    MATH  Google Scholar 

  2. Grama, A., Gupta, A., Karypis, G., Kumar, V.: Introduction to Parallel Computing, 2nd edn. Addison Wesley, Boston (2003)

    MATH  Google Scholar 

  3. Liles Jr., E.A., Wilner, B.: Branch prediction mechanism. IBM Tech. Discl. Bull. 22(7), 3013–3016 (1979)

    Google Scholar 

  4. Smith, J.E.: A study of branch prediction strategies. In: ISCA Conference Proceedings, New York, pp. 135–148 (1981)

    Google Scholar 

  5. Padua, D.: Encyclopedia of Parallel Computing A-D. Springer, Heidelberg (2011)

    Book  MATH  Google Scholar 

  6. Polyzotis, N., Ioannidis, Y.: Speculative query processing. In: CIDR Conference Proceedings, Asilomar, pp. 1–12 (2003)

    Google Scholar 

  7. Karp, R.M., Miller, R.E., Winograd, S.: The organization of computations for uniform recurrence equations. J. ACM 14(3), 563–590 (1967)

    Article  MathSciNet  MATH  Google Scholar 

  8. Barish, G., Knoblock, C.A.: Speculative plan execution for information gathering. Artif. Intell. 172(4–5), 413–453 (2008)

    Article  Google Scholar 

  9. Barish, G., Knoblock, C.A.: Speculative execution for information gathering plans. In: AIPS Conference Proceedings, Toulouse, pp. 184–193 (2002)

    Google Scholar 

  10. Hristidis, V., Papakonstantinou, Y.: Algorithms and applications for answering ranked queries using ranked views. VLDB J. 13(1), 49–70 (2004)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  12. Ragunathan, T., Krishna, R.P.: Performance enhancement of read-only transactions using speculative locking protocol, IRISS, Hyderabad (2007)

    Google Scholar 

  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. 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. 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. TPC benchmarks (2015). http://www.tpc.org/tpch/default.asp

  17. Koutrika, G., Simitsis, A., Ioannidis, Y.: Conversational databases: explaining structured queries to users. Technical report Stanford InfoLab (2009)

    Google Scholar 

  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 

Download references

Author information

Authors and Affiliations

  1. University of Maria Curie-Skłodowska, Pl. Marii Curie-Skłodowskiej 5, 20-031, Lublin, Poland

    Anna Sasak-Okoń & Marek Tudruj

  2. Institute of Computer Science, Polish Academy of Sciences, 21 Ordona Str., 01-237, Warsaw, Poland

    Anna Sasak-Okoń & Marek Tudruj

  3. Polish-Japanese Academy of Information Technology, 83 Koszykowa Str., 02-008, Warsaw, Poland

    Anna Sasak-Okoń & Marek Tudruj

Authors
  1. Anna Sasak-Okoń
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Marek Tudruj
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Anna Sasak-Okoń .

Editor information

Editors and Affiliations

  1. Czestochowa University of Technology, Czestochowa, Poland

    Roman Wyrzykowski

  2. University of Tennessee, Knoxville, Tennessee, USA

    Jack Dongarra

  3. University of Southern California, Marina Del Rey, California, USA

    Ewa Deelman

  4. Czestochowa University of Technology, Czestochowa, Poland

    Konrad Karczewski

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer International Publishing AG, part of Springer Nature

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Sasak-Okoń, A., Tudruj, M. (2018). Graph-Based Speculative Query Execution for RDBMS. In: Wyrzykowski, R., Dongarra, J., Deelman, E., Karczewski, K. (eds) Parallel Processing and Applied Mathematics. PPAM 2017. Lecture Notes in Computer Science(), vol 10777. Springer, Cham. https://doi.org/10.1007/978-3-319-78024-5_27

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-78024-5_27

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-78023-8

  • Online ISBN: 978-3-319-78024-5

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation