According to the text2
sql method based on
large model ensemble learning, after hyper-parameters K, RT, TN, RC, CN and MoeN are obtained, the hyper-parameters are divided into two hyper-parameter groups, the hyper-parameter groups are used for training, the K can be used for fine adjustment of a Schema-linking model, an initial PreTC set containing an initial table name and a column name is obtained by
processing a user question, and the initial PreTC set is used for training. The initial PreTC set can be supplemented according to RT, TN, RC and CN to obtain an initial FinTC set, MoeN is used for training an
SQL generation model, the trained
SQL generation model can process a user problem and the initial FinTC set, an optimal hyper-parameter set with a good effect is obtained based on comparison of
processing results, and the optimal hyper-parameter set can be used for
processing the user problem and the initial FinTC set. K and MoeN in the optimal hyper-parameter set are used for generating more candidate tables and columns by the Schema-linking model and training the
SQL generation model, RT, RC or TN and CN can supplement the set, and the accuracy of SQL generation can be improved through careful design of the candidate tables and columns screened by the Schema-linking model and adjustment training of the SQL generation model.