The invention discloses a query intention understanding and execution path
optimization system and method based on a multi-
modal deep learning model, and the method comprises the steps: a multi-
modal intention analysis module is used for receiving unstructured query input from a user, and uniformly extracting the unstructured query input as a standardized
SQL; the cross-model intention recognition module is used for receiving the standardized
SQL output by the multi-mode intention analysis module, recognizing a
data entity, an operation type and a
data model to which the
data entity and the operation type relate in a query intention, and outputting an entity structure table and a
query plan tree; the access mode analysis module is used for using the
query plan tree, identifying a connection relationship between node objects in the tree by contrasting with an entity structure table, performing cost
estimation on access of each node in the tree, and constructing a logic plan tree; and the path optimization generation module is used for executing generation, evaluation and screening of candidate execution paths on the basis of the logic plan tree output by the analysis module, and finally determining an optimal
execution plan. According to the method, the problems of semantic analysis, cross-model query intention recognition and execution path intelligent selection of complex inputs such as natural languages in a multi-mode
database can be solved, and the query accuracy and the execution efficiency are improved.