Research on SQL statement optimization rules for relational heterogeneous database

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.