research-article

Speculative query execution in RDBMS based on analysis of query stream multigraphs

Authors:

Anna Sasak-Okoń,

Marek TudrujAuthors Info & Claims

IDEAS '20: Proceedings of the 24th Symposium on International Database Engineering & Applications

Article No.: 23, Pages 1 - 10

https://doi.org/10.1145/3410566.3410604

Published: 25 August 2020 Publication History

Abstract

The paper presents an insight into a speculative execution model of queries in RDBMS based on the analysis of the stream of current queries appearing at the database input. A specific multigraph representation of input query stream is created and used to determine the speculative queries for execution. A group of worker threads execute the chosen speculative queries in parallel with the execution of the standard input stream of user queries. The obtained speculative results are then used to support faster query execution. First, the paper briefly reminds the assumed graph modelling and analysis methods. Then, additional rules are presented which enable combining results of multiple speculative queries in execution of a single user input query. The quality of executed and used speculations is then analysed based on the defined quality metrics and structural details of speculative queries. Conclusions from this analysis are used to modify the selection method of target queries for speculative execution. It aims at intensification of the use of multiple speculative query results and further reduction of the user query execution time. Experimental results are presented in a multi-threaded speculative experimental environment cooperating with a SQLite database. They show that with the improved algorithm we can obtain more varied speculative query results, and thus, more intensive use of multiple speculative query results by the stream of user queries sent to the database.

References

[1]

D. Kaeli, P. Yew, "Speculative Execution in High Performance Computer Architectures," Chapman Hall/CRC, 2005.

[2]

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

[3]

E.A.Jr. Liles, B. Wilner, "Branch prediction mechanism.," IBM Technical Disclosure Bulletin, 1979, Vol.22(7), p. 3013--3016.

[4]

J.E. Smith, "A study of branch prediction strategies.," ISCA Conference Proceedings, 1981, New York, p.135--148.

[5]

J. Puiggali, B. K. Szymanski, T. Jove, J. L. Marzo., "Dynamic branch speculation in a speculative parallelization architecture for computer clusters", Concurrency and Computation: Practice and Experience, Vol.25(7), 2013, p.932--960.

[6]

D. Padua, "Encyclopedia of Parallel Computing A-D.," Springer, 2011.

[7]

N. Polyzotis, Y. Ioannidis, "Speculative query processing," CIDR Conference Proceedings, Asilomar, 2003, p.1--12.

[8]

R.M. Karp, R.E. Miller, S. Winograd, "The Organization of Computations for Uniform Recurrence Equations," Journal of the ACM, 1967, Vol.14(3): p.563--590.

Digital Library

[9]

G. Barish, C.A. Knoblock, "Speculative Plan Execution for Information Gathering," Artificial Intelligence, 2008, Vol.172(4-5), p.413--453.

Digital Library

[10]

G. Barish, C.A. Knoblock, "Speculative Execution for Information Gathering Plans," AIPS Conf. Proceedings, Toulouse, 2002, p.184--193.

[11]

V. Hristidis, Y. Papakonstantinou, "Algorithms and Applications for answering Ranked Queries using Ranked Views," VLDB Journal, 2004, Vol.13(1), p.49--70.

Digital Library

[12]

A. Estebanez, D.R. Llanos, A. Gonzalez-Escribano, "A Survey on thread-Level Speculation Techniques.", ACM Computing Surveys, Vol. 49(2), 2016, p.22--39.

Digital Library

[13]

A.Kejariwal, X.Tian, W.Li, M.Girkar, S.Kozukhov, H. Saito, U. Banerjee, A.Nicolau, A.V. Veidenbaum, C.D. Polychronopoulos, "On the performance potential of different types of speculative thread-level parallelism.", International Conference on Supercomputing Proceedings, 2006, Cairns, p.24.

Digital Library

[14]

J. Šilc, T. Ungerer, B.Robi č, "Dynamic branch prediction and control speculation.", Int. Journal of High Performance Systems Arch., 2007, Vol. 1(1), p.2--13.

Digital Library

[15]

S.T. Pan, K. So, J.T. Rahmeh, "Improving the accuracy of dynamic branch prediction using branch correlation.", International Conference on Architectural Support for Programming Languages and Operating Systems, 1992, Boston, p.76--84.

Digital Library

[16]

A. Moshovos, S.E. Breach, T. N. Vijaykumar, G.S. Sohi, "Dynamic Speculation and Synchronization of Data Dependences.", 24th ISCA, ACM SIGARCH Computer Architecture News, 1997, Vol.25(2).

[17]

P.K. Reddy, M. Kitsuregawa, "Speculative locking Protocols to Improve Performance for Distributed Database Systems," IEEE Transactions on Knowledge and Data Engineering, 2004, Vol.16(2), p.154--169.

Digital Library

[18]

T. Ragunathan, R.P. Krishna, "Performance Enhancement of Read-only Transactions Using Speculative Locking Protocol," IRISS, Hyderabad, 2007.

[19]

T. Ragunathan T, R.P. Krishna, "Improving the performance of Read-only Transactions through Asynchronous Speculation," SpringSim Conference Proceedings, Ottawa, 2008, p.467--474.

[20]

X.Ge, B.Yao, M.Guo, et al., "LSShare: an efficient multiple query optimization system in the cloud", Distrib. Parallel Databases, Vol.32(4), p. 593--605, 2014.

Digital Library

[21]

M.B.Chaudhari, S.W.Dietrich, "Detecting common subexpressions for multiple query optimization over loosely-coupled heterogeneous data sources", Distrib. Parallel Databases, Vol.34, p.119--143, 2016.

Digital Library

[22]

S.Y.Su, Y.Huang, N.Akaboshi, "Graph-Based Parallel Query Processing and Optimization Strategies for Object-Oriented Databases", Distributed and Parallel Databases, Vol.6(3), p. 247--285, 1998.

Digital Library

[23]

G.Preti, M.Lissandrini, D.Mottin, Y.Velegrakis, "Mining patterns in graphs with multiple weights", Distributed and Parallel Databases, Special Issue on extending Database Technology, p.1--39, 2019.

[24]

O.Goonetilleke, D.Koutra, K.Liao, T.Sellis, "On effective and efficient graph edge labeling", Distributed and Parallel Databases, Vol.37, p.5--38, 2019.

Digital Library

[25]

H.M. Faisal, M.A. Tariq, Atta-ur-Rahman, A. Alghamdi, N. Alowain, "A Query Matching Approach for Object Relational Databases Over Semantic Cache", Chapter in Application of Decision Science in Business and Management, 2020.

[26]

M. Ahmad, M. A. Qadir, M. Sanaullah, "Query Processing Over Relational Databases with Semantic Cache: A Survey", 2008 IEEE International Multitopic Conference, Karachi, 2008, pp. 558--564.

[27]

F. Wang, G. Agrawal, "Query Reuse Based Query Planning for Searches over the Deep Web", Database and Expert Systems Applications. DEXA 2010. LNCS, Vol 6262, 2010.

[28]

J.Gryz, "Query Optimization and Caching", Research Interests and Related Publications, Department of Computer Science York Univ., Toronto, Canada, 1998.

[29]

P. Cybula, K. Subieta, "Query Optimization by Result Caching in the Stack-Based Approach", Objects and Databases. ICOODB 2010, LNCS, Vol.6348, 2010.

[30]

A.Sasak-Okoń, Speculative query execution in Relational databases with Graph Modelling, Proceedings of the FEDCSIS, pp.1383--1387, ACSIS, Vol. 8., 2016.

[31]

A.Sasak-Okoń, M.Tudruj, Graph-Based speculative Query Execution in Relational Data-bases, ISPDC 2017, July 2017, Innsbruck, Austria, CPS, IEEE Explore.

[32]

A.Sasak-Okoń, M.Tudruj, Graph-Based speculative Query Execution for RDBMS, PPAM 2017, LNCS, vol 10777. Springer, Cham

[33]

A.Sasak-Okoń, Modifying Queries Strategy for Graph-Based Speculative Query Execution for RDBMS, PPAM 2019, LNCS, Vol. 12043, pp. 408--418, 2020.

[34]

TPC benchmarks, http://www.tpc.org/tpch/default.asp, 2015.

[35]

G. Koutrika, A. Simitsis, Y. Ioannidis, "Conversational Databases: Explaining Structured Queries to Users", 2009, Tech. Report Stanford InfoLab.

[36]

G. Koutrika, A. Simitsis, Y. Ioannidis, "Explaining Structured Queries in Natural Language.", ICDE Conference Proceedings, Long Beach, 2010, p. 333--344.

Cited By

Sasak-Okoń ATudruj M(2024)Improving speculative query execution support by the use of the hypergraph representationFuture Generation Computer Systems10.1016/j.future.2023.07.030150(186-201)Online publication date: Jan-2024
https://doi.org/10.1016/j.future.2023.07.030
Sasak-Okoń ATudruj M(2023)RDBMS Speculative Support Improvement by the Use of the Query Hypergraph RepresentationParallel Processing and Applied Mathematics10.1007/978-3-031-30442-2_8(95-109)Online publication date: 28-Apr-2023
https://doi.org/10.1007/978-3-031-30442-2_8

Index Terms

Speculative query execution in RDBMS based on analysis of query stream multigraphs
1. Computing methodologies
  1. Parallel computing methodologies
2. Information systems
  1. Data management systems
    1. Database management system engines
      1. Database query processing
        Query optimization

Recommendations

Improving speculative query execution support by the use of the hypergraph representation
Abstract
Speculative support for query execution in Relational Database Management Systems (RDBMSs) based on a graph-analytic approach is the subject of this paper. Optimized speculative queries are defined by analyzing graph representations of a stream ...
RDBMS Speculative Support Improvement by the Use of the Query Hypergraph Representation
Parallel Processing and Applied Mathematics
Abstract
The paper concerns the methodology for speculative support for query execution in Relational Database Management Systems (RDBMSs). It discusses and develops our proposal of supporting the RDBMS query execution based on a graph-based analytic ...
An evaluation of speculative instruction execution on simultaneous multithreaded processors

Modern superscalar processors rely heavily on speculative execution for performance. For example, our measurements show that on a 6-issue superscalar, 93% of committed instructions for SPECINT95 are speculative. Without speculation, processor resources ...

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences

IDEAS '20: Proceedings of the 24th Symposium on International Database Engineering & Applications

August 2020

252 pages

ISBN:9781450375030

DOI:10.1145/3410566

General Chairs:
Bipin C. Desai
Concordia University, Canada
,
Wan-Sup Cho
Chungbuk National University, Korea

Copyright © 2020 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 25 August 2020

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

IDEAS 2020

IDEAS 2020: 24th International Database Engineering & Applications Symposium

August 12 - 14, 2020

Seoul, Republic of Korea

Acceptance Rates

IDEAS '20 Paper Acceptance Rate 27 of 57 submissions, 47%;

Overall Acceptance Rate 74 of 210 submissions, 35%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

2
Total Citations
View Citations
55
Total Downloads

Downloads (Last 12 months)10
Downloads (Last 6 weeks)1

Reflects downloads up to 27 Jul 2024

Other Metrics

View Author Metrics

Citations

Cited By

Sasak-Okoń ATudruj M(2024)Improving speculative query execution support by the use of the hypergraph representationFuture Generation Computer Systems10.1016/j.future.2023.07.030150(186-201)Online publication date: Jan-2024
https://doi.org/10.1016/j.future.2023.07.030
Sasak-Okoń ATudruj M(2023)RDBMS Speculative Support Improvement by the Use of the Query Hypergraph RepresentationParallel Processing and Applied Mathematics10.1007/978-3-031-30442-2_8(95-109)Online publication date: 28-Apr-2023
https://doi.org/10.1007/978-3-031-30442-2_8

View Options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents