Research on SQL statement optimization rules for relational heterogeneous database

Yanming Zhang; Wenjie Zhao

doi:10.1117/12.2683349

26 June 2023 Research on SQL statement optimization rules for relational heterogeneous database

Yanming Zhang, Wenjie Zhao

Proceedings Volume 12721, Second International Symposium on Computer Applications and Information Systems (ISCAIS 2023); 127210Q (2023) https://doi.org/10.1117/12.2683349
Event: 2023 2nd International Symposium on Computer Applications and Information Systems (ISCAIS 2023), 2023, Chengdu, China

Abstract

In the single-type relational database scenario, using SQL statement optimization rules can effectively shorten the statement execution time. In the heterogeneous database scenario, the effectiveness of SQL statement optimization rules needs to be further explored. Connect the relational heterogeneous database through Calcite, and use predicate push down, constant transfer and sub-query de-nesting rules to optimize SQL statements. The experiment shows that the optimized SQL statement can effectively shorten the execution time in the scenario of relational heterogeneous database.

Citation Download Citation

Yanming Zhang and Wenjie Zhao "Research on SQL statement optimization rules for relational heterogeneous database", Proc. SPIE 12721, Second International Symposium on Computer Applications and Information Systems (ISCAIS 2023), 127210Q (26 June 2023); https://doi.org/10.1117/12.2683349

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available