The application relates to the technical field of
data analysis and
natural language processing, and discloses a multi-
source data analysis method, device, equipment and storage medium, the method comprising the following steps: integrating
metadata of a pre-accessed heterogeneous
data source, and constructing a global
logical data model; identifying semantic elements of a pre-acquired
natural language query statement, mapping the semantic elements to corresponding logical entities in the global
logical data model, and generating a structured intermediate representation; generating a unified
SQL query scheme comprising multiple
SQL sub-query statements based on the intermediate representation; distributing the
SQL sub-query statements to corresponding data sources in the heterogeneous
data source for execution, and acquiring execution results of each
data source; uniformly calculating and
processing the execution results of each data source, generating a unified
result set, and outputting the unified
result set in a preset format. The application realizes the simplification of multi-source heterogeneous
data analysis through
natural language interaction and SQL generation.