Text2sql optimization method based on dimension model modeling

The invention provides a text2sql optimization method based on dimension model modeling. The method comprises the following steps: S1, analyzing a text2sql application service scene, defining an application field, collecting a capability problem set, and determining a data demand and a service process; s2, performing word segmentation processing on the ability problem set, and listing an entity table; s3, determining facts, dimensions and corresponding attributes of the digital model of the dimension model; s4, constructing a dimension model bus matrix according to the dimension model; s5, constructing an entity information table for the dimension model, and converting the entity information table into an entity dictionary; s6, constructing a dictionary-based named entity recognition model, and recognizing entities, related tables, association conditions, query conditions and grouping fields in the question sentences; s7, constructing an aggregation function judgment model to identify an aggregation function